RMAN Change Clause

Update the status of a backup or copy in the RMAN repository.

Syntax:

 CHANGE {BACKUP | COPY} [OF listObjList]
          [ maintQualifier [maintQualifier]…]
            { AVAILABLE | UNAVAILABLE | UNCATALOG | keepOption } 
              [DEVICE TYPE deviceSpecifier [, deviceSpecifier]…];

 CHANGE archivelogRecordSpecifier
     { AVAILABLE | UNAVAILABLE | UNCATALOG | keepOption } 
        [DEVICE TYPE deviceSpecifier [, deviceSpecifier]…];

 CHANGE recordSpec [DEVICE TYPE deviceSpecifier [, deviceSpecifier]..
     { AVAILABLE | UNAVAILABLE | UNCATALOG | keepOption } 
        [DEVICE TYPE deviceSpecifier [, deviceSpecifier]…];


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

Example

Change an ordinary backup into a long-term backup:

CHANGE BACKUPSET 431 KEEP FOREVER NOLOGS;

“An essential aspect of creativity is not being afraid to fail” ~ Edwin Land

Related Oracle Commands:

CROSSCHECK - Check whether backup items still exist.
DELETE - Delete backups from disk or tape
EXIT - Exit the RMAN console
LIST - List backups and copies
REPORT - Report backup status: database, files, backups
RUN - Some RMAN commands are only valid inside a RUN block.