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.
B.
When there are already three backups, for the fourth backup RMAN marks the oldest
backup as obsolete.
C.
the number of backups that are retained is equal to three and it includes full, incremental,
and cumulative backups.
D.
when there are already three backup, one of the existing backups must be removed
manually before taking the fourth backup.
Explanation:
Configuring a Redundancy-Based Retention Policy
The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command
specifies how many full or level 0 backups of each data file and control file that RMAN
should keep. If the number of full or level 0 backups for a specific data file or control file
exceeds the REDUNDANCY setting, then RMAN considers the extra backups as obsolete.
The default retention policy is REDUNDANCY 1.
As you produce more backups, RMAN keeps track of which ones to retain and which are
obsolete. RMAN retains all archived logs and incremental backups that are needed to
recover the nonobsolete backups.
Assume that you make a full backup of data file 7 on Monday, Tuesday, Wednesday, and
Thursday. You now have four full backups of this data file.If REDUNDANCY is 2, then the
Monday and Tuesday backups are obsolete. If you make another backup on Friday, then the
Wednesday backup of data file 7 becomes obsolete. Assume a different case in whichREDUNDANCY is 1. You run a level 0 database backup at noon on Monday, a level 1
cumulative backup at noon on Tuesday and Wednesday, and a level 0 backup at noon on
Thursday. Immediately after each daily backup you run the command DELETE OBSOLETE.
The Wednesday DELETE command does not remove the Tuesday level 1 backup because
this backup is not redundant: the Tuesday level 1 backup could be used to recover the
Monday level 0 backup to a time between noon on Tuesday and noon on Wednesday.
However, the DELETE command on Thursday removes the previous level 0 and level 1
backups.
Run the CONFIGURE RETENTION POLICY command at the RMAN prompt, as in the
following example: CONFIGURE RETENTION POLICY TO REDUNDANCY 3;