I am using Oracle 9i and using RMAN to backup the database. I frequantly the following error( it does NOT fail all the time..which i find strange!):
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10038: database session for channel t1 terminated unexpectedly
I did some investigating, and found out that shared pool size needed to be increased. The current size is set to 100M. Large pool is not being used. I understand it is better to use Large pool when using RMAN. Now is there a view where i can find how much of the shared pool is being used and to what it should be increased to?..Any other solutions to the problem would be most welcome.
Click Here to Expand Forum to Full Width