Commit Sequence Number in Golden Gate

Commit Sequence Number [CSN]

We know that all database management system maintains some kind of unique auto incremental number of its own at the completion of each transaction like we have SCN number in Oracle database. With that number, we can uniquely identify that transaction.

With reference to the above description, We can say that Commit Sequence Number is an identifier that Oracle GoldenGate constructs to identify a source transaction.

CSN number is processed in a platform-independent manner. It helps to maintain transactional sequence and data integrity.

We can find a particular point in time with the CSN number.

GGSCI (localhost.localdomain as ggs_owner@stdorcl) 6> info replicat rep2,detail

REPLICAT   REP2      Last Started 2018-10-09 00:41   Status ABENDED
Checkpoint Lag       00:00:00 (updated 535:12:42 ago)
Log Read Checkpoint  File /u02/ggate/dirdat/ba000000001
                     2018-10-07 02:28:34.141368  RBA 2042

Current Log BSN value: 1734948

Last Committed Transaction CSN value: 1872060

  Extract Source                          Begin             End             

  /u02/ggate/dirdat/ba000000001           2018-10-02 14:02  2018-10-07 02:28
  /u02/ggate/dirdat/ba000000000           * Initialized *   2018-10-02 14:02
  /u02/ggate/dirdat/ba000000000           * Initialized *   First Record    
  ./dirdat/ba000000000                    * Initialized *   First Record    


Current directory    /u02/ggate

Report file          /u02/ggate/dirrpt/REP2.rpt
Parameter file       /u02/ggate/dirprm/rep2.prm
Checkpoint file      /u02/ggate/dirchk/REP2.cpr
Checkpoint table     ggs_owner.chktbl
Process file         /u02/ggate/dirpcs/REP2.pcr
Error log            /u02/ggate/ggserr.log


GGSCI (localhost.localdomain as ggs_owner@stdorcl) 7>

We can see CSN number is: 1872060. We can check here replicat detail of rep2 shows us Last Committed Transaction sequence number 1872060. Data is replicated until that sequence number.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp