topic Re: Oracle - Rman error in Operating System - HP-UX

Oracle - Rman error

claudio_22 — Tue, 18 Jan 2005 07:27:20 GMT

Hello,

I've following error during Rman backup session

kgefec: fatal error 0
released channel: dev_0
released channel: dev_1
released channel: dev_2
released channel: dev_3
released channel: dev_4
released channel: dev_5
released channel: dev_6
released channel: dev_7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_0 channel at 01/17/2005 16:36:27
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 1: ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 2536 bytes (PL/SQL MPCODE,pl/sql DS pg)

RMAN> **end-of-file**

This is Rman script

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
allocate channel 'dev_4' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
allocate channel 'dev_5' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
allocate channel 'dev_6' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
allocate channel 'dev_7' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8pc,OB2APPNAME=sstest0,OB2BARLIST=online_full_SSTEST0_BC,OB2SMB=1)';
backup FULL filesperset 1
format 'online_full_SSTEST0_BC.dbf'
proxy only
database
include current controlfile
;
}

I've read could be due too many channels ?
And try increase filesperset to 20 .

What do you think about ?

Thanks

Re: Oracle - Rman error

Peter Godron — Tue, 18 Jan 2005 07:47:34 GMT

Hi,
have a look at metalink note 481984.995, which suggests:
"The ora-4030 error might be result of the following
1) The system as a whole runs out of memory.
2) The process in particular is out of available address space.

You might try setting the filesperset option to lower value in the RMAN "backup" command to reduce process memory requiremnet"

So it looks as if you are on the right track!

Regards

Re: Oracle - Rman error

Jean-Luc Oudart — Tue, 18 Jan 2005 08:22:16 GMT

Claudio,

I suggest you read Metalink doc id 233869.1
Diagnosing and Resolving ORA-4030 errors
and also Note:266132.1

The client program has run out of memory
Any memory left on the system ?

What is the output for ulimit -a ?

Regards
Jean-Luc

Re: Oracle - Rman error

claudio_22 — Tue, 18 Jan 2005 08:50:05 GMT

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1048576
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048

I think stack is low ..

Re: Oracle - Rman error

Jean-Luc Oudart — Tue, 18 Jan 2005 09:58:46 GMT

Claudio

I have
stack(kbytes) 81920

Regards
Jean-Luc

PS : what shell do you use ?

Re: Oracle - Rman error

Eric Antunes — Tue, 18 Jan 2005 11:49:59 GMT

Hi,

I get the following:

#ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 524288
stack(kbytes) 131072
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 1024

I'm not sure but I think RMAN uses the large_pool, doesn't it?

Eric Antunes

Re: Oracle - Rman error

Eric Antunes — Tue, 18 Jan 2005 12:09:43 GMT

Hi,

Following Note 272510.1, you can try this and retry:

$ulimit -s unlimited

Best Regards,

Eric Antunes

Re: Oracle - Rman error

Indira Aramandla — Tue, 18 Jan 2005 19:54:59 GMT

Hi Claudio,

The ora-4030 is a result of not enough available memory.

In your case the cause for the errors would be your process stack is 8192.

The fix will be to Make stack to unlimited using $ulimit -s unlimited

Indira A

Re: Oracle - Rman error

Yogeeraj_1 — Wed, 19 Jan 2005 01:01:13 GMT

hi,

Have you been able to solve your problem?

If no, can you try to increase your database level parameter: sort_area_retained_size

e.g.
sort_area_retained_size = 10485760

I have a similar problem some times back.

let us know

regards
yogeeraj