Re: RAM Errors when backing to disk

Prem K Mehrotra wrote:
> I am running Oracle9i r2 on HP UNIX 11i.
>
> Whenever, I allocate channel of type DISK, I get error, cannot figure
> out why. I have looked in Oracle's own scripts and syntax is exactly
> the same,
> so I do not understand the error:
>
> RMAN> run {
> 2>
> 3> allocate channel ch1 type 'DISK';

Why the quotes?

Why the allocation of channels, come to that?

run {
allocate channel d1 type disk;
...}

...will work, though it would be better to configure a default degree of parallelisation.

As to the rest of your script, just try:

run {
allocate channel d1 type disk;
backup
incremental level 1 cumulative
database format '/oradbblob/bkup/dbfile_%U%_%t'; }

The precise word ordering is quite often unimportant, though 'incremental level 1 cumulative' has to come after the word 'backup'. But I prefer seeing what it is that I am backing up ("database") before I start worrying about where to back it up to ("format...").

But your basic problem is simply that you've left two blank lines in the middle of your script. RMAN treats two empty lines as being the end of the sequence of commands... so it means it thinks you've submitted a job request before you've actually got all the syntax right.

Regards
HJR
> 4>
> 5>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571: ===========================================================
> RMAN-00558: error encountered while parsing input commands
> RMAN-01005: syntax error: found "end-of-file": expecting one of:
> "allocate, alter, backup, beginline
> , blockrecover, catalog, change, copy, crosscheck, configure,
> duplicate, debug, delete, execute, end
> inline, host, mount, open, plsql, recover, release, replicate, report,
> restore, resync, }, set, setl
> imit, sql, switch, startup, shutdown, send, show, validate"
> RMAN-01007: at line 6 column 1 file: standard input
>
> RMAN> backup
> 2> incremental level 1
> 3> cumulative
> 4> format '/oradbblob/bkup/dbfile_%U%_%t'
> 5> database;
> using Oracle9.2.0.5 on HP UNIX 11i.
>
>
>
> --------------------------
> When I use backup to tape using Netbackup:
>
> RMAN> run {
> 2>
> 3> allocate channel ch1 type 'SBT_TAPE';
>
>
> things work just fine.
>
>
> Prem
Received on Wed Nov 24 2004 - 23:34:20 CST