December 2002
Intermediate to advanced
928 pages
85h 29m
English
RESTORE
Oracle9i syntax:
RESTORE [(]restoreObject[(restoreSpecOperand[restoreSpecOperand]...]) [)] [(]restoreObject[(restoreSpecOperand[restoreSpecOperand]...]) [)]... [ CHANNEL [']channel_id['] | PARMS [=] 'channel_parms' | FROM { BACKUPSET | DATAFILECOPY } |until| FROM TAG [=] [']tag_name['] | VALIDATE | CHECK LOGICAL | CHECK READONLY | DEVICE TYPEdeviceSpecifier[,deviceSpecifier...] | FORCE ] [ CHANNEL [']channel_id['] | PARMS [=] 'channel_parms' | FROM { BACKUPSET | DATAFILECOPY } |until| FROM TAG [=] [']tag_name['] | VALIDATE | CHECK LOGICAL | CHECK READONLY | DEVICE TYPEdeviceSpecifier[,deviceSpecifier...] | FORCE ]...;restoreObject:= { CONTROLFILE [TO 'filename'] | DATABASE [SKIP [FOREVER] TABLESPACE [']tablespace_name['] [, [']tablespace_name['] ...] ] | DATAFILEdatafileSpec[,datafileSpec...] | TABLESPACE [']tablespace_name['] [, [']tablespace_name[']]... |archivelogRecordSpecifier}restoreSpecOperand:= {CHANNEL [']channel_id['] | FROM TAG [=] [']tag_name['] | PARMS [=] 'channel_parms' | FROM { AUTOBACKUP [{ MAXSEQ | MAXDAYS } [=]integer] [{ MAXSEQ | MAXDAYS } [=]integer] ...]] | 'media_handle' } }
Oracle8i syntax:
RESTORE [(]restoreObject[(restoreSpecOperand[restoreSpecOperand]...]) [)] [(]restoreObject[(restoreSpecOperand[restoreSpecOperand]...]) [)]... [ CHANNEL [']channel_id['] | PARMS [=] 'channel_parms' | FROM { BACKUPSET | DATAFILECOPY } |until| FROM TAG [=] [']tag_name['] | VALIDATE | CHECK LOGICAL | CHECK READONLY ...