RMAN Commands , 35 of 59

obsOperandList

Syntax

Text 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

Use this clause in the following commands:

DELETE
REPORT

Keywords and Parameters

Syntax Element Description

Syntax Element	Description
`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.
`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
`ORPHAN`	Specifies as obsolete those backups and copies that are unusable because they belong to incarnations of the database that are not direct ancestors of the current incarnation. Note that `RMAN` displays orphaned backups in addition to the normal display of obsolete backups. See Also: Oracle9i Recovery Manager User's Guide for an explanation of orphaned backups

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.

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

ORPHAN

Specifies as obsolete those backups and copies that are unusable because they belong to incarnations of the database that are not direct ancestors of the current incarnation. Note that RMAN displays orphaned backups in addition to the normal display of obsolete backups.

See Also: Oracle9i Recovery Manager User's Guide for an explanation of orphaned backups

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;