Oracle RMAN Pocket Reference

Name

RESTORE

Synopsis

Restores an entire backup, or a component of a backup, to the target database. For Oracle8i, this command must be executed from within the RUN command.

Oracle9i syntax

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