IT33078: NO LOG TRUNCATION IN ACTIVE-PASSIVE ORACLE RAC ENVIRONMENT

APAR status

• Closed as program error.

Error description

• The SLA options to save and truncate the logs when selected
  against an Oracle instance in an active-passive Real
  Application Cluster (RAC) environment will have no effect when
  the processed database is on the passive node at the moment of
  the backup run.
  If the database moves to the active node, log
  truncation will complete as expected.
  The issue will not be
  seen in an active-active RAC setup.
  
  IBM Spectrum Protect Plus
  Versions Affected:
  IBM Spectrum Protect Plus 10.1.2 to
  10.1.5
  
  Initial Impact: Medium
  
  Additional Keywords:
  TS003497152 , SPP, SPPLUS, backup, application, oracle, log,
  truncation, truncate
  

Local fix

• 1. Register only the active node of the RAC in Spectrum Protect
  Plus.
  OR
  2. Create a DNS name on the Spectrum Protect Plus
  host that points to the IP address of the current active node
  and use that name to register the active node in Spectrum
  Protect Plus.
   When the active node changes, the DNS can be
  updated to point to the new active node.
   With this option,
  when the active node changes, the IP address or hostname can be
  moved to the new active node and no change will be needed in
  the Oracle instance registration in Spectrum Protect Plus.
  

Problem summary

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

Problem conclusion

• Log backup is adjusted to handle active-passive configuration of
  an Oracle RAC
  

Temporary fix

• Register only the active node in the Oracle RAC
  

Comments

APAR Information

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

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

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels