QuestionQ2

Configuring and Managing Oracle Data Guard Broker

Which three conditions are required before using Data Guard Broker?

Choose three
  • A A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.
  • B Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.
  • C The primary and standby databases must run the same version of the Oracle Database server.
  • D The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.
  • E If any database in the configuration in a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.
  • F DG_BROKER_START must be set to TRUE for a database instance before adding the database to the broker configuration.
Explanation

Data Guard Broker requires the primary and standby databases to run the same Oracle Database version. DG_BROKER_START must be set to TRUE before a database participates in the broker configuration. For an Oracle RAC database, the DG_BROKER_CONFIG_FILEn parameters must reference the same shared broker configuration files for every instance of that RAC database; this requirement does not apply to non-RAC databases elsewhere in the configuration.

Learn more

Community Discussion

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