Rman Does Not Report The Cumulative Incremental Backups as Obsolete.

(Doc ID 1272083.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Lets consider the following scenario.

++ The following backups are done everyday.

BS Key  Type LV Size  Device Type Elapsed Time Completion Time
------- ---- -- ----- ----------- ------------ ---------------
13      Incr 0  5.85G DISK        00:15:46     20-OCT-10

BS Key  Type LV Size  Device Type Elapsed Time Completion Time
------- ---- -- ----- ----------- ------------ ---------------
26      Incr 1  72.0K DISK        00:01:12     21-OCT-10

BS Key  Type LV Size  Device Type Elapsed Time Completion Time
------- ---- -- ----  ----------- ------------ ---------------
40      Incr 1  5.73M DISK        00:01:11     22-OCT-10

BS Key  Type LV Size  Device Type Elapsed Time Completion Time
------- ---- -- ----- ----------- ------------ ---------------
53      Incr 1  2.13M DISK        00:01:12     23-OCT-10

BS Key  Type LV Size  Device Type Elapsed Time Completion Time
------- ---- -- ----- ----------- ------------ ---------------
67      Incr 1  2.23M DISK        00:01:11     24-OCT-10

BS Key  Type LV Size  Device Type Elapsed Time Completion Time
------- ---- -- ----- ----------- ------------ ---------------
80      Incr 0  5.85G DISK        00:15:44     25-OCT-10


++ The Incremental level 1 reported above are cumulative backups.

++ The retention policy is recovery window of 2 days.

++ So as per the above backups if a report obsolete is executed on 25th of  October, the point of recoverability will be 23rd October. So the backups needed to recover the database at least till 23rd October are the 20th October level 0 backup and the 22nd October cumulative.

The 21st October cumulative backup will have to be obsolete since the changes contained in this backup are in the 22nd cumulative backup and this backup will no longer be used for recovery as per the retention policy.

The problem here is rman does not obsolete any of the cumulative backups taken after the level 0 backup which is not obsolete.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms