IT40114: ORACLE BACKUP FAILS WITH: "CTGGF0031 LIST INDEX OUT OF RANGE"

APAR status

• Closed as program error.

Error description

• The IBM Spectrum Protect Plus Oracle backup can fail with the
  error as seen in the job log:
  
  WARN,CTGGF0079,<IP> No running instance found for db snmp;
  ignoring error because autostart is disabled in oratab.
  ERROR,CTGGF0031,<IP> Database <dbname>: Backup failed: list
  index out of range
  
  In the command log found in the job log bundle, the following is
  seen:
  INFO pid:<pid number> Thread-52 processOutput: <dbname>:
  RMAN-20232: tag does not match any datafile copy in the recovery
  catalog
  INFO pid:<pid number> Thread-52 parse_pfile: <dbname>: Reading
  initialization parameters from pfile <pfile.txt path>
  INFO pid:<pid number> Thread-52 worker_backup: Traceback (most
  recent call last):
  ERROR pid:<pid number> Thread-52 worker_backup: <CTGGF0031>
  Database <dbname>: Backup failed: list index out of range
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.4 and later
  
  Additional Keywords: SPP, SPPlus, TS007871367, Oracle, pfile
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.4, 10.1.5, 10.1.6,      *
  * 10.1.7, 10.1.8, 10.1.9                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed IBM Spectrum Protect Plus level 10.1.9 *
  * ifix3 and 10.1.10. Note that this is subject to change at    *
  * the discretion of IBM.                                       *
  ****************************************************************
  

Problem conclusion

• Fixed an issue with parsing pfile with value than span multiple
  lines. After applying the fix Oracle job will complete
  successfully for these cases too.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• Apps     Oracle
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels