Which two are the prerequisites to perform this operation?

You need to perform a block media recovery on the tools01.dbf data file in the SALES
database by using Recovery Manager (RMAN).
Which two are the prerequisites to perform this operation? (Choose two)

You need to perform a block media recovery on the tools01.dbf data file in the SALES
database by using Recovery Manager (RMAN).
Which two are the prerequisites to perform this operation? (Choose two)

A.
You must configure block change tracking file

B.
You must have first level 1 backups for RMAN to restore blocks

C.
You must ensure that the SALES database is mounted or open

D.
You must have full or level 0 backups for RMAN to restore blocks

E.
You must take the tools01.dbf data file offline before you start a block media recovery

Explanation:
Prerequisites for Block Media Recovery (link)
The following prerequisites apply to the RECOVER … BLOCK command:
The target database must run in ARCHIVELOG mode and be open or mounted with a
current control file.
If the target database is a standby database, then it must be in a consistent state, recovery
cannot be in session, and the backup must be older than the corrupted file.

The backups of the data files containing the corrupt blocks must be full or level 0 backups
and not proxy copies.
If only proxy copy backups exist, then you can restore them to a nondefault location on disk,
in which case RMAN considers them data file copies and searches them for blocks during
block media recovery.
RMAN can use only archived redo logs for the recovery.
RMAN cannot use level 1 incremental backups. Block media recovery cannot survive a
missing or inaccessible archived redo log, although it can sometimes survive missing redo
records.
Flashback Database must be enabled on the target database for RMAN to search the
flashback logs for good copies of corrupt blocks.
If flashback logging is enabled and contains older, uncorrupted versions of the corrupt
blocks, then RMAN can use these blocks, possibly speeding up the recovery.
The target database must be associated with a real-time query physical standby database
for RMAN to search the database for good copies of corrupt blocks.



Leave a Reply 1

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


Jake from SF

Jake from SF

C and D are correct:

https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmblock.htm

For C:
Start RMAN and connect to the target database, which must be mounted or open.

For D:
You perform block media recovery with the RECOVER … BLOCK command. By default, RMAN searches the flashback logs for good copies of the blocks, and then searches for the blocks in full or level 0 incremental backups. When RMAN finds good copies, it restores them and performs media recovery on the blocks. Block media recovery can only use redo logs for media recovery, not level 1 incremental backups.