LOB Data Missing From XA Transaction In Streams Replicated Environment
Last updated on MARCH 31, 2014
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2 to 12.1]
Information in this document applies to any platform.
LOB data is intermittently missing from Stream Apply sites when the source transaction is an XA transaction with branches in multiple nodes.
In this case we have two distinct tables into which data is inserted from two different branches of the same XA transaction where the branches are executed in different nodes. The LOB data appears in the source tables but in the replicated environment the LOB data for one of the tables is 0 bytes in size.
Analysis of the redo indicates that the LOB data is present in the redo logs for both inserts but it appears the COMMIT associated with the problem branch is not mined by the Capture process and so it believes the transaction to still be open and therefore the LOB data is not sent to the Apply.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms