8 Replies Latest reply: Apr 3, 2013 1:35 PM by sharpe RSS

    RMAN Incremental Fails ORA-4030 (Low Memory Usage with Available Mem)

    sharpe
      Hello,

      I'm having issues with RMAN failing during incremental backup of the datafiles. It fails immediately with ORA-04030: out of process memory when trying to allocate 1052696 bytes (KSFQ heap,KSFQ Buffers). Below is some relevant information:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production Running on AIX 6.1
      Oracle ULIMIT set to UNLIMINTED
      PGA_AGGREGATE_TARGET set to 8gb
      SGA_TARGET set to 20gb

      At first this seems like Note 1338058.1, however, when looking at the incident log, the process is using very minimal memory:
      ========= Dump for incident 184740 (ORA 4030) ========
      ----- Beginning of Customized Incident Dump(s) -----
      =======================================
      TOP 10 MEMORY USES FOR THIS PROCESS
      ---------------------------------------
      90%   96 MB,  96 chunks: "KSFQ Buffers              "
               KSFQ heap       ds=110868cf8  dsprt=110004590
       6% 6081 KB, 110 chunks: "free memory               "
               pga heap        ds=110004590  dsprt=0
       1% 1025 KB,   2 chunks: "krcib                     "
               pga heap        ds=110004590  dsprt=0
       1%  615 KB,  23 chunks: "permanent memory          "
               pga heap        ds=110004590  dsprt=0
       0%  383 KB,   3 chunks: "free memory               "
               top uga heap    ds=110101278  dsprt=0
      I also saw a note that suggested setting ORA_RMAN_SGA_SIZE, but that did not help. RMAN has been running in the past, but additional ASM disks were added, additional data files were added, and some datafiles were expanded in size.

      The system has plenty of available memory when the RMAN job fails. It almost seems as if its getting capped around 100mb. Any insight/help is appreciated.

      Thanks