1Z0-076 practice question 2 of 25

You created two remote physical standby databases using SQL and RMAN. The primary database is a four-instance RAC database and each physical standby…

You created two remote physical standby databases using SQL and RMAN. The primary database is a four-instance RAC database and each physical standby database has two instances. Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure. Consider these operational requirements: • The ability to manage multiple standby databases with a single tool • The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases • The automation of failovers to a specified target standby database Which TWO tools can be used to fulfill these requirements7

Answer options

A. RMAN

B. SQL*Plus

C. CRSCTL

D. Enterprise Manager Cloud Control

Correct answer

E. DGMGRL

Correct answer

F. SRVCTL

G. GDCCTL

Correct Answer:

D. D. Enterprise Manager Cloud Control; E. E. DGMGRL

Explanation

The Data Guard Broker is the Oracle framework designed to simplify the management and monitoring of a Data Guard configuration. It automates complex tasks and provides a single point of control. The broker can be managed through two interfaces: the command-line interface DGMGRL and the graphical interface provided by Enterprise Manager Cloud Control. Both tools can manage multiple standby databases, simplify role transitions (switchover, failover), handle reinstatements, convert to snapshot standbys, and automate failover using Fast-Start Failover.

Why Incorrect

A. RMAN is used for backup, recovery, and database duplication (including standby creation), not for managing Data Guard role transitions or broker automation.
B. SQLPlus can execute the underlying commands for role transitions, but it does not simplify or automate the process; it is entirely manual.
C. CRSCTL is a Clusterware utility used to manage cluster resources, not Data Guard configurations.
F. SRVCTL is a utility for managing RAC databases and their services, not for Data Guard role management.
G. GDCCTL is not a standard Oracle tool for Data Guard management.

References

1. Oracle Data Guard Broker, 19c, E96602-13, Chapter 1, "Introduction to Oracle Data Guard Broker". This chapter introduces the broker and its two clients: "Oracle Enterprise Manager Cloud Control... and the Oracle Data Guard command-line interface (DGMGRL)".

2. Oracle Data Guard Broker, 19c, E96602-13, Section 1.2, "Oracle Data Guard Broker Management Model". This section details how the broker simplifies switchovers, failovers, and other management tasks.

3. Oracle Data Guard Broker, 19c, E96602-13, Chapter 4, "Enabling Fast-Start Failover". This chapter describes how to use the broker (via DGMGRL or Enterprise Manager) to automate failovers.

Keep practicing

Take the free 1Z0-076 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test