To simulate this scenario we will combine a media failure also. When we restore the damaged datafile and start the recovery process we realise that one of the archived redo log files needed for recovery is missing. In this case we will have to do a Cancel-based recovery, cancelling the operation when Oracle prompts for the missing archived log file.

Restore the damaged datafile and start the recovery process after mounting the database.

We will get the errors:

ORA-00308 and ORA-07360 (which relate to a missing archived redo log file.)

Shutdown the instance and determine which of the arch files are missing.

SVRMGR> STARTUP MOUNT

SVRMGR> RECOVER DATABASE UNTIL CANCEL

Apply archived log files

Note the log sequence numbers - when the sequence number which relates to the missing archived redo log file is prompted by Oracle, cancel the operation at that stage.

CANCEL

SVRMGR> ALTER DATABASE OPEN RESETLOGS;