Oracle in a Nutshell

Name

BACKUP

Synopsis

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 TYPE deviceSpecifier
}

backupSpec :=
[(] 
{ BACKUPSET 
                          { { ALL | completedTimeSpec } 
  | primary_key [,primary_key ...] 
  } 
| DATAFILE datafileSpec [, 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 ...