Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?
Correct Answer: D,E
In the context of Oracle Data Guard and container databases (CDBs) managed by Data Guard Broker:
* All broker actions execute at the root container for container databases (D): When using Data Guard Broker to manage a CDB, the actions performed by the broker are executed at the level of the root container. This is because the root container maintains the control and configuration information that applies to the entire CDB, including all of its pluggable databases (PDBs).
* After a role change, the broker opens all Pluggable databases (PDBs) on the new primary (E):
Following a role transition such as a switchover or a failover, Data Guard Broker ensures that all PDBs within the CDB of the new primary database are opened, which is essential to resume operations of the PDBs without manual intervention.References:
* Oracle Data Guard Broker documentation
* Oracle Multitenant Administrator's Guide