RMAN的备份语法

blog.chinaunix.net

陶金

2008-7-2

保存本文

推荐给好友

收藏本页

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

最近一直希望找一个RMAN语法手册去查查，终于在ORACLE 文档找到了，发出来共享一下，更多ORACLE资料可以到http://blog.chinaunix.com/u/250 下载

         archivelogRecordSpecifier
        This subclause specifies a range of archived redo logs.
        ARCHIVELOG
        { ALL
        | LIKE 'string_pattern'
        | archlogRange [LIKE 'string_pattern' [THREAD [=] integer]]
        }
        { { { UNTIL TIME | FROM TIME } [=] 'date_string'
        | { TIME BETWEEN 'date_string' AND
        | FROM TIME [=] 'date_string' UNTIL TIME [=]
        16
        }
        'date_string'
        | UNTIL SCN [=] integer
        | SCN BETWEEN integer AND integer
        | FROM SCN [=] integer [UNTIL SCN [=] integer]
        }
        [THREAD [=] integer]
        | { UNTIL SEQUENCE [=] integer
        | FROM SEQUENCE [=] integer [UNTIL SEQUENCE [=] integer]
        | SEQUENCE [BETWEEN integer AND] integer
        }
        [THREAD [=] integer]
        }

         BACKUP
        Backs up database files, archived logs, backups, and copies.
        BACKUP
        [ (
        (FULL | INCREMENTAL LEVEL [=] integer)
        | [ (FULL | INCREMENTAL LEVEL [=] integer) ]
        AS (COPY | BACKUPSET)
        | AS (COPY | BACKUPSET)
        (FULL | INCREMENTAL LEVEL [=] integer)
        )
        ]
        [backupOperand [backupOperand]...] backupSpec [backupSpec]...
        [PLUS ARCHIVELOG [backupSpecOperand [backupSpecOperand]...]];
        backupOperand::=
        { FORMAT [=] 'format_string' [, 'format_string']...
        | CHANNEL ['] channel_id [']
        | CUMULATIVE
        | MAXSETSIZE [=] integer [ K | M | G ]
        | TAG [=] ['] tag_name [']
        | keepOption
        | SKIP { OFFLINE | READONLY | INACCESSIBLE }
        | VALIDATE
        | NOT BACKED UP [SINCE TIME [=] 'date_string']
        | COPIES [=] integer
        | DEVICE TYPE deviceSpecifier
        .
        .
        .
        }
        backupSpec::=
        [(]
        { BACKUPSET
        { {ALL | completedTimeSpec }
        | primary_key) [, primary_key]...
        }
        | COPY OF { DATABASE
        | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...
        | DATAFILE datafileSpec [, datafileSpec]...
        }
        | DATAFILE datafileSpec [, datafileSpec]...
        | DATAFILECOPY 'filename' [, 'filename']...
        17
        | DATAFILECOPY FROM TAG [=] ['] tag_name ['] [, ['] tag_name [']]...
        | DATAFILECOPY { ALL | LIKE 'string_pattern' }
        | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...
        | DATABASE
        | archivelogRecordSpecifier
        | CURRENT CONTROLFILE [FOR STANDBY]
        | CONTROLFILECOPY 'filename'
        | SPFILE
        }
        [backupSpecOperand [backupSpecOperand]...]
        backupSpecOperand::=
        { FORMAT [=] 'format_string' [, 'format_string']...
        | CHANNEL ['] channel_id [']
        | CUMULATIVE
        | MAXSETSIZE [=] integer [ K | M | G ]
        | TAG [=] ['] tag_name [']
        | keepOption
        | SKIP { OFFLINE | READONLY | INACCESSIBLE }
        | NOT BACKED UP [ SINCE TIME [=] 'date_string'
        | integer TIMES
        ]
        | DELETE [ALL] INPUT
        .
        .
        .
        }

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

【责编:michael】