Which two statements are true for Data Guard environments with multi-tenant databases?
A.
Different pluggable databases within a logical standby database may have different guard statuses.
B.
The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
C.
The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
D.
The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.
E.
A multi-tenant standby database can have fewer pluggable databases than the primary container database.
Explanation:
C: If you execute a switchover or failover operation, the entire CDB undergoes the role change.
D: To administer a multitenant environment, you must have the CDB_DBA role.https://docs.oracle.com/database/121/SBYDB/create_ps.htm
Correct: C,E
agree with C,E
Why not B? “opens all” in C is wrong for SEED PDB
the standby will never be open, at most read only.
you remark is in fact true for the seed.
Hi,
Is there any Oracle documentation that shows and mentions about
E – A multi-tenant standby database can have fewer pluggable databases than the primary container database
Also, D – CDB_DBA is a role and not a privilege
Hi
WIll choose
for me D is true http://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB00200
To administer a multitenant environment, you must have the CDB_DBA role.
Regards
C and I mean
C and D
D, E
D
Although CDB_DBA is a role,
E:
PDBs can be excluded from all or some standbys:
To specify whether the new PDB being created is included in standby CDBs, use the STANDBYS clause of the SQL CREATE PLUGGABLE DATABASE statement. Specify ALL (the default) to include the new PDB in all standby CDBs. Specify NONE to exclude the new PDB from all standby CDBs.
When a PDB is excluded from all standby CDBs, the PDB’s data files are offline and marked as unnamed on all of the standby CDBs. Any new standby CDBs that are instantiated after the PDB has been created must disable the PDB for recovery explicitly to exclude it from the standby CDB. It is possible to enable a PDB on a standby CDB after it was excluded on that standby CDB.
References:
https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB5260
D,E