Oracle RMAN Pocket Reference

Name

DELETE

Synopsis

For Oracle9i, this command deletes the physical files associated with backup sets and datafile copies, updates their status in the control file, and removes their information from the optional recovery catalog (if one is used).

In Oracle8i and Oracle9i, backups are flagged as EXPIRED if they cannot be found at their recorded location. Deletion of EXPIRED backups removes their information from the control file and from the optional recovery catalog (if one is used).

Oracle9i syntax

DELETE [NOPROMPT] 
   { [EXPIRED] 
     { { BACKUP | COPY } 
        [OF listObj] [mntQualifer [mntQualifer]...]
     | recordSpec 
       [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...] 
     }
   | OBSOLETE [obsoleteOpersList]
     [DEVICE TYPE (deviceSpecifier [, deviceSpecifier]...]
   };

Oracle8i syntax

DELETE EXPIRED BACKUP 
   [ OF listObj ]
   [ deleteOptions [ deleteOptions...]];

deleteOptions :=
   { TAG [=] [']tag_name[']
   | completedTimeSpec }

Keywords

NOPROMPT

Deletes the specified files without confirmation

EXPIRED

Deletes those files that have been marked as EXPIRED in the catalog

OBSOLETE

Deletes those files that are no longer needed for recovery

Example

The following Oracle8i example removes the records associated with EXPIRED backups from the control files of the target database and the optional recovery catalog (if used):

RMAN> allocate channel for maintenance type disk;
RMAN> crosscheck backup; ... RMAN-08074: crosschecked backup piece: found to be 'EXPIRED' RMAN-08517: backup piece handle=/d99/rman/brdstn/rman_l0_ BRDSTN_0ccv8lck_1_1.bus ...