You created a physical standby database prodsbyi from the primary database prod using SQL and RMAN. Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?
A.
A local net service name to enable connectivity to the PRODSBYI database instance must be defined on the primary database host.
B.
The primary database must have supplemental logging enabled.
C.
The LOG_ARCHIVE_DEST_n parameters with the service attribute set must be cleared.
D.
The standby database must have supplemental logging enabled.
E.
The primary database must have FORCE LOGGING enabled.
F.
The DG_BROKER_START parameter must be set to TRUE for both database instances.
When setting up a Data Guard Broker configuration for a primary database and its physical standby, the following prerequisites must be met:
A: Oracle Net connectivity must be defined on both the primary and standby hosts to enable the respective database instances to communicate with each other.
B: Supplemental logging is required on the primary database because it provides additional logging necessary for the standby database to be able to apply changes from the primary database accurately.
F: TheDG_BROKER_STARTparameter must be set toTRUEfor both the primary and standby database instances. This parameter is used to start the Data Guard Broker process which manages the configuration.
Options C and D are not prerequisites for creating a Data Guard Broker configuration. Additionally, while FORCE LOGGING mode (option E) is recommended as a best practice to prevent possible data inconsistencies during media recovery, it is not a strict prerequisite for creating a Data Guard Broker configuration.
[References:This guidance is based on Oracle's best practices for setting up Data Guard configurations, as found in the Oracle Data Guard Broker documentation and the Oracle Data Guard Concepts and Administration guide., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit