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

You created the PRODSBY1 physical standby database for the PROD primary database using SQL and RMAN.

You are planning to create a Data Guard Broker configuration.

You execute the command:

DGMGRL> CREATE CONFIGURATION ‘DGConfig’ AS
> PRIMARY DATABASE IS ‘PROD’
> CONNECT IDENTIFIER IS PROD;

Which three statements are true regarding the execution of the command? (Choose three.)

Answer options

• A. The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
• B. The command will execute successfully only if the DG_BROKER_START initialization is set to TRUE for the PROD database instance.
• C. The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START IS TRUE for PRODSBY1.
• D. The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
• E. The PRODSBY1 standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBY1 database instance is defined on the primary host.
• F. The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBY1 database instances are defined on the primary host.

Correct answer: A, B, D

Explanation

Option A is correct because successful execution requires Oracle Net connectivity to the PROD instance. Option B is also correct as the DG_BROKER_START must be set to TRUE for the PROD instance to proceed. Option D is right since the configuration files are created based on the specified initialization parameters. The other options do not meet all necessary conditions for the command to execute successfully.