Setting the Oracle RMAN Retention Policy

Your must follow this procedure when you use RMAN for data aging.

Change the data retention before you run your first backup, otherwise there is infinite retention by default.

You can set the retention policy to the number of backups you want to retain. You can change this value anytime. The new retention policy setting applies to backups taken after the change.

Procedure

  • From the RMAN command line, execute an RMAN script similar to the one below to set the number of backups that must be retained.
  • CONFIGURE RETENTION POLICY TO REDUNDANCY <num_backups>;

    The num_backups parameter specifies the number of backups to retain.

Example

The following example sets the number of backups that must be retained to 2.

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;