IBM Support

JR65137: CDC ORACLE REDO DOES NOT ALWAYS RE-READ ASM MANAGED REDO LOG USING ORACLE PACKAGE IF NATIVE FILE ACCESS HITS LOG CORRUPTION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • CDC Oracle Redo does not always try to re-read ASM managed redo
    log using Oracle package if native file access hits log
    corruption error.
    

Local fix

  • The workaround is to restart the subscription.  On restart as
    long as the restart position is pointing to a redo log that is
    EARLIER than the log that CDC hit log corruption error with we
    should be able to restart.  If not restarting the subscription
    will not work.  You will have to mark table capture
    point/refresh to move past the error.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This issue might affect you if you are using IDR             *
    * 11.4.0.4-5652 or older for Oracle as a source datastore.     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Mirroring ends on error.                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDR 11.4.0.4-5655 or newer for Oracle.            *
    ****************************************************************
    

Problem conclusion

  • Upgrading to IDR 11.4.0.4-5655 or newer for Oracle resolves the
    issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR65137

  • Reported component name

    IS CDC ORACLE

  • Reported component ID

    5725E30OR

  • Reported release

    B40

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-08-25

  • Closed date

    2022-09-22

  • Last modified date

    2022-09-22

  • 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

    IS CDC ORACLE

  • Fixed component ID

    5725E30OR

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.4","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 September 2022