Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user?
A.
Real Time Query must be enabled on the primary database.
B.
Real Time Query must be enabled on the physical standby database.
C.
If a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.
D.
If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved.
E.
If a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.
F.
If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.
Explanation:
B: For automatic block media recovery to work, a physical standby database must be in real-time query mode, which requires an Oracle Active Data Guard license.
D: A physical standby database operating in real-time query mode can be used to repair corrupt data blocks in a primary database.
C: If corruption occurs on the primary database, blockmedia recovery is performed automatically using a good copy of the block from the standby database and
vice versa.https://ora600tom.wordpress.com/2013/09/07/abmr-automatic-block-media-recovery
10.2.1.5 Automatic Block Media Recovery
If corrupt data blocks are encountered when a database is accessed, they can be automatically replaced with uncorrupted copies of those blocks. This requires the following conditions:
The physical standby database must be operating in real-time query mode, which requires an Oracle Active Data Guard license.
The physical standby database must be running real-time apply.
Automatic block media recovery works in two directions depending on whether the corrupted blocks are encountered on the primary or on the standby.
B,C,D
B, C and D Correct