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?

Question

Options

• AThe SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root
• BA backup of pdb1 and pdb5 must exist before executing the command.
• CThe duplicate command first creates a backup, and then duplicates the PDBs by using the
• DA backup of CDB and pdb1 and pdb5 must exist before executing the command.
• EAn auxiliary instance must be started with the initialization parameter

• A
  8% (2)
• B
  29% (7)
• C
  50% (12)
• D
  13% (3)

Explanation

C is correct because when RMAN performs active database duplication (the default when connected to the target without specifying pre-existing backups), it automatically generates backup sets from the target's datafiles during the operation itself - no pre-existing backup of pdb1 or pdb5 is required beforehand. E is correct because RMAN's DUPLICATE command always requires an auxiliary instance to be pre-started (at minimum in NOMOUNT state) with initialization parameters such as DB_NAME pointing to the destination database; without this, RMAN has nowhere to restore the duplicate.

B and D are wrong for the same reason: both claim a pre-existing backup is mandatory, but active database duplication creates the backup sets on-the-fly during the command execution - there is no prerequisite backup requirement. A is wrong because it misrepresents what is copied alongside the PDB datafiles and overstates the role of the root container in that context - the description is inaccurate about SPFILE handling in the duplication flow.

Memory tip: Remember "AUX before ACTIVE" - you always need an AUXiliary instance pre-started (E), and RMAN ACTIVE duplication generates its own backup during the run (C), so never assume you need one sitting on disk beforehand.

No community discussion yet for this question.