Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RMAN restore tablespace
> Then, why do all the examples in every manual show
restoring and
> recovery form the RMAN> prompt?
>
restore is first (the physical part), then comes
recovery.
Again, your error message shows the command was not
expected.
Even more, your next example that does work, shows you
restore,
and then recover.
Oh - and about your every manual shows it from the
prompt:
For example, to restore tablespace USER_DATA to disk
you might issue:
run {
sql 'ALTER TABLESPACE user_data OFFLINE TEMPORARY';
allocate channel ch1 type disk;
restore tablespace user_data;
}
Quoted from the 8i Recovery Manager User's Guide and
Reference,
part A76990-01, issued December 1999 (time to
upgrade!),
Ch 6 "Restoring Datafiles, Control Files, and Archived
Redo Logs",
sub section "Restoring Tablespaces and Datafiles"
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 18 2005 - 13:13:00 CDT