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

By Oracle · Question Mode

QuestionQ19

Managing the Redo Transport Services

A Data Guard configuration has the following components and settings:

  1. A primary database
  2. A remote physical standby database
  3. Real-time query enabled
  4. Synchronous redo transport mode
  5. Maximum Availability protection mode
  6. Data Guard Broker in use

The standby destination does not acknowledge receipt of redo within the NET_TIMEOUT period.

Which statement is true in this scenario?

  • A Real-time query will be disabled on the physical standby.
  • B The protection mode will automatically change to Maximum Performance.
  • C Synchronous redo transport mode connections to the standby database are terminated.
  • D The physical standby database instance is shut down by the Data Guard broker.
Explanation

For a synchronous redo transport destination, NET_TIMEOUT defines how long LGWR waits for acknowledgement of redo receipt. If no acknowledgement arrives within that interval, Oracle logs an error and terminates the redo transport session to that standby destination.

Learn more

Community Discussion

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