December 2002
Intermediate to advanced
928 pages
85h 29m
English
BACKUP
Oracle9i syntax:
BACKUP [ 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 ] | FILESPERSET [=]integer|PARMS[=]'channel_parms' | POOL [=]integer|TAG [=][']tag_name['] | keepOption | SKIP { OFFLINE | READONLY | INACCESSIBLE } | NOEXCLUDE | PROXY [ONLY] | VALIDATE | FORCE |DISKRATIO [=]integer| NOT BACKED UP[SINCE TIME [=]'date_string'] | NOCHECKSUM | CHECK LOGICAL | COPIES [=]integer| DEVICE TYPEdeviceSpecifier}backupSpec:= [(] { BACKUPSET{ { ALL| completedTimeSpec}| primary_key[,primary_key...] } | DATAFILEdatafileSpec[,datafileSpec...] | DATAFILECOPY 'filename' [,'filename' ...] | DATAFILECOPY TAG [=] [']tag_name['] [, [']tag_name['] ...] | TABLESPACE [']tablespace_name['] [, [']tablespace_name['] ...] | DATABASE |archivelogRecordSpecifier| CURRENT CONTROLFILE [FOR STANDBY] | CONTROLFILECOPY 'filename' } [backupSpecOperand[backupSpecOperand]...] [)]backupSpecOperand:= { FORMAT [=] 'format_string' [, 'format_string' ...] | CHANNEL [']channel_id['] | MAXSETSIZE [=]integer[ K | M | G ] | FILESPERSET [=]integer| PARMS [=]'channel_parms' | POOL [=]integer| TAG [=][']tag_name['] |keepOption| SKIP { OFFLINE | READONLY | INACCESSIBLE } | NOEXCLUDE | FORCE | DISKRATIO ...