Which two are prerequisites for creating a backup-based duplicate database?

Question

Options

• Aconnecting to the target database and a recovery catalog to execute the duplicate command
• Bcreating a password file for an auxiliary instance
• Cconnecting to an auxiliary instance
• Dmatching the database identifier (DBID) of the source database and the duplicate database
• Ecreating an SPFILE for the target database

• A
  2% (1)
• B
  87% (46)
• D
  8% (4)
• E
  4% (2)

Explanation

For a backup-based RMAN duplicate, the auxiliary instance must be running and reachable, which requires a password file (B) for RMAN to authenticate its connection, and you must explicitly connect to that auxiliary instance (C) in the RMAN DUPLICATE command syntax - these are the two non-negotiable setup steps before duplication can proceed.

Why the distractors are wrong:

• A is wrong on two counts: backup-based duplication does not require a target database connection (that's active duplication), and a recovery catalog is optional, not required.
• D is wrong because RMAN intentionally assigns a new DBID to the duplicate - matching DBIDs would cause conflicts, not enable duplication.
• E is wrong because an init file is needed for the auxiliary instance (not the target), and a minimal PFILE is sufficient - there is no SPFILE requirement.

Memory tip: Think "Auxiliary needs Auth" - the two prerequisites both relate to the auxiliary instance: give it a password file (auth) and connect to it. The target and catalog are the active-duplication requirements you might confuse these with.

No community discussion yet for this question.