My Oracle Support Banner

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

Last updated on DECEMBER 01, 2019

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 inadverten 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 to NEVER be obsoleted. This note will explain why.
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.