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

Which two statements are true about block media recovery in a Data Guard environment? (Choose two.)

Answer options

• A. When using RMAN, the RECOVER CORRUPTION LIST command can automatically use blocks from flashback logs.
• B. A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has the Real-Time Query enabled.
• C. DB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery.
• D. When using RMAN, the RECOVER CORRUPTION LIST command can use blocks from change tracking files.
• E. DB_LOST_WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery.

Correct answer: B, D

Explanation

Option B is correct because a corrupt block on the primary can indeed be restored from a physical standby database with Real-Time Query enabled. Option D is also correct as the RECOVER CORRUPTION LIST command in RMAN can use blocks from change tracking files. The other options are incorrect regarding the requirements and functionalities of block media recovery in a Data Guard environment.