oracle csn,使用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