1Z0-083 practice question 32 of 35

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

Full set: 286 questions
Answer options
A:

A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

Correct answer
B:

B. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

C:

C. RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.

D:

D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.

Correct answer
E:

E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

Correct answer
F:

F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

G:

G. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

H:

H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Correct answer
Correct Answer:
A. A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.; D. D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.; E. E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.; H. H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
Explanation

In a backup-based duplication without a target connection, RMAN uses pre-existing backups. These backups can reside on disk (H) or be managed by an SBT-compliant media manager (E), and they must be accessible from the auxiliary host. If the backup is of a database in NOARCHIVELOG mode, no archived logs are available for recovery, so the NOREDO clause is mandatory (A). The NOREDO clause is also a valid, though less common, option for ARCHIVELOG mode backups; it instructs RMAN to restore the files but skip the recovery phase, leaving the database in a state that requires crash recovery upon opening (D).

Why Incorrect

B. The UNDO TABLESPACE clause is required only if the target database was open when the backup was made, not in all cases.
C. "Pushing" backups from the target to the auxiliary describes active duplication, which requires a connection to the target database.
F. The UNDO TABLESPACE clause is not required if the target database was closed cleanly, as there are no active transactions to consider.
G. The requirement for the UNDO TABLESPACE clause depends on the target's state at backup time, not its current state or the use of a recovery catalog.

References

1. Oracle Database Backup and Recovery User's Guide, 19c, Chapter 25, "Duplicating a Database". The section "About Backup-Based Duplication Without a Target Connection" confirms that backups on disk or tape (SBT) can be used.

2. Oracle Database Backup and Recovery Reference, 19c, "DUPLICATE". The description of the NOREDO clause states: "This option is required if the target database was in NOARCHIVELOG mode when backed up. If you specify NOREDO for a database that was in ARCHIVELOG mode, then RMAN does not apply any archived redo logs." This confirms both A and D are true statements.

Scroll to Top