Archivelog mode and redolog recovery
From Oracle FAQ
There are two situations:
The Redo Logfile was current[edit]
The redolog file under consideration was being written by LGWR when the crash occured.
- shutdown abort;
- Copy the intact backup of the redo logfile from the tape
- startup;
The Redo Logfile was Inactive[edit]
The redolog file under consideration was being sitting ideal, while the second set of redolog files were written.
- shutdown abort;
- Copy the intact backup of the redo logfile from the tape
- startup mount;
- Copy the Archive Files to required destination.
- recover database until cancel;
- alter database open resetlogs;
- Take a cold backup.
