Which three steps must be performed to restore the miss…

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 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.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Wim J

Wim J

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)

JFK

JFK

Correct: D, C, B
In Dataguard Study Guide 12c, 15-24

YK6

YK6

There is also unpublished similar question with fourth answer – recover & to valid SCN

JorgeZG

JorgeZG

B, C and D