Which two statements are true for Data Guard environments with multi-tenant databases?

Which two statements are true for Data Guard environments with multi-tenant databases?

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



Leave a Reply 10

Your email address will not be published. Required fields are marked *


PeraDetlic

PeraDetlic

Correct: C,E

Wim J

Wim J

agree with C,E

Steff

Steff

Why not B? “opens all” in C is wrong for SEED PDB

Wim J

Wim J

the standby will never be open, at most read only.
you remark is in fact true for the seed.

Amit

Amit

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

edge

edge

C and I mean

JFK

JFK

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