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

By Oracle · Question Mode

QuestionQ18

Managing the Redo Transport Services

You must configure an Oracle Data Guard environment that contains:

  1. A primary database
  2. A physical standby database

Consider these requirements:

  1. No data loss is allowed.
  2. The physical standby database must be able to be converted to a snapshot standby database.
  3. During normal operation, transactions must commit when redo has been written to disk on the primary database and once it has been received by the standby database instance.
  4. Primary database availability must not be affected by standby database availability.
  5. The physical standby database must be able to be converted to a logical standby database.
  6. Real Application Clusters must be deployable on the primary database.
  7. Real Application Clusters must be deployable on the physical standby database.

You configure SYNC AFFIRM redo transport mode together with Maximum Protection mode.

Which requirements will you satisfy?

  • A 1, 2, 6, and 7
  • B 1, 2, 3, 4, 5, 6, and 7
  • C 1, 2, and 5
  • D 1, 2, 3, 6, and 7
  • E 1, 6, and 7
Explanation

Maximum Protection with synchronous affirmed transport guarantees zero data loss by requiring transaction redo to be written to the primary online redo log and persisted in a standby redo log on at least one synchronized physical standby before commit. If that standby is unavailable, the primary shuts down rather than permit unprotected commits. With only one standby, it cannot be converted to a snapshot standby while Maximum Protection remains in effect, because a snapshot standby cannot be the sole standby in that mode. Maximum Protection likewise requires a physical standby, not only a logical standby. Oracle Data Guard supports Oracle RAC for both primary and standby databases.

Learn more

Community Discussion

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