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

Home -> Community -> Usenet -> c.d.o.server -> Re: RAM Errors when backing to disk

Re: RAM Errors when backing to disk

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 25 Nov 2004 09:53:04 -0800
Message-ID: <43441e77.0411250953.27e297d1@posting.google.com>


"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41a56ed4$0$12900$afc38c87_at_news.optusnet.com.au>...
> 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

HJR:
I think blank lines was the problem. I don't know why that was not an issue with allocate channgel tape command.

ANyway, thinsg are working now.

Thanks a lot,

Prem Received on Thu Nov 25 2004 - 11:53:04 CST

Original text of this message

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