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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial