| Oracle 9i recovery [message #63059] |
Mon, 06 September 2004 13:22  |
Martin Berard
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
Hi all,
I'm pretty new to Oracle and would like to know how to recover a failed server.
I managed to restart my win2000 server from the deficient HD and would like to know how to recreate my Oracle DB.
By reading the forums and FAQ I did a copy of the v$datafile, v$logfile and v$controlfile from my v$database that I want to restore. I also have a copy of my init.ora. from the old server
I reintalled my Oracle database engine and created the database instance with the same SID that it had originally.
Once this process over I started my sql*plus console and did the following :
SQL> conn / as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
Then I copied my datafile, my logfile and my control file to my new server over the one created by Oracle during the databse creation process.
I recreate my admin folder with my database name and the following directory : bdump, cdump, create, pfile and udump.
in the pfile directory I copy my old init.ora file
and then try to restart my database using the startup command.
And then I tried to restart :
SQL> startup
ORA-03113: end-of-file on communication channel
Thanks for helping out
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
