IT36704: ORACLE SCN (SYSTEM CHANGE NUMBER) GETS TRUNCATED DURING IBM SPECTRUM PROTECT PLUS RESTORE

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus Oracle restore fails to apply the SCN
  (System Change Number) used in restore options. The restore
  will complete successfully, but the restore will not roll
  forward to the date and time specified in SCN (System Change
  Number). The SCN (System Change Number) gets truncated by three
  characters and this prevents the rollfoward from
  occurring
  
  Customer/Support Diagnostics (If
  Applicable):
  
  Looking in the restore job log, you will see the
  SCN (System Change Number) referenced.
  
  In this example,
  1234567890123 is the SCN (System Change Number)
  
  Transaction ID
  (1234567890123) specified loading versions for
  
  Later on in the
  restore job log, you will see the SCN (System Change Number)
  referenced again but it will be truncated by 3 digits at the
  end.
  
  For example:
  
  Running command: recover database using
  backup controlfile until change 1234567890
  
  Notice the last
  thee digits "123" are missing.
  
  Spectrum Protect Versions
  Affected: All Versions
  
  Initial Impact: Medium
  
  Additional
  Keywords: TS005463225 On-Demand Restore SCN System Change
  Number TRUNCATE
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus 10.1.x.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.8 patch1 and 10.1.9. Note that this is subject to       *
  * change at the discretion of IBM.                             *
  ****************************************************************
  

Problem conclusion

• The IBM Spectrum Protect Plus agent will not truncate SCNs
  longer than 10 digits to the first 10 digits.
  

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:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels