Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
|
|
View PDF |
Syntax
obsOperandList::=
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:
Using both RECOVERY WINDOW
and REDUNDANCY
clause in a single REPORT OBSOLETE
or DELETE OBSOLETE
command is not supported.
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;