在OGG运维过程中，经常会遇到需要获取进程当前scn的场景，比如当我们需要重新初始化一张表，但是又希望不增加进程，且又要保持和其他表的一致性，这时候就需要获取复制进程当前scn，然后根据该scn做初始化了。scn号的获取具体有两种方法，如下。方法1： info 进程名 showch
GGSCI (szgjj1) 2> info gsxt_rep showch REPLICAT GSXT_REP Last Started 2014-09-22 12:25 Status STOPPED Checkpoint Lag 00:00:00 (updated 00:03:17 ago) Log Read Checkpoint File ./dirdat/xt000015 2014-09-22 12:40:08.715836 RBA 625467 CSN state information: CRC: D5-14-6-B1 Latest CSN: 14064580200613 Latest TXN: 10.16.281070 Latest CSN of finished TXNs: 14064580200613 --这个就是复制进程完成事务的最后的scn Completed TXNs: 10.16.281070
方法2：logdump有可能showch 不显示csn信息,则需要借助logdump工作来获取
GGSCI (szgjj1) 2> info szrep2 REPLICAT SZREP2 Last Started 2015-01-14 16:19 Status STOPPED Checkpoint Lag 00:00:00 (updated 00:06:02 ago) Log Read Checkpoint File ./dirdat/we000851 2015-01-14 16:19:14.721032 RBA 1700798 GGSCI (szgjj1) 3> exit $ ./logdump Oracle GoldenGate Log File Dump Utility Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved. Logdump 6 >open ./dirdat/we000851 Current LogTrail is s/dirdat/we000851 Logdump 7 >position 1700798 Reading forward from RBA 1700798 Logdump 8 >ggstoken detail Logdump 9 >position reverse Reading in reverse from RBA 1700798 Logdump 10 >n --通过n进行翻页，如果一次没有找到，则再次翻页查看 2015/01/14 16:19:14.721.032 Insert Len 405 RBA 1700295 Name: SZHFSWEB.AF_DTL_PER After Image: Partition 4 G e 0000 000a 0000 3333 3031 3230 3030 0001 000a 0000 | ......33012000...... 3333 3031 3230 3030 0002 0011 0000 000d 3135 3031 | 33012000........1501 3134 3033 3237 3531 3400 0300 1100 0000 0d31 3530 | 140327514........150 3131 3430 3332 3735 3134 0004 0008 0000 3230 3135 | 1140327514......2015 3031 0005 0004 0000 3039 0006 0010 0000 000c 3030 | 01......09........00 3030 3030 3631 3430 3431 0007 000e 0000 000a 3130 | 0000614041........10 3131 3036 3130 3439 0008 000b 0000 0007 3031 3234 | 11061049........0124 GGS tokens: TokenID x52 'R' ORAROWID Info x00 Length 20 4141 4150 6676 4141 5a41 4142 534b 6241 4154 0001 | AAAPfvAAZAABSKbAAT.. Logdump 11 >n 2015/01/14 16:19:14.721.032 Insert Len 408 RBA 1699757 Name: SZHFSWEB.AF_DTL_DRAW After Image: Partition 4 G b 0000 0011 0000 000d 3135 3031 3134 3033 3237 3531 | ........150114032751 3400 0100 0400 0030 3500 0200 0300 0031 0003 0003 | 4......05......1.... 0000 3100 0400 04ff ff00 0000 0500 0a00 0000 0000 | ..1................. 0000 1930 3e00 0600 0a00 0000 0000 0000 18f1 4e00 | ...0>.............N. 0700 0a00 0000 0000 0000 1288 ae00 0800 0a00 0000 | .................... 0000 0000 0668 a000 0900 0a00 0000 0000 0000 003e | .....h.............> f000 0a00 0a00 0000 0000 0000 003d 5300 0b00 0a00 | .............=S..... GGS tokens: TokenID x52 'R' ORAROWID Info x00 Length 20 4141 4150 4868 4141 5a41 4142 5274 5841 4156 0001 | AAAPHhAAZAABRtXAAV.. TokenID x4c 'L' LOGCSN Info x00 Length 11 3135 3139 3235 3337 3630 34 | 15192537604 --这个15192537604就是最后一次应用的事务的scn TokenID x36 '6' TRANID Info x00 Length 12 3130 2e31 382e 3739 3632 3335 | 10.18.796235
