Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 5

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it.
All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter.
Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

Answer options

• A. Recover the datafile by using the RMAN RECOVER DATAFILE command
• B. Restart the redo apply.
• C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
• D. Stop the redo apply.
• E. Recover the database by using the RMAN RECOVER DATABASE command.

Correct answer: C, D, E

Explanation

The correct steps involve first stopping the redo apply (D), then restoring the datafile (C), and finally recovering the database (E). Option A is incorrect because it does not pertain to the specific recovery of the missing datafile. Option B is incorrect as you do not restart the redo apply until after the restore and recovery process is complete.