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...
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.
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?