RMAN doesn’t mark control file/spfile backup obsolete with retention policy set to redundancy

With RMAN configure controlfile autobackup set to ON, RMAN automatically creates a control file and an SPFILE backup after you run the BACKUP or COPY commands. If you have a daily backup task, you will see autobackup of control file and spfile created every day after your main backup. That is good, huh! They are supposed to be managed by the retention policy and deleted automatically when become obsolete. However, possibily due to bugs:

  • Bug 25943271 : RMAN REPORT OBSOLETE DOES NOT REPORT CONTROLFILE BACKUP AS OBSOLETE
  • Bug 26771767 : SPFILE BACKUP OR BACKUP PIECE INCLUDES SPFILE ARE NOT REPORTED AS OBSOLETE

They won’t be marked as obsolete when RMAN retention policy is configured as redundancy. For example:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

To work around this, change the rentention policy to recovery window and do a crosscheck on backup.

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

crosscheck backup;

delete obsolete;

Or delete autobackup explicitly after certain days.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s