Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 1 (11.1)

Part Number B28273-01
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
Contact Us

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

obsOperandList

Purpose

Use the obsOperandList subclause used to specify which criteria are used to mark backups as obsolete.

Usage Notes

Using both RECOVERY WINDOW and REDUNDANCY in a single REPORT OBSOLETE or DELETE OBSOLETE command is not supported.

Syntax

obsOperandList::=

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

Semantics

obsOperandList

Syntax Element Description
RECOVERY WINDOW OF integer DAYS Specifies that RMAN should report as obsolete those backup sets and image 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 set or image copy to be obsolete.

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


Example

Example 3-31 Deleting Obsolete Backups

The following command deletes all backups and copies not needed to recover the database to an SCN within the last 30 days:

DELETE OBSOLETE RECOVERY WINDOW OF 30 DAYS;