My Oracle Support Banner

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

Last updated on DECEMBER 05, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.