Use logdump to view the CSN of ogg
Use logdump to view the CSN of ogg
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; must be the main format here, where the OGG version is 11g using double quotes and 12c using single quotes
SENDER@hyyk > delete tab1 where tim='2018-03-09 1740 type; SENDER@hyyk > commit
SENDER@hyyk > delete tab1 where tim='2018-03-06 11 SENDER@hyyk > commit
SENDER@hyyk > insert into tab1 values (sysdate); SENDER@hyyk > commit
View the queue file number 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 OrigNode 08 OrigNode 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 Column 08 Delete Len 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 4141 4941 4141 5441 4142 0001 | 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 1815 08purl 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 Column 08SENDER.TAB1 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 4141 4141 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 OrigNode 09 IOType 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 3a31 09SENDER.TAB1 Insert Len 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 4141 4941 4141 4143 5441 4144001 | 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
