Oracle Database Administration II — Question 77

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

Answer options

• A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
• B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
• C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
• D. A user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate it.
• E. CDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated.

Correct answer: A, E

Explanation

Option A is correct because RMAN allows for multiple PDBs to be duplicated in a single command. Option E is also correct as the duplication of a PDB includes CDB$ROOT and PDB$SEED. Options B, C, and D are incorrect because not all tablespaces must be duplicated, the auxiliary instance does not automatically have ENABLE_PLUGGABLE_DATABASE set to TRUE, and it is not necessary for the user to be logged into the PDB for duplication.