ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN Change Clause

RMAN Change Clause

原创 Linux操作系统 作者:liu_qingwei2008 时间:2011-04-28 16:34:44 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: RMAN Backup Clause
下一篇: RMAN Configure Clause
请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    86389