Re: Recovery on a New Machine

This is gonna be an incomplete recovery (you will miss all the transaction not recordered in archived logs)

Install the same version of oracle on another machine then restore your cold backup and copy the archived redo logs you have on the target machine, possibly using the same path then;

start the instance and mount it

issue
1)RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE 2)now oracle will generate the names of the archivedlogs it's missing on controlfile; apply all the archived logs you have and when finished type CANCEL now if successful you have to open the database resetting your redologs

3)ALTER DATABASE OPEN RESETLOGS; 4)check if everyhing is ok and take a full backup of your restored database;

I'm assuming you taken a backup of DB with OS Utilities , not RMAN

If you have Redo Logs up to date you can try to do a complete recovery just change the 2 command with this
ALTER DATABASE OPEN;
If it doesnt work telling you to open with reset logs issue 2 command

ciao

ps: better if you take some time reading the documentation about backup/recovery in oracle's www site. Received on Tue Sep 17 2002 - 05:41:43 CDT