Question about commit scn of the committed txn

(Doc ID 2307952.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Goal

There's a question from our developement team regarding the SCN information for Big Data Adapter.

Does BDA store the last SCN processed anywhere. We see the dirchk directory has .cpj and .cpr files
and the .cpj has the following information does the "completescn" indidcate that last SCN processed?

checkpoint.valid=true
checkpoint.version=1
checkpoint.groupname=RVAN02D1
checkpoint.groupkey=2744887250
checkpoint.dir=
checkpoint.createts=212357046773531248
checkpoint.seqno=13
checkpoint.rba=3625213
checkpoint.auditts=212359815735000000
checkpoint.log.bsn=11613233870196
checkpoint.log.csn=11627377931696
checkpoint.log.xid=
checkpoint.log.completecsn=11627377931696
checkpoint.log.completexids.count=1
checkpoint.log.completexids.xid0=50.3.347583
 

Solution

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