obsOperandList::=
A subclause used to specify which criteria are used to mark backups and copies as obsolete.
Use this clause in the following commands:
Using both RECOVERY WINDOW
and REDUNDANCY
clause in a single REPORT OBSOLETE
or DELETE OBSOLETE
command is not supported.
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. |
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;