Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: RMAN Commands

Re: RMAN Commands

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 18 Apr 2005 18:58:25 +0200
Message-ID: <d40ool$u3e$1@news5.zwoll1.ov.home.nl>


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 Bortel
Received on Mon Apr 18 2005 - 11:58:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US