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
Correct Ans: C, E
– Oracle Database Enterprise Edition
– Oracle Net Services network files: Must be configured for the primary database and any existing standby databases or Far Sync instances. Enterprise Manager Cloud Control configures files for new standby databases.
– GLOBAL_DBNAME attribute: Set to a concatenation of db_unique_name_DGMGRL.db_domain
– DG_BROKER_START initialization parameter: Set to TRUE
– Primary database: ARCHIVELOG mode
– All databases: MOUNT or OPEN mode
– DG_BROKER_CONFIG_FILEn: Configured for shared access for any RAC databases
– LOG_ARCHIVE_DEST_n parameters: Must be cleared on any instance when using SERVICE attribute before creating a broker configuration
C,E