Archivelog mode and redolog recovery

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.