Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: RMAN Commands
amerar_at_iwc.net wrote:
> 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"
-- Regards, Frank van BortelReceived on Mon Apr 18 2005 - 11:58:25 CDT
![]() |
![]() |