Recover from cold backup

[eyuan]

Has anyone tried to recover the database with a full offline backup and all the archived logs? Assume you have all the needed old files (datafile,control file...) and have lost all your current files except those archived logs. I know how to recover from hot backup, but for this one...

[marist89]

http://metalink.oracle.com/metalink/...T&p_id=69468.1

[eyuan]

Hi Jeff,

Thanks for the help.
Just want to confirm that the control file used in the scenario (from Metalink) is the old control file backed up at OS level, because I assume I cann't access the current database to create a up-to-date backup control file should there be some kind of fatal failure.

[marist89]

Yup, the backup controlfile is actually the current controlfile. You use it as a backup controlfile so you can apply your archived redo logs.

[eyuan]

Which means if I lost all the current files ( incl control file), I will not be able to recover the database using cold backup files plus archived logs, am I right? Can I restore all the datafile, create a new controle file ( using script from 'backup controlfile to trace' taken at cold backup time), and roll forward through all the archived logs? Every tried?

[marist89]

That's a different story. First, you need to create your controlfile. You can do this from a trace file. Check out http://metalink.oracle.com/metalink/...p_id=1014504.6 for details.

Once you have created your "backup controlfile", you can now recover through your last archived redo log file.

Unfortunately, I've done this dozens of times...