Which three are benefits of using the Data Guard Broker to manage standby databases?
A.
It simplifies physical standby database creation.
B.
It provides an easy failover capability using a single command.
C.
It coordinates database state transitions and updates database properties dynamically.
D.
It automatically changes database properties after the protection mode for a configuration is changed.
E.
It provides an easy switchover capability using a single command.
F.
It simplifies logical standby database creation.
G.
It load balances connections between the primary and all the standby database instances that are open as read-only for reporting.
Explanation:
BE: The broker simplifies switchovers and failovers by allowing you to invoke them using a single key click in Oracle Enterprise Manager or a single command atthe DGMGRL command-line interface (referred to in this documentation as manual failover).
C: The broker coordinates database state transitions and update database properties dynamically with the broker recording the changes in a broker configuration
file that includes profiles of all the databases in the configuration. The broker propagates the changes to all databases in the configuration and their server
parameter files.https://docs.oracle.com/cd/E11882_01/server.112/e40771/concepts.ht
Why is D incorrect?
“Why is D incorrect?”
That’s an interesting question. From the documentation, it specifically says:
“When you set values for database properties in the broker configuration, the broker records the change in the configuration file and propagates the change to all of the databases in the Data Guard configuration.”
However, if the question is specifically asking “using the Data Guard Broker to manage STANDBY DATABASES” – then the broker will not make any change on the STANDBY DATABASE following a change in protection mode. I am quite sure that it will make a change of property on the primary database (log_archive_dest_x specifically). This is the only reason I can imagine that D is “wrong”.
As given, BCE are all definitely correct.
B,C,E
D is bit confusing but I believe B,C,E are definite.
D is incorrect becasuse you cannot change protection mode if the redo transport properties are not set correctly.
Check Question 46