Printable View
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...
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.
Yup, the backup controlfile is actually the current controlfile. You use it as a backup controlfile so you can apply your archived redo logs.
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?
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...