使用logdump 查看ogg的CSN
使用logdump 查看ogg的CSN
GGSCI (pc6) 2> view params ext_s1
extract ext_s1setenv (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")setenv (ORACLE_SID="hyyk")userid ogg,password oraclegettruncatesexttrail /u01/app/oggs/dirdat/sstable sender.tab1, TOKENS(TK-CSN=@getenv('TRANSACTION','CSN'));--table sender.tab1;这里一定主要格式，这里OGG的版本是11g使用双引号，12c使用单引号
SENDER@hyyk> delete tab1 where tim='2018-03-09 17:40:29';SENDER@hyyk> commit;
SENDER@hyyk> delete tab1 where tim='2018-03-06 11:18:54';SENDER@hyyk> commit ;
SENDER@hyyk> insert into tab1 values(sysdate);SENDER@hyyk> commit;
查看队列文件的编号GGSCI (pc6) 4> info exttrail *
Extract Trail: /u01/app/oggs/dirdat/ss Seqno Length: 9 Flip Seqno Length: no Extract: EXT_S1Seqno: 12 RBA: 2503 File Size: 100M
Extract Trail: /u01/app/oggd/dirdat/sd Seqno Length: 9 Flip Seqno Length: no Extract: PUMP_S1 Seqno: 4 RBA: 3852 File Size: 100M
Logdump 76 >open /u01/app/oggs/dirdat/ss000000012
Logdump 81 >detail onLogdump 82 >ghdr onLogdump 83 >ggstoken detailLogdump 84 >usertoken detailLogdump 85 >pos 0Reading forward from RBA 0Logdump 92 >n___________________________________________________________________Hdr-Ind : E (x45) Partition : . (x0c)UndoFlag : . (x00) BeforeAfter: B (x42)RecLength : 25 (x0019) IO Time : 2018/03/09 18:08:25.000.000IOType : 3 (x03) OrigNode : 255 (xff)TransInd : . (x03) FormatType : R (x52)SyskeyLen : 0 (x00) Incomplete : . (x00)AuditRBA : 60 AuditPos : 25251344Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:08:25.000.000 Delete Len 25 RBA 2059Name: SENDER.TAB1 (TDR Index: 1)Before Image: Partition 12 GU s0000 0015 0000 3230 3138 2d30 332d 3039 3a31 373a | ......2018-03-09:17:3430 3a32 39 | 40:29Column 0 (x0000), Len 21 (x0015)User tokens: 15 bytesTK-CSN : 1763984 GGS tokens:TokenID x52 'R' ORAROWID Info x00 Length 204141 4153 5873 4141 4941 4141 4143 5441 4142 0001 | AAASXsAAIAAAACTAAB..TokenID x4c 'L' LOGCSN Info x00 Length 73137 3633 3938 34 | 1763984TokenID x36 '6' TRANID Info x00 Length 103130 2e32 392e 3130 3238 | 10.29.1028Logdump 93 >n___________________________________________________________________Hdr-Ind : E (x45) Partition : . (x0c)UndoFlag : . (x00) BeforeAfter: B (x42)RecLength : 25 (x0019) IO Time : 2018/03/09 18:08:42.000.000IOType : 3 (x03) OrigNode : 255 (xff)TransInd : . (x03) FormatType : R (x52)SyskeyLen : 0 (x00) Incomplete : . (x00)AuditRBA : 60 AuditPos : 25258000Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:08:42.000.000 Delete Len 25 RBA 2208Name: SENDER.TAB1 (TDR Index: 1)Before Image: Partition 12 GU s0000 0015 0000 3230 3138 2d30 332d 3036 3a31 313a | ......2018-03-06:11:3138 3a35 34 | 18:54Column 0 (x0000), Len 21 (x0015)User tokens: 15 bytesTK-CSN : 1763999 GGS tokens:TokenID x52 'R' ORAROWID Info x00 Length 204141 4153 5873 4141 4941 4141 4143 5541 475a 0001 | AAASXsAAIAAAACUAGZ..TokenID x4c 'L' LOGCSN Info x00 Length 73137 3633 3939 39 | 1763999TokenID x36 '6' TRANID Info x00 Length 8372e 352e 3130 3330 | 7.5.1030Logdump 94 >n___________________________________________________________________Hdr-Ind : E (x45) Partition : . (x0c)UndoFlag : . (x00) BeforeAfter: A (x41)RecLength : 25 (x0019) IO Time : 2018/03/09 18:09:18.000.000IOType : 5 (x05) OrigNode : 255 (xff)TransInd : . (x03) FormatType : R (x52)SyskeyLen : 0 (x00) Incomplete : . (x00)AuditRBA : 60 AuditPos : 25259536Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:09:18.000.000 Insert Len 25 RBA 2355Name: SENDER.TAB1 (TDR Index: 1)After Image: Partition 12 GU s0000 0015 0000 3230 3138 2d30 332d 3039 3a31 383a | ......2018-03-09:18:3039 3a31 31 | 09:11Column 0 (x0000), Len 21 (x0015)User tokens: 15 bytesTK-CSN : 1764012 GGS tokens:TokenID x52 'R' ORAROWID Info x00 Length 204141 4153 5873 4141 4941 4141 4143 5441 4144 0001 | AAASXsAAIAAAACTAAD..TokenID x4c 'L' LOGCSN Info x00 Length 73137 3634 3031 32 | 1764012TokenID x36 '6' TRANID Info x00 Length 9362e 3237 2e31 3234 31 | 6.27.1241
GGSCI (pc6) 2> view params ext_s1
extract ext_s1setenv (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")setenv (ORACLE_SID="hyyk")userid ogg,password oraclegettruncatesexttrail /u01/app/oggs/dirdat/sstable sender.tab1, TOKENS(TK-CSN=@getenv('TRANSACTION','CSN'));--table sender.tab1;这里一定主要格式，这里OGG的版本是11g使用双引号，12c使用单引号
SENDER@hyyk> delete tab1 where tim='2018-03-09 17:40:29';SENDER@hyyk> commit;
SENDER@hyyk> delete tab1 where tim='2018-03-06 11:18:54';SENDER@hyyk> commit ;
SENDER@hyyk> insert into tab1 values(sysdate);SENDER@hyyk> commit;
查看队列文件的编号GGSCI (pc6) 4> info exttrail *
Extract Trail: /u01/app/oggs/dirdat/ss Seqno Length: 9 Flip Seqno Length: no Extract: EXT_S1Seqno: 12 RBA: 2503 File Size: 100M
Extract Trail: /u01/app/oggd/dirdat/sd Seqno Length: 9 Flip Seqno Length: no Extract: PUMP_S1 Seqno: 4 RBA: 3852 File Size: 100M
Logdump 76 >open /u01/app/oggs/dirdat/ss000000012
Logdump 81 >detail onLogdump 82 >ghdr onLogdump 83 >ggstoken detailLogdump 84 >usertoken detailLogdump 85 >pos 0Reading forward from RBA 0Logdump 92 >n___________________________________________________________________Hdr-Ind : E (x45) Partition : . (x0c)UndoFlag : . (x00) BeforeAfter: B (x42)RecLength : 25 (x0019) IO Time : 2018/03/09 18:08:25.000.000IOType : 3 (x03) OrigNode : 255 (xff)TransInd : . (x03) FormatType : R (x52)SyskeyLen : 0 (x00) Incomplete : . (x00)AuditRBA : 60 AuditPos : 25251344Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:08:25.000.000 Delete Len 25 RBA 2059Name: SENDER.TAB1 (TDR Index: 1)Before Image: Partition 12 GU s0000 0015 0000 3230 3138 2d30 332d 3039 3a31 373a | ......2018-03-09:17:3430 3a32 39 | 40:29Column 0 (x0000), Len 21 (x0015)User tokens: 15 bytesTK-CSN : 1763984 GGS tokens:TokenID x52 'R' ORAROWID Info x00 Length 204141 4153 5873 4141 4941 4141 4143 5441 4142 0001 | AAASXsAAIAAAACTAAB..TokenID x4c 'L' LOGCSN Info x00 Length 73137 3633 3938 34 | 1763984TokenID x36 '6' TRANID Info x00 Length 103130 2e32 392e 3130 3238 | 10.29.1028Logdump 93 >n___________________________________________________________________Hdr-Ind : E (x45) Partition : . (x0c)UndoFlag : . (x00) BeforeAfter: B (x42)RecLength : 25 (x0019) IO Time : 2018/03/09 18:08:42.000.000IOType : 3 (x03) OrigNode : 255 (xff)TransInd : . (x03) FormatType : R (x52)SyskeyLen : 0 (x00) Incomplete : . (x00)AuditRBA : 60 AuditPos : 25258000Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:08:42.000.000 Delete Len 25 RBA 2208Name: SENDER.TAB1 (TDR Index: 1)Before Image: Partition 12 GU s0000 0015 0000 3230 3138 2d30 332d 3036 3a31 313a | ......2018-03-06:11:3138 3a35 34 | 18:54Column 0 (x0000), Len 21 (x0015)User tokens: 15 bytesTK-CSN : 1763999 GGS tokens:TokenID x52 'R' ORAROWID Info x00 Length 204141 4153 5873 4141 4941 4141 4143 5541 475a 0001 | AAASXsAAIAAAACUAGZ..TokenID x4c 'L' LOGCSN Info x00 Length 73137 3633 3939 39 | 1763999TokenID x36 '6' TRANID Info x00 Length 8372e 352e 3130 3330 | 7.5.1030Logdump 94 >n___________________________________________________________________Hdr-Ind : E (x45) Partition : . (x0c)UndoFlag : . (x00) BeforeAfter: A (x41)RecLength : 25 (x0019) IO Time : 2018/03/09 18:09:18.000.000IOType : 5 (x05) OrigNode : 255 (xff)TransInd : . (x03) FormatType : R (x52)SyskeyLen : 0 (x00) Incomplete : . (x00)AuditRBA : 60 AuditPos : 25259536Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:09:18.000.000 Insert Len 25 RBA 2355Name: SENDER.TAB1 (TDR Index: 1)After Image: Partition 12 GU s0000 0015 0000 3230 3138 2d30 332d 3039 3a31 383a | ......2018-03-09:18:3039 3a31 31 | 09:11Column 0 (x0000), Len 21 (x0015)User tokens: 15 bytesTK-CSN : 1764012 GGS tokens:TokenID x52 'R' ORAROWID Info x00 Length 204141 4153 5873 4141 4941 4141 4143 5441 4144 0001 | AAASXsAAIAAAACTAAD..TokenID x4c 'L' LOGCSN Info x00 Length 73137 3634 3031 32 | 1764012TokenID x36 '6' TRANID Info x00 Length 9362e 3237 2e31 3234 31 | 6.27.1241
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
