server crash and recover the database from the cold backup

[ashley75]

All,

could someone give the full instructions of how to recover your database if the server crash and you have to recover the database to different machine???

thanks

[aarroyob]

In wich platform?

[vinit]

was that a hot or cold backup
Install oracle software and move all your physical files . I assume the physical structure of your machine is the same(eg file paths, directories etc).

You will have to recover in any case (I hope your DB was running in archivelog mode).

svrmgrl
connect internal;
startup mount;
recover database;

This should see you through without any problems.

[aarroyob]

Originally posted by vinit
was that a hot or cold backup
Install oracle software and move all your physical files . I assume the physical structure of your machine is the same(eg file paths, directories etc).

You will have to recover in any case (I hope your DB was running in archivelog mode).

svrmgrl
connect internal;
startup mount;
recover database;

This should see you through without any problems.

Vinit you are talking about unix I think, because in NT/2000 there are more things to do before to start the database (create the service,define variables in the registry ...)

Cheers

Angel

[ashley75]

Vinit and all,

thanks all for advise, another quick question.

What if the structure of your computer is not the same ???

[aarroyob]

Copy all the datafile where you want, password file, tnsnames.ora,sqlnet.ora ...

1. Startup mount pfile....
2. Alter database rename datafile 'old_path' to new_path';
3. Alter database open;

Good Luck

Angel

[aarroyob]

Oh, logically the tnsnames.ora, listener.ora and sqlnet.ora are in $ORACLE_HOME/network/admin, the password file and init.ora are normally in $ORACLE_HOME/dbs.

Cheers

Angel

[sambavan]

Ashley & Others,

Please, don't just spin multiple threads on the same topic. Instead, if you have spun on on that, try to continue that thread until your problem or questions gets resolved. That way the thread would be more pragmatic, the forum would have a complete suggestions. If some one is to search, he/she would be able to find some meaning full answeres.

Please try to practice this.

Asley, I have taken the liberty to closed your other thread on this topic.

Ref: http://www.dbasupport.com/forums/sho...threadid=23023


Sam