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