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
B,C,D are correct answers
B,C,D
The Automatic Block Repair feature enables block media recovery to use blocks from a physical standby database to perform the recovery without manual intervention. The physical standby database must have real-time query enabled to take advantage of this feature.
When a query is executed on a physical standby database configured with real-time query and a corrupted block is detected, a valid block is retrieved from the primary database.
When a corrupted block is detected during a recovery operation on the standby database, the recovery process will retrieve a valid block from the primary database.
This feature reduces the amount of time that production data cannot be accessed due to block corruption by automatically repairing the corruption as soon as it is detected. Block recovery time is reduced because up-to-date good blocks from a real-time, synchronized physical standby database are used rather than blocks from disk or tape backups or flashback logs.
Automatic Block Repair also enables the automatic repair of corrupt blocks on the physical standby database. Block media recovery is performed by using blocks retrieved from the primary database. Real-time query must be enabled on the physical standby database to take advantage of this feature.
B,C,D