1Z0-076: Oracle Database 19c: Data Guard AdministrationDemo

By Oracle · Question Mode

QuestionQ3

Monitoring a Data Guard Configuration

Which TWO statements are correct about block media recovery in a Data Guard environment?

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

Automatic Block Media Recovery in a Data Guard configuration lets the primary database automatically retrieve an uncorrupted copy of a data block from a physical standby database that is open in real-time query (Active Data Guard) mode, transparently repairing the corruption without manual RMAN intervention. Enabling this automatic repair additionally depends on setting the DB_LOST_WRITE_PROTECT initialization parameter to TYPICAL on both the primary and standby databases, which activates the redo-based block validation needed to detect and safely correct corrupt or lost-write blocks; FULL is not the documented setting required to enable this feature.

Community Discussion

No comments yet. Be the first to start the discussion!