Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 48

You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN.
Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

Answer options

• A. The standby database must have supplemental logging enabled.
• B. The primary database must have FORCE LOGGING enabled.
• C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
• D. The primary database must have supplemental logging enabled.
• E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

Correct answer: B, C

Explanation

The correct answer includes B and C because FORCE LOGGING on the primary ensures that all changes are logged, which is critical for Data Guard, and setting DG_BROKER_START to TRUE enables the Broker functionality on both instances. Options A, D, and E, while important for other functionalities, are not prerequisites specifically for the Data Guard Broker configuration.