RMAN Backup Processes started from GRID Control Consumes Entire Memory Cap (Doc ID 1607861.1)

Last updated on JANUARY 13, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

 When backup triggered from Grid Control we see high memory usage
 ============================================


 ++ process tree of rman pid
 .

 >ptree 26669           <--------------pid rman
 15926 zsched
 10990 /app/oracle/product/agent10g/perl/bin/perl
 /app/oracle/product/agent10g/bin/emw
   5957  /app/oracle/product/agent10g/bin/emagent
     26644 /app/oracle/product/agent10g/bin/nmo
       26645 /app/oracle/product/agent10g/perl/bin/perl
         26669 /app/oracle/product/11.2.0/dbhome_1/bin/rman
           26689 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
           26857 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
           26974 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
           26998 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
           27007 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
           27024 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

 .
 ++ When check memory usage we see almost 10Gb again RMAN and 95M for emagent
 .

 sdvm4k101:~# pmap 26669
 26669:  /app/oracle/product/11.2.0/dbhome_1/bin/rman
 0000000100000000       8192K r-x--  
 /sdvm4k101/sdvora103/root/app/oracle/product/11.2.0/dbhome_1/bin/rman
 0000000100800000       4072K r-x--  
 /sdvm4k101/sdvora103/root/app/oracle/product/11.2.0/dbhome_1/bin/rman
 0000000100CF8000        320K rwx--  
 /sdvm4k101/sdvora103/root/app/oracle/product/11.2.0/dbhome_1/bin/rman
 0000000100D48000       2784K rwx--    [ heap ]
 0000000101000000    4190208K rwx--    [ heap ]     <--------------4G
 0000000200C00000    4190208K rwx--    [ heap ]     <--------------4G
 0000000300800000    1982464K rwx--    [ heap ]     <--------------1.9G
 ...
 FFFFFFFF7FFCC000        208K rw---    [ stack ]      total     10424264K    <--------------- ~10G
 
 sdvm4k101:~# pmap 5957
 5957:   /app/oracle/product/agent10g/bin/emagent
 00010000       8K r-x--  
 /sdvm4k101/sdvora103/root/app/oracle/product/agent10g/bin/emagent
 00020000       8K rwx--  
 /sdvm4k101/sdvora103/root/app/oracle/product/agent10g/bin/emagent
 ...
 FFBF6000      40K rw---    [ stack ] total     97232K                <-------------~95M

 .
 When shutdown the agent and run backup manually then memory consumption by  RMAN showing expected behaviour
 ===================================================================================
 .

 sdvora103:/bck/oraflash/WB2BJD2/testing> ps -ef|grep rman
  oracle 21402 17809   0 10:05:50 pts/1       0:00 grep rman
  orabck  3508  3437   0   Aug 28 pts/7       0:07
 /app/oracle/product/11.2.0/dbhome_1/bin/rman
  oracle 19996 10658   2 10:04:10 pts/7       0:05 rman target / debug all
 trace=debug-inc-backup-4.trc log=inc-backup-4.log
 .
 sdvora103:/bck/oraflash/WB2BJD2/testing> ptree 19996            
 <---------------------------process tree for rman
 15926 zsched
  16590 /usr/lib/ssh/sshd
    10520 /usr/lib/ssh/sshd
      10521 /usr/lib/ssh/sshd
        10644 -bash
          10658 -ksh
            19996 rman target / debug all trace=debug-inc-backup-4.trc
 log=inc-backup-4.log
              20008 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
              20695 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
              20699 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
              20701 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
              20706 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
              20734 oracleWB2BJD2
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 .

 sdvora103:/bck/oraflash/WB2BJD2/testing> pmap 19996        <-----------------------------------pid of RMAN
 

19996:  rman target / debug all trace=debug-inc-backup-4.trc
 log=inc-backup-4.
 0000000100000000       8192K r-x--  
 /app/oracle/product/11.2.0/dbhome_1/bin/rman
 0000000100800000       4072K r-x--  
 /app/oracle/product/11.2.0/dbhome_1/bin/rman
 0000000100CF8000        320K rwx--  
 /app/oracle/product/11.2.0/dbhome_1/bin/rman
 0000000100D48000       2784K rwx--    [ heap ]
 0000000101000000      40960K rwx--    [ heap ]
 FFFFFFFF7B200000        776K r---R  dev:256,65586 ino:540279
 ...
 FFFFFFFF7F73A000          8K rwx--  /lib/sparcv9/ld.so.1
 FFFFFFFF7FFCE000        200K rw---    [ stack ]
         total       102272K                   <------------------------------------------------~100M used by RMAN

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms