deleteExpired

Syntax

Purpose

To remove backup set records with status EXPIRED from the recovery catalog. This command operates only on the recovery catalog records for the backup pieces marked EXPIRED by the crosscheck command. Use the list command or query the recovery catalog views to obtain the status of backup sets.

Note: If for some reason a backup set marked EXPIRED exists when you run the delete expired backup command, RMAN deletes the physical files.

Requirements

• You must be using a recovery catalog.

• Execute delete expired backup only at the RMAN prompt.

• Precede delete expired backup with an allocate channel for delete or an allocate channel for maintenance command (see "allocateForMaint").

Keywords and Parameters

of listObjList	restricts the list of objects to the object type specified in the listObjList clause. If no objects are specified, the command deletes all expired objects: of database controlfile archivelog all. See "listObjList".
tag tag_name	specifies the tag for the backup set.
completedTimeSpec	specifies a time range for backup completion. See "completedTimeSpec".

Examples

Deleting Expired Backups

The following example checks the media manager for expired backups of the tablespace USER_DATA that are more than one month old and removes their catalog records:

allocate channel for delete ch1 type 'sbt_tape';
crosscheck backup of tablespace user_data completed before 'SYSDATE-31';
delete expired backup of tablespace user_data' completed before 'SYSDATE-31';
release channel;

Related Topics

"allocateForMaint"

"crosscheck"