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:14:18 +0200
Message-ID: <d40m5u$6bq$1@news5.zwoll1.ov.home.nl>


amerar_at_iwc.net wrote:
> This is very interesting. We are running Oracle 8i. It seems that I
> cannot enter any RMAN commands directly on the command line. They have
> to be enclosed within run brackets {}. All the examples show that I
> can enter commands directly though......
>
> RMAN> recover tablespace CSIOWNER_DATA;
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-00558: error encountered while parsing input commands
> RMAN-01005: syntax error: found "recover": expecting one of: "allocate,
> alter, beginline, catalog, change, connect, crea
> te, crosscheck, configure, debug, delete, drop, exit, endinline, host,
> {, library, list, mount, open, print, register, r
> elease, replace, report, renormalize, reset, resync, rman, rpct"
> RMAN-01007: at line 1 column 1 file: standard input
>
>
>
>
>
> RMAN> run {
> 2> sql 'ALTER TABLESPACE csiowner_data OFFLINE';
> 3> allocate channel ch1 type disk;
> 4> restore tablespace CSIOWNER_DATA;
> 5> recover tablespace CSIOWNER_DATA;
> 6> sql 'ALTER TABLESPACE csiowner_data ONLINE';
> 7> }
>

>[snip rman feedback]

Sorry - is there a question; I fail to see it.

And *reading* the error message usually gets you a long way - the Greek already new that asking the question right is answering it.
You command should be restore, not recover. Recover is sql, not rman

-- 
Regards,
Frank van Bortel
Received on Mon Apr 18 2005 - 11:14:18 CDT

Original text of this message

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