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 Iog_archive_dest_I parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?
A.
Recover the datafile by using the RNIAN RECOVER DATAFILE command
B.
Restart the redo apply.
C.
Restore the datafile by using the RNIAN RESTORE DATAFILE command.
D.
Stop the redo apply.
E.
Recover the database by using the RMAN RECOVER DATABASE command.
incorrect,
if all archive logs are available (needed for recovery), DCB
(in case of lost archivelogs: DCEB)
source: dataguard study guide 11g(pg 14-23)
Correct: D, C, B
In Dataguard Study Guide 12c, 15-24
There is also unpublished similar question with fourth answer – recover & to valid SCN
D, C, B
B, C and D