Oracle - Rman error

[claudio_22]

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

[Peter Godron]

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

[Jean-Luc Oudart]

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

[claudio_22]

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 ..

[Jean-Luc Oudart]

Claudio

I have
stack(kbytes) 81920

Regards
Jean-Luc

PS : what shell do you use ?

[Eric Antunes]

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

[Eric Antunes]

Hi,

Following Note 272510.1, you can try this and retry:

$ulimit -s unlimited

Best Regards,

Eric Antunes

[Indira Aramandla]

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

[Yogeeraj_1]

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