RMAN Delete

Delete backups (and copies) from disk or tape, and update the RMAN repository.

Syntax:

   DELETE [FORCE] [NOPROMPT] 
    { [EXPIRED] 
     { 
       { BACKUP [OF listObjectList]
       | COPY   [OF listObectjList] 
       | archivelogRecordSpecifier
       } [maintQualifier [maintQualifier]...]
     | recordSpec [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...] 
     }
   | OBSOLETE [obsOperandList]
     [DEVICE TYPE (deviceSpecifier [, deviceSpecifier]...]
   };

 obsOperandList::=
     [ REDUNDANCY [=] integer | RECOVERY WINDOW OF integer DAYS | ORPHAN ]... 

 recordSpec::=
      { { BACKUPPIECE | PROXY } 
        { 'media_handle' [, 'media_handle']... 
        | primary_key [, primary_key]... 
        | TAG [=] ['] tag_name [']
        }
      | BACKUPSET primary_key [, primary_key]...
      | { CONTROLFILECOPY | DATAFILECOPY }
        { { primary_key [, primary_key]... 
          | 'filename' [, 'filename']...
          } 
        | TAG [=] ['] tag_name ['] [, ['] tag_name [']]...
        }
      | ARCHIVELOG
        { primary_key [, primary_key]... 
        | 'filename' [, 'filename']...
        }
      }

 listObjectList::=
   [ DATAFILE datafileSpec [, datafileSpec]... 
   | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]... 
   | archivelogRecordSpecifier 
   | DATABASE [SKIP TABLESPACE ['] tablespace_name ['] 
     [, ['] tablespace_name [']]...] 
   | CONTROLFILE
   | SPFILE
   ]...

Examples

 RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt;
 RMAN> CROSSCHECK BACKUP OF TABLESPACE user_data COMPLETED BEFORE 'SYSDATE-14';

 RMAN> DELETE NOPROMPT EXPIRED BACKUP OF TABLESPACE user_data COMPLETED BEFORE 'SYSDATE-14';
 RMAN> DELETE BACKUP OF DATABASE LIKE '/tmp%';
 RMAN> DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;
 RMAN> DELETE BACKUPSET 101, 102, 103;
 RMAN> DELETE CONTROLFILECOPY '/tmp/cntrlfile.copy';
 RMAN> DELETE BACKUP OF SPFILE TABLESPACE users DEVICE TYPE sbt;

Delete backups and copies (and archived redo logs ) that will not be needed to perform any possible recovery of the database to any point in the last 7 days.
DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 7 DAYS;

"Rejection is the greatest aphrodisiac" - Madonna

Related Commands:

CHANGE - Update the status of a backup in the RMAN repository.
CONFIGURE - Persistent RMAN settings.
CROSSCHECK - Check whether backup items still exist.
LIST - List backups and copies
REPORT - Report backup status: database, files, backups
SET - Settings for the current RMAN session.
SHOW - Display the current configuration

Related Views: