导航：首页 > 数据库 >

使用logdump 查看ogg的CSN

发表于：2024-11-28 作者：千家信息网编辑

千家信息网最后更新 2024年11月28日，使用logdump 查看ogg的CSNGGSCI (pc6) 2> view params ext_s1extract ext_s1 setenv (NLS_LANG="AMERICAN_AMERIC

千家信息网最后更新 2024年11月28日使用logdump 查看ogg的CSN使用logdump 查看ogg的CSN

GGSCI (pc6) 2> view params ext_s1
extract ext_s1 setenv (NLS_LANG="AMERICAN_AMERICA.AL32UTF8") setenv (ORACLE_SID="hyyk") userid ogg,password oracle gettruncates exttrail /u01/app/oggs/dirdat/ss table 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_S1 Seqno: 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 on Logdump 82 >ghdr on Logdump 83 >ggstoken detail Logdump 84 >usertoken detail Logdump 85 >pos 0 Reading forward from RBA 0 Logdump 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.000 IOType : 3 (x03) OrigNode : 255 (xff) TransInd : . (x03) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 60 AuditPos : 25251344 Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:08:25.000.000 Delete Len 25 RBA 2059 Name: SENDER.TAB1 (TDR Index: 1) Before Image: Partition 12 GU s 0000 0015 0000 3230 3138 2d30 332d 3039 3a31 373a | ......2018-03-09:17: 3430 3a32 39 | 40:29 Column 0 (x0000), Len 21 (x0015) User tokens: 15 bytes TK-CSN : 1763984 GGS tokens: TokenID x52 'R' ORAROWID Info x00 Length 20 4141 4153 5873 4141 4941 4141 4143 5441 4142 0001 | AAASXsAAIAAAACTAAB.. TokenID x4c 'L' LOGCSN Info x00 Length 7 3137 3633 3938 34 | 1763984 TokenID x36 '6' TRANID Info x00 Length 10 3130 2e32 392e 3130 3238 | 10.29.1028 Logdump 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.000 IOType : 3 (x03) OrigNode : 255 (xff) TransInd : . (x03) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 60 AuditPos : 25258000 Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:08:42.000.000 Delete Len 25 RBA 2208 Name: SENDER.TAB1 (TDR Index: 1) Before Image: Partition 12 GU s 0000 0015 0000 3230 3138 2d30 332d 3036 3a31 313a | ......2018-03-06:11: 3138 3a35 34 | 18:54 Column 0 (x0000), Len 21 (x0015) User tokens: 15 bytes TK-CSN : 1763999 GGS tokens: TokenID x52 'R' ORAROWID Info x00 Length 20 4141 4153 5873 4141 4941 4141 4143 5541 475a 0001 | AAASXsAAIAAAACUAGZ.. TokenID x4c 'L' LOGCSN Info x00 Length 7 3137 3633 3939 39 | 1763999 TokenID x36 '6' TRANID Info x00 Length 8 372e 352e 3130 3330 | 7.5.1030 Logdump 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.000 IOType : 5 (x05) OrigNode : 255 (xff) TransInd : . (x03) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 60 AuditPos : 25259536 Continued : N (x00) RecCount : 1 (x01)
2018/03/09 18:09:18.000.000 Insert Len 25 RBA 2355 Name: SENDER.TAB1 (TDR Index: 1) After Image: Partition 12 GU s 0000 0015 0000 3230 3138 2d30 332d 3039 3a31 383a | ......2018-03-09:18: 3039 3a31 31 | 09:11 Column 0 (x0000), Len 21 (x0015) User tokens: 15 bytes TK-CSN : 1764012 GGS tokens: TokenID x52 'R' ORAROWID Info x00 Length 20 4141 4153 5873 4141 4941 4141 4143 5441 4144 0001 | AAASXsAAIAAAACTAAD.. TokenID x4c 'L' LOGCSN Info x00 Length 7 3137 3634 3031 32 | 1764012 TokenID x36 '6' TRANID Info x00 Length 9 362e 3237 2e31 3234 31 | 6.27.1241

很赞哦！