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

   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']...
        }
      }

Example

Change an ordinary backup into a long-term backup:

CHANGE BACKUPSET 431 KEEP FOREVER NOLOGS;

"We don't want to go back to tomorrow, we want to go forward" - Dan Quale

Related 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.

Related Views:

  V$RMAN_STATUS, V$RMAN_OUTPUT