nerdexam
Oracle

1Z0-062 · Question #170

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN): RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Identify the statement that correctly describes…

The correct answer is A. When there are already three backups, for the fourth backup RMAN marks the oldest backup as. The REDUNDANCY 3 retention policy causes RMAN to mark the oldest backup as obsolete when a fourth backup is created, rather than automatically deleting it.

Performing Backup and Recovery

Question

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Identify the statement that correctly describes the implications of this command. A, when there are already three backups, for the fourth backup RMAN removes the oldest backup.

Options

  • AWhen there are already three backups, for the fourth backup RMAN marks the oldest backup as
  • Bthe number of backups that are retained is equal to three and it includes full, incremental, and
  • Cwhen there are already three backup, one of the existing backups must be removed manually

How the community answered

(35 responses)
  • A
    89% (31)
  • B
    3% (1)
  • C
    9% (3)

Why each option

The REDUNDANCY 3 retention policy causes RMAN to mark the oldest backup as obsolete when a fourth backup is created, rather than automatically deleting it.

AWhen there are already three backups, for the fourth backup RMAN marks the oldest backup asCorrect

With REDUNDANCY 3, RMAN maintains exactly three valid backups at any time. When a fourth backup is taken, RMAN marks the oldest backup as obsolete - it does not automatically delete it, but flags it for removal via the DELETE OBSOLETE command at the DBA's discretion.

Bthe number of backups that are retained is equal to three and it includes full, incremental, and

The REDUNDANCY count applies to the number of complete backup sets or copies of the database, not a combined total that includes full, incremental, and archived log backups grouped together.

Cwhen there are already three backup, one of the existing backups must be removed manually

RMAN automatically manages the obsolete status of old backups without requiring manual removal before a new backup can proceed; only a subsequent DELETE OBSOLETE command is needed to reclaim space.

Concept tested: RMAN retention policy REDUNDANCY setting behavior

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-rman-backups.html

Topics

#RMAN#Backup retention policy#REDUNDANCY#Obsolete backups

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice