Oracle Database 12c: Advanced Administration — Question 67

Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?

Answer options

• A. The SPFILE is copied along with the data files of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
• B. A backup of pdbi and pd35 must exist before executing the command.
• C. The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.
• D. The root and the seed database in the container database (CDB) are also duplicated
• E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Correct answer: A, E

Explanation

Option A is correct because the DUPLICATE command does indeed copy the SPFILE along with the data files of the specified PDBs, and it also duplicates the root and seed databases. Option E is also correct as an auxiliary instance must be started with the appropriate parameter to enable the duplication of PDBs. The other options are incorrect because they either state requirements that are not necessary (like B) or describe processes that are not how the DUPLICATE command functions (like C and D).