Archivelog mode and redolog recovery
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
There are two situations:
The Redo Logfile was current
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
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.