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.
Explanation:
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;https://oracle-base.com/articles/12c/data-guard-setup-using-broker-12cr1
B is a best practice, but not a must
9.3.4 Use FORCE LOGGING Mode
When the primary database is in FORCE LOGGING mode, all database data changes are logged. FORCE LOGGING mode ensures that the standby database remains consistent with the primary database. If this is not possible because you require the load performance with NOLOGGING operations, then you must ensure that the corresponding physical standby data files are subsequently synchronized. To synchronize the physical standby data files, either apply an incremental backup created from the primary database or replace the affected standby data files with a backup of the primary data files taken after the nologging operation. Before the file transfer, you must stop Redo Apply on the physical standby database.
C,E
https://docs.oracle.com/database/121/DGBKR/E48241-08.pdf
The value of the DG_BROKER_START initialization parameter must be set to TRUE. See
Section 3.4 for more information. (Cloud Control sets this parameter
automatically.)
Oracle Net Services network configuration files must be set up on the primary
database and on the standby database if you configure an existing standby
database into the broker configuration. Cloud Control can assist you in creating
the configuration files when creating a standby database.
C,E is correct.
B is incorrect. It is just for create a standby db, not for create a broker configuration.
C,E