| Reconstruct database from .dbf, .ctl files [message #71442] |
Sat, 02 November 2002 11:13  |
Pan El
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
Hi All,
I had an installation of Oracle and my data files on separate HDs.
Just before I make a backup, the installation HD failed. So after I reinstall oracle how can I reconstruct my old database from the (oradata ) .dbf, .ctl files ?
Thank you in advance.
Pan El
|
|
|
|
| Re: Reconstruct database from .dbf, .ctl files [message #71446 is a reply to message #71442] |
Mon, 04 November 2002 07:47  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
OS ? and release ?
if UNIX ...
just recreate init.ora... ( may need to delete lnk.ora )
start svrmgrl
try startup nomount ( shouldn't have any errors yet )
mount ( should be fine if all files are still here )
and open ( need to recover, apply archivelog )
if doesn't work give me errors messages
|
|
|
|
|
|
| Re: Reconstruct database from .dbf, .ctl files [message #71456 is a reply to message #71449] |
Tue, 05 November 2002 00:08 |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
Hi !
( don't know 9i on NT .. but this should work )
U should use Oradmin to reinstall OracleService[[SID]]
try to nomount ur database
mount ( see errors if any )
try to open ... ( may need to recover )
if recover needed apply all archivelog... and pray :-)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
