Incremental Database backup error

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Post Reply
henkyws
Posts: 4
Joined: Wed Feb 28, 2007 6:30 am

Incremental Database backup error

Post by henkyws » Mon Mar 17, 2008 2:38 am

Dear All

I found an error while doing Incremental database backup through DB13 :

BR202I Saving BDXLUPRG.INCR
BR203I to /BACKUP_PROD/bdxluprg/BDXLUPRG.INCR ...
BR278E Command output of 'SHELL=/bin/sh /oracle/PRD/920_64/bin/rman nocatalog':
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
RMAN> connect target /;
connected to target database: PRD (DBID=1587651146)
using target database controlfile instead of recovery catalog
RMAN> **end-of-file**
RMAN>
host command complete
RMAN> 2> 3> 4> 5>
allocated channel: dsk
channel dsk: sid=223 devtype=DISK
Starting backup at 13-MAR-08
kgefec: fatal error 0
released channel: dsk
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dsk channel at 03/13/2008 18:31:15
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 400 bytes (PL/SQL DIANA,LISIMA: Add cells)
RMAN>
RMAN>
Recovery Manager complete.
BR280I Time stamp 2008-03-13 18.31.19
BR279E Return code from 'SHELL=/bin/sh /oracle/PRD/920_64/bin/rman nocatalog': 1
BR536E RMAN call for database instance PRD failed
BR280I Time stamp 2008-03-13 18.31.19
BR509I Incremental database backup (level 1) using RMAN failed
BR222E Copying BDXLUPRG.INCR to/from /BACKUP_PROD/bdxluprg failed due to previous errors
BR056I End of database backup: bdxluprg.ind 2008-03-13 18.31.19
BR280I Time stamp 2008-03-13 18.31.22
BR054I BRBACKUP terminated with errors

Please advise me to fix this error

Best regards & Thanks

HWS

benhp
Posts: 42
Joined: Tue Jul 25, 2006 2:14 am

minimize big memory usage

Post by benhp » Mon Mar 17, 2008 3:19 am

Check the ram usage and try to minimize big memory usage while running the backup

henkyws
Posts: 4
Joined: Wed Feb 28, 2007 6:30 am

Post by henkyws » Mon Mar 17, 2008 3:57 am

Dear Benhp

Could you tell me which ram parameters that related with backup process and how to edit the paramaters ?

Regards

HWS

benhp
Posts: 42
Joined: Tue Jul 25, 2006 2:14 am

Post by benhp » Mon Mar 17, 2008 4:06 am

The ora-04030 refers to operating system memory (RAM). You can check the RAM usage using the OS command or ST06. You can reduce the RAM usage by avoiding other simultaneously running programs(applications) in your computer. Try to run the backup during the off-peak hours.

benhp
Posts: 42
Joined: Tue Jul 25, 2006 2:14 am

Post by benhp » Mon Mar 17, 2008 4:18 am

Check Metalink Note 220688.1.
and metalink note 233869.1

you can set maxdsiz to >=128MB

Post Reply