nerdexam
Oracle

1Z0-067 · Question #107

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?

The correct answer is B. A backup of pdbi and pd35 must exist before executing the command. E. An auxiliary instance must be started with the initialization parameter. Do backups of the source database exist? The principal advantage of active database duplication is that it does not require source database backups. Active duplication copies mounted or online database files over a network to the auxiliary instance. One disadvantage of this…

New Features for Database Infrastructure and Architecture

Question

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?

Options

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

How the community answered

(65 responses)
  • A
    5% (3)
  • B
    72% (47)
  • C
    15% (10)
  • D
    8% (5)

Explanation

Do backups of the source database exist? The principal advantage of active database duplication is that it does not require source database backups. Active duplication copies mounted or online database files over a network to the auxiliary instance. One disadvantage of this technique is the negative performance effect on the network. Another disadvantage is that the source database is running processes required to transfer the files to the auxiliary host, thereby affecting the source database and production If the source database backups exist, and if the effect on the network is unacceptable, then backup-based duplication may be a better option. You can copy backups to temporary storage and transfer them manually to the destination host. If duplication is made with a connection to the target or the recovery catalog, then the backup files on the destination host must have the same file specification as they had on the source host. Otherwise, this is not a requirement.

Topics

#RMAN DUPLICATE#PDB duplication#auxiliary instance#selective PDB clone

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice