RMAN的备份语法

blog.chinaunix.net

陶金

2008-7-2

保存本文

推荐给好友

收藏本页

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

         CROSSCHECK
        Checks whether backup pieces, proxy copies, and disk copies still exist.
        CROSSCHECK
        {
        { BACKUP [OF listObjList]
        | COPY [OF listObjList]
        | archivelogRecordSpecifier
        } [maintQualifier [maintQualifier]...]
        | recordSpec [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']...
        }
        }
        datafileSpec
        datafileSpec::=
        { 'filename'| integer }
        DELETE
        Deletes backups and copies from disk or tape media, and updates the RMAN
        repository accordingly.
        DELETE [FORCE] [NOPROMPT]
        { [EXPIRED]
        {
        { BACKUP [OF listObjList]
        | COPY [OF listObjList]
        | archivelogRecordSpecifier
        } [maintQualifier [maintQualifier]...]
        | recordSpec [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...]
        }
        | OBSOLETE [obsOperandList]
        [DEVICE TYPE (deviceSpecifier [, deviceSpecifier]...]
        };
        obsOperandList::=
        [ REDUNDANCY [=] integer | RECOVERY WINDOW OF integer DAYS ]...
        deviceSpecifier
        deviceSpecifier::=
        { DISK | ['] media_device ['] }
        LIST
        Lists the backups and copies recorded in the repository.
        LIST
        { INCARNATION [OF DATABASE [['] database_name [']]]
        | [EXPIRED]
        { listObjectSpec
        [ maintQualifier | RECOVERABLE [untilClause] ]...
        | recordSpec
        }
        };
        listObjectSpec::=
        { BACKUP [OF listObjList] [listBackupOption]
        | COPY [OF listObjList]
        | archivelogRecordSpecifier
        }
        listObjectList::=
        [ DATAFILE datafileSpec [, datafileSpec]...
        | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...
        | archivelogRecordSpecifier
        | DATABASE [SKIP TABLESPACE ['] tablespace_name [']
        [, ['] tablespace_name [']]...]
        | CONTROLFILE
        | SPFILE
        ]...
        listBackupOption::=
        [ [BY BACKUP] [VERBOSE]
        | SUMMARY
        | BY { BACKUP SUMMARY | FILE }
        ]
        maintQualifier
        { TAG [=] ['] tag_name [']
        | completedTimeSpec
        | LIKE 'string_pattern'
        | DEVICE TYPE deviceSpecifier [, deviceSpecifier]...
        | BACKED UP integer TIMES TO DEVICE TYPE deviceSpecifier
        }
        RECOVER
        Performs media recovery from RMAN backups and copies.
        RECOVER [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...]
        recoverObject [recoverOptionList];
        recoverObject::=
        { DATABASE
        [ untilClause
        | [untilClause] SKIP [FOREVER] TABLESPACE
        ['] tablespace_name ['] [, ['] tablespace_name [']]...
        ]
        | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...
        | DATAFILE datafileSpec [, datafileSpec]...
        }
        recoverOptionList::=
        { DELETE ARCHIVELOG [MAXSIZE {integer [K | M | G]}]
        | CHECK READONLY
        | NOREDO
        | { FROM TAG | ARCHIVELOG TAG } [=] ['] tag_name [']
        .
        .
        .
        }...

上一页 [1] [2] [3] [4] [5] 下一页