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?
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.
Explanation:
Recovery from Loss of Datafiles on the Standby Database
1. Connect SQL*Plus to the standby database.
2. Stop Redo Apply using the SQL ALTER DATABASE … statement.
3. In a separate terminal, start RMAN and connect to both the standby and recovery catalog databases (use
the TARGET keyword to connect to the standby instance).
4. Issue the following RMAN commands to restore and recover datafiles on the standby database:
RESTORE DATAFILE <n,m,…>;
RECOVER DATABASE;
5. To restore a tablespace, use the RMAN ‘RESTORE TABLESPACE tbs_name1, tbs_name2, …’ command.
6. At the SQL*Plus prompt, restart Redo Apply using the SQL ALTER DATABASE … statement.References: https://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm
Correct Ans: D, C, B
⁃ To recover a data file on the standby database, you must restore the lost file to the standby database from the backup by using the RMAN RESTORE DATAFILE command, if all archived redo log files that are required for recovery of the file are accessible on disk by the standby database, you only need to restart Redo Apply.
⁃ If the archived redo log files that are required for recovery are not accessible on disk, use RMAN to recover the restored data files to an SCN or log sequence that is greater than the last log applied to the standby database. Next, restart Redo Apply to continue the application of redo data.
B,C,D