Re: RMAN Commands

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