Recovery on a New Machine

From: Nancy Wells <nancy_b_wells_at_hotmail.com>
Date: 17 Sep 2002 02:42:26 -0700
Message-ID: <1f14c0b1.0209170142.37a9e10e@posting.google.com>

I have a database running in archive log mode and i have taken a cold backup on sunday night.

Mon/Tue/Wednesday, database is used. Lot of archive files are generated...

Wedneday afternoon , database machine is crashed.

Only option is to set up a new machine and restore the datbase from the sunday cold backup:

What is the procedure to restore on a new machine? Just resotore all the cold backup data files, control files and init.ora (including Redo logs?) and start the instance?

How do i recover the Mon-Wed data from the archive logs? My guess is: Since i've restored from a cold backup (Sundays), my control file will also be sundays. Do i need to replace it with a latest copy (preferably Wednessday before crash). From that point can i recover as usual...

Thank you very much for your answers.

N Wells Received on Tue Sep 17 2002 - 04:42:26 CDT