cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle - Rman error

claudio_22
Regular Advisor

Oracle - Rman error

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





8 REPLIES
Peter Godron
Honored Contributor

Re: Oracle - Rman error

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
Honored Contributor

Re: Oracle - Rman error

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
fiat lux
claudio_22
Regular Advisor

Re: Oracle - Rman error

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
Honored Contributor

Re: Oracle - Rman error

Claudio

I have
stack(kbytes) 81920

Regards
Jean-Luc

PS : what shell do you use ?
fiat lux
Eric Antunes
Honored Contributor

Re: Oracle - Rman error

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
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Oracle - Rman error

Hi,

Following Note 272510.1, you can try this and retry:

$ulimit -s unlimited

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Indira Aramandla
Honored Contributor

Re: Oracle - Rman error

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

Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: Oracle - Rman error

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)