使用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