---

deleteExpired

Syntax

Purpose

To update backup set records from status expired to status deleted in the RMAN metadata. This command will operate 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 file.

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 updates their records to deleted status:

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"

---