Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?
Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?
To enable Automatic Block Media Recovery in a Data Guard environment, connectivity between the primary and the physical standby database is essential because the repair mechanism relies on communication between the primary and standby databases. Additionally, the physical standby database must have Real-Time Apply enabled to ensure that the corrupted blocks can be automatically repaired using the latest data. Flashback Database, whether on the primary or standby database, is not a prerequisite for this specific feature.
Answer: B and D
Flashback Database is not required to automatic recover block. Connectivity and Real Time Query are mandatory. Logical standby is not possible to used for this feature
Flashback may not be required: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-block-media-recovery.html#GUID-C1164158-496C-4D8A-8A06-D343935FC3B9 A. - Flashback database used, but I don't think it is a must have. B. - TRUE C. Flashback database used, but I don't think it is a must have. D. - TRUE - Real time apply and Real Time Query are pre-requisites E. - Logical standby - cannot be used Corrupted blocks in the primary database are automatically repaired by using blocks from a physical standby database. Corrupted blocks in the physical standby database are automatically repaired by using blocks from the primary database Real-time query and Active Data Guard must be enabled on the physical standby database Search for usable blocks for the recovery proceeds as follows: 1. Physical standby database 2. Flashback logs 3. Blocks in full or level 0 incremental backup
B and D
B and D are correct: https://blog.dbi-services.com/automatic-block-media-recovery-in-a-dataguard/