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?
To restore and recover a data file in a physical standby database while it is in the MOUNT state, the following steps are required: first, you must stop the redo apply process; second, restore the missing data file using the RMAN RESTORE DATAFILE command; and third, restart the redo apply process. Recovering the entire database with RMAN RECOVER DATABASE is unnecessary in this specific case since only the data file needs to be recovered.
Right answer is D,C,B. RECOVER DATABASE;-- Not nead to do this
Answer: B, C y D
E is not required, only you need is stop, restore and start to apply the redolog shipped to the standby. Right answare: B, C & D
BCD correct
Answer B,C,D
yes i agree. as per Oracle data guard best pratices, when it comes to datafile only, there is no need to recover database.
actually this should be 4 steps 1. stop redo 2. recover datafile 3. restore datafile 4. start redo or restart redo
Agreed with Kamaelk, As per Oracle 12c, we only need to stop Redo Apply , restart db in mount state and connect to RMAN catalog, restore data file and then restart redo apply.