Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 51

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?

Answer options

• A. FLASHBACK DATABASE must be enabled on the physical standby database.
• B. There must be connectivity between the primary and the physical standby database.
• C. FLASHBACK DATABASE must be enabled on the primary database.
• D. The physical standby database must have Real-Time Apply enabled.
• E. The logical standby database must have Real-Time Query enabled.

Correct answer: B, D

Explanation

The correct prerequisites for enabling Automatic Block Media Recovery are that there must be connectivity between the primary and the physical standby database (B) and that Real-Time Apply must be enabled on the physical standby database (D). Options A, C, and E, while relevant to database functionality, are not necessary for this specific feature.