goldengate replication commit order capture

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

goldengate replication commit order capture

Harsha Vardhan
I have a table which is being replicated by goldengate to a table which captures all dml changes. Both source and target are oracle db.
Can we find out source commit order by looking at the following ?
1) transaction id
2) system change number
3) below expression recommended by oracle :

@COMPUTE(@COMPUTE(@NUMSTR(@GETENV('RECORD','FILESEQNO'))*100000000000)+@NUMSTR(@GETENV('RECORD','FILERBA')))
Reply | Threaded
Open this post in threaded view
|

Re: goldengate replication commit order capture

ErmanArslansOracleBlog
Administrator
As you mentioned, the following is to get a unique value which would help in determining the sequence of operation;

@COMPUTE(@COMPUTE(@NUMSTR(@GETENV ("RECORD", "FILESEQNO"))*100000000000)+@NUMSTR(@GETENV ("RECORD", "FILERBA")))

Reference: Godengate @GETENV ('RECORD', 'RSN') Returning SCN of the transaction (Doc ID 2036276.1)

Check this MOS note as well -> What Tokens need to included in the transaction to make it unique for Insertallrecords to be used in the replicat (Doc ID 1340823.1)

Other than these, I have nothing to recommend on this.
Reply | Threaded
Open this post in threaded view
|

Re: goldengate replication commit order capture

Harsha Vardhan
Thanks for your reply. If the expression is unique, that is good enough for my purposes.