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