Which two are prerequisites for creating a Data Guard B…

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?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Chunn

Chunn

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