Archivelog mode and redolog recovery

From Oracle FAQ
Jump to: navigation, search

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.