Backups are NOT obsoleted when KEEP is used for all backups (Doc ID 1518986.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Goal

It is often tempting to set a KEEP time on all backups to ensure they are not inadvertantly deleted when 'delete obsolete' is run but KEEP really needs to be used only for very specific circumstances ie where there is a need to keep a backup for a long period, much longer than the usual recovery window.  An example would be where there is a statutory requirement to keep a a copy of a database from a particular time, say  5 years, for legal reasons.    KEEP should never be used for ALL backups and doing so will cause RMAN archivelog backups NEVER be obsoleted - this note will explain why.
 

Solution

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