Name

RESTORE

Synopsis

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 TYPE deviceSpecifier [, deviceSpecifier ...] 
| FORCE
] 
[ CHANNEL [']channel_id['] 
| PARMS [=] 'channel_parms' 
| FROM { BACKUPSET | DATAFILECOPY } 
| until
| FROM TAG [=] [']tag_name['] 
| VALIDATE 
| CHECK LOGICAL 
| CHECK READONLY 
| DEVICE TYPE deviceSpecifier [, deviceSpecifier ...] 
| FORCE
]...;

restoreObject :=
{ CONTROLFILE [TO 'filename']
| DATABASE 
  [SKIP [FOREVER] TABLESPACE 
   [']tablespace_name['] [, [']tablespace_name['] ...]
  ]
| DATAFILE datafileSpec [, 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 ...

Get Oracle in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.