Hi All,
My RMAN Archive log backups has been failing with the below error. Please help me to fix this I am a Storage Admin don't have much idea about DB.
Version Oracle 10G
Script /opt/rman_script/sp72_oracle_arch.sh
==== started on Wed Jun 19 06:04:02 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: SP72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_SERV: zsswmasb
NB_ORA_POLICY: bsswsp72_archlog_daily
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> RMAN> on on Wed Jun 19 06:04:02 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SP72 (DBID=163991343)
connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 06/19/2013 06:04:13
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 06/19/2013 06:04:13
ORA-04031: unable to allocate 4192 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","modification ")
RMAN>
Recovery Manager complete.
Script /opt/rman_script/sp72_oracle_arch.sh
==== ended in error on Wed Jun 19 06:04:14 SGT 2013 ====
Thanks,
Nayab