Ask the Expert

RMAN process ran out of memory

I am getting a problem with RMAN. I have tried to get complete database backup with the stored script. When I run the script, I get an error message. How can I solve that problem? Error message below: Problem with FULLBACKUP

    Requires Free Membership to View

RMAN> run { execute script FULLBACK; }

RMAN-03021: executing script: FULLBACK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: db01d1
RMAN-08500: channel db01d1: sid=15 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel db01d1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=3 set_stamp=507330741 creation_time=13-OCT-03
RMAN-08010: channel db01d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001 name=C:ORACLEORADATADB01SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00002 name=C:ORACLEORADATADB01RBS01.DBF
RMAN-08522: input datafile fno=00008 name=C:ORACLEORADATADB01OEM_REPOSITORY.
RMAN-08522: input datafile fno=00003 name=C:ORACLEORADATADB01USERS01.DBF
RMAN-08522: input datafile fno=00004 name=C:ORACLEORADATADB01TEMP01.DBF
RMAN-08522: input datafile fno=00006 name=C:ORACLEORADATADB01INDX01.DBF
RMAN-08522: input datafile fno=00007 name=C:ORACLEORADATADB01DR01.DBF
RMAN-08522: input datafile fno=00005 name=C:ORACLEORADATADB01TOOLS01.DBF
RMAN-08522: input datafile fno=00009 name=C:ORACLEORADATADB01DATA01.DBF
RMAN-08522: input datafile fno=00010 name=C:ORACLEORADATADB01RMANPRACTICE.DB
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: db01d1
RMAN-03015: error occurred in stored script FULLBACK
RMAN-03006: non-retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel db01d1
RMAN-10035: exception raised in RPC: ORA-04030: out of process memory when trying to allocate 524812 bytes (pga heap,KSFQ Buffers)
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECRE


RMAN-03022: compiling command: list

Your problem lies with the ORA-4030 error. Your RMAN process ran out of memory. You didn't indicate your operating system. So you'll need to figure out how to let your processes allocate more memory. For instance, in Unix environments, this is done with the 'ulimit' command.

This was first published in October 2003

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: