Exam 1z0-066 topic 1 question 31 discussion

Actual exam question from Oracle's 1z0-066

Question #: 31
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: BC 🗳️
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

by Rogazan at Aug. 9, 2021, 5:51 p.m.

Comments

Submit Cancel

ScottL

1 year, 3 months ago

Selected Answer: CE

Force logging is required to create the standby, not to create a broker config. Therefore, B incorrect. See Rogazan response

upvoted 1 times

...

JESUSBB

2 years, 5 months ago

Answer: C and E

upvoted 3 times

...

Rogazan

3 years, 6 months ago

CE https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dgbkr/oracle-data-guard-broker-installation-requirements.html. 2.2 Prerequisites The value of the DG_BROKER_START initialization parameter must be set to TRUE (C True) 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 (E True) The primary database must be opened in ARCHIVELOG mode, But it doesn't say anything about FORCE LOGING (B False)

upvoted 4 times

Sugar

3 years, 3 months ago

agree C E

upvoted 2 times

...

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam