Home » Oracle » 1z0-066 » Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?
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?
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: BC
Explanation/Reference:
B: Enabled forced logging on the primary database by issuing the following command.
ALTER DATABASE FORCE LOGGING;
-- Make sure at leat one logfile is present.
ALTER SYSTEM SWITCH LOGFILE;
C: Enable Broker
When we have a primary database and a standby database, we need to start using the Data Guard Broker to manage them. Connect to both databases (primary and standby) and issue the following command.
ALTER SYSTEM SET dg_broker_start=true;
References: https://oracle-base.com/articles/12c/data-guard-setup-using-broker-12cr1
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
CE