Which three are true about block media recovery? (Choose three.)

The correct answer is A. The data file containing the block being recovered remains online. B. To use it, Flashback Database must be enabled. C. A block being recovered is not accessible. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media- recovery.html#GUID-C1164158-496C-4D8A-8A06-D343935FC3B9 It tells that flashback is a must "Flashback Database must be enabled on the target database for RMAN to search the flashback logs for…

Perform Advanced RMAN Concepts

Question

Options

AThe data file containing the block being recovered remains online.
BTo use it, Flashback Database must be enabled.
CA block being recovered is not accessible.
DIt can be performed on noncorrupt blocks.
EThe target database for which one or more blocks are to be recovered must be in the OPEN
FIt cannot repair logical corruption.

How the community answered

(24 responses)

A
71% (17)
D
8% (2)
E
17% (4)
F
4% (1)

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media- recovery.html#GUID-C1164158-496C-4D8A-8A06-D343935FC3B9 It tells that flashback is a must "Flashback Database must be enabled on the target database for RMAN to search the flashback logs for good copies of corrupt blocks." It also says "Block media recovery may not be able to repair all logical block corruptions. In these cases, alternate recovery methods, such as tablespace point-in-time recovery, or dropping and re-creating the affected objects, may repair the corruption."

Topics

#block media recovery#block corruption#data file online#Flashback Database

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice