{"id":9,"date":"2013-11-13T08:59:00","date_gmt":"2013-11-13T08:59:00","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/2013\/11\/13\/goldengate-scn-translation\/"},"modified":"2015-11-17T20:27:23","modified_gmt":"2015-11-17T19:27:23","slug":"goldengate-scn-translation","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2013\/11\/13\/goldengate-scn-translation\/","title":{"rendered":"GoldenGate – SCN translation"},"content":{"rendered":"

On GoldenGate when you do “SEND <extract> status” you get a SCN field which does not correspond to the database SCN:
\nGGSCI> send e_test status
Sending STATUS request to EXTRACT E_TEST …
EXTRACT E_TEST (PID 9372244)
Current status: Recovery complete: Processing data
Current read position:
Redo thread #: 1
Sequence #: 198315
RBA: 335376
Timestamp: 2013-11-11 16:11:57.000000
SCN: 78.924145222<\/b>
Current write position:
Sequence #: 1548
RBA: 401683
Timestamp: 2013-11-11 16:12:31.811533
Extract Trail: \/acfs\/goldengate\/dirdat\/test\/tt<\/span><\/p>\n

\n
<\/span><\/div>\n

SQL> select current_scn from v$database;
CURRENT_SCN
———————-
335931612762<\/span><\/p>\n

\n
<\/span><\/div>\n

To translate that SCN into the database SCN there is the calculation to make:<\/p>\n

\n
<\/span><\/div>\n

78 * (2^32) + 924145222 = 335931594310<\/span>or with a hexadecimal translation:
\n78 to hexa        ==> 4E
924145222 to hexa ==> 37155646<\/span><\/p>\n

\nConcatenate both and then
\n4E37155646 to decimal ==> 335931594310<\/span><\/div>\n
\n
<\/span><\/div>\n

Well, with the most recent versions of GoldenGate you can simply to “INFO <extract>” and you get the database SCN between parentheses.<\/p>\n

\n<\/div>\n
\n
\nGGSCI> info e_test<\/span><\/div>\n
\nEXTRACT  E_TEST  Last Started 2013-11-13 08:08   Status RUNNING<\/span><\/div>\n
\nCheckpoint Lag       00:00:00 (updated 00:00:04 ago)<\/span><\/div>\n
\nLog Read Checkpoint  Oracle Redo Logs<\/span><\/div>\n
\n                  2013-11-13 09:57:40  Seqno 200447, RBA 16256592<\/span><\/div>\n
\n                  SCN 78.1163096680 (336170545768)<\/span><\/span><\/div>\n<\/div>\n
\n<\/div>\n","protected":false},"excerpt":{"rendered":"

On GoldenGate when you do “SEND <extract> status” you get a SCN field which does not correspond to the database SCN: GGSCI> send e_test statusSending STATUS request to EXTRACT E_TEST …EXTRACT E_TEST (PID 9372244)Current status: Recovery complete: Processing dataCurrent read position:Redo thread #: 1Sequence #: 198315RBA: 335376Timestamp: 2013-11-11 16:11:57.000000SCN: 78.924145222Current write position:Sequence #: 1548RBA: 401683Timestamp: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"class_list":{"0":"post-9","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-goldengate","7":"category-oracle","8":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"predecessor-version":[{"id":158,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/9\/revisions\/158"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}