nerdexam
Oracle

1Z0-083 · Question #234

Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

The correct answer is A. The UNDO TABLESPACE clause is always required when no connection exists to the B. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary. When duplicating without a TARGET connection, RMAN relies entirely on accessible backup files rather than a live connection to the source database - so B is correct because disk-based backups on accessible storage can serve as the source for the auxiliary instance to restore…

Backup and Recovery

Question

Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Options

  • AThe UNDO TABLESPACE clause is always required when no connection exists to the
  • BRMAN disk-based backups of the database to be duplicated can be used by the auxiliary
  • CThe UNDO TABLESPACE clause is always required when no connection exists to the
  • DThe UNDO TABLESPACE clause is never required.
  • ERMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary

How the community answered

(26 responses)
  • A
    85% (22)
  • C
    8% (2)
  • D
    4% (1)
  • E
    4% (1)

Explanation

When duplicating without a TARGET connection, RMAN relies entirely on accessible backup files rather than a live connection to the source database - so B is correct because disk-based backups on accessible storage can serve as the source for the auxiliary instance to restore from. A is correct because without a TARGET connection, RMAN cannot query the source database's control file to auto-identify the undo tablespace, making the UNDO TABLESPACE clause explicitly required so RMAN knows which tablespace to handle appropriately.

C appears to replicate A's claim but is a distractor - only one version of this statement is the intended correct answer. D ("never required") is the direct opposite of the truth: the clause is required precisely when TARGET is absent. E describes the behavior of active duplication (which requires a TARGET connection), where RMAN pushes data over the network; without a TARGET, there is no source to push from - the auxiliary pulls from local/accessible backup locations instead.

Memory tip: Think "No TARGET = No auto-detection." Without a live target, RMAN goes blind to source metadata (hence you must name the UNDO tablespace yourself) and must use pre-existing disk backups - it cannot stream data live across the network like active duplication does.

Topics

#RMAN duplication#Auxiliary database#Disk backups#UNDO TABLESPACE

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice