Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

obsOperandList

Syntax

obsOperandList::=

Description of obsoperandlist.gif follows
Description of the illustration obsoperandlist.gif

Purpose

A subclause used to specify which criteria are used to mark backups and copies as obsolete.

Restrictions and Usage Notes

Keywords and Parameters

Syntax Element Description
RECOVERY WINDOW OF integer DAYS Specifies that RMAN should report as obsolete those backups and copies that are not needed to recover the database to any point within the last integer days.

See Also: "CONFIGURE" for an explanation of the recovery window

REDUNDANCY = integer Specifies the minimum level of redundancy considered necessary for a backup or copy to be obsolete. A datafile copy is obsolete if there are at least integer more recent backups or image copies of this file; a datafile backup set is obsolete if there are at least integer more recent backups or image copies of each file contained in the backup set. For example, REDUNDANCY 2 means that there must be at least two more recent backups or copies of a datafile for any other backup or copy to be obsolete.

Example

Deleting Obsolete Backups: Example The following command deletes all backups and copies not needed to recover the database to a random point within the last 30 days:

DELETE OBSOLETE RECOVERY WINDOW OF 30 DAYS;