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.