Backups are NOT obsoleted when KEEP is used for all backups
Last updated on OCTOBER 11, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms