Oracle Exam 1Z0-066 Topic 8 Question 54 Discussion

Actual exam question for Oracle's 1Z0-066 exam

Question #: 54
Topic #: 8

[All 1Z0-066 Questions]

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? (Choose two.)

AThe standby database must have supplemental logging enabled.

BThe primary database must have FORCE LOGGING enabled.

CThe DG_BROKER_START parameter must be set to TRUE for both database instances.

DThe primary database must have supplemental logging enabled.

EA 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: B, C

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 Yuki at May 09, 2022, 11:34 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-066 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!