My database backups have been running fine up to last friday. It crashed, when the online backup started, rman was pulling so much memory during the backup. Since then we have not been able to perform a hot online backup. I am using Netbackup 4.5, with the oracle plug-in, Windows 2000.
Initially the problem was that RMAN thought everything was already backed up, so I preformed a crosscheck. After preforming the crosscheck, we started receiving the message below.
The error message is below.
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 2: ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 1971712 bytes (PLS non-lib hp,BAMIMA: Grow Bam Buffer)
I have expanded the memory in the shared_pool_size, so I am pretty sure this is not really a memory issue. I also changed the default on the shared_pool_reserved_size to 10%.
Nothing seemed to work. Last resort was to restart the database. That did not help either.