RMAN Backup fails on Degreeworks Database

 Problem Description : 

Commvault Backup may show error "RMAN Script execution failed with error [ORA-01008: not all variables bound]. Please check the Logs for more details" from time to time.

 Resolution : 

This is a known bug with Oracle version 11.2.0.2. In order to fix you will need to flush the shared pool - or - restart the database. Do this during off-peak hours.

Log into the DWDBS server

su - oracle

. ./dwprod.shl

sqlplus /nolog

connect /as sysdba

SQL> alter system flush shared_pool;

Backup should now run.

 Revision Date : 4/11/2017