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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23898243/viewspace-694022/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23898243/viewspace-694022/