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.