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 ]… 

 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


© Copyright SS64.com 1999-2013
Some rights reserved