Configuring Retention Policy

If you want to edit a retention policy for Oracle RMAN backups, you must connect to the target database in RMAN console and run set one of the following retention policies:

• Redundancy-Based Retention: The redundancy parameter specifies how many full or level 0 backups of each data file and control file should RMAN keep in the repository. If the number of backups exceeds the specified value, RMAN considers the oldest backups as obsolete. By default, the redundancy parameter is set to 1. To configure a redundancy-based retention policy, run the following command:

• Recovery Window-Based Retention: The recovery window parameter specifies the number of days between the current time and the earliest point of recoverability. RMAN does not consider any full or level 0 incremental backups as obsolete if it falls within the recovery window. To configure a window-based retention policy, run the following command:

Deleting Obsolete Backups

To delete obsolete backups, run the following command after each backup:

Disabling Retention Policy

To disable retention policy for RMAN backups, run the following command:

For details, see the Configuring the Backup Retention Policy section of the Oracle Database Backup and recovery User's Guide.