前些天客户的ogg延迟到达8小时左右，于是我当时用logdump追踪了一下：
看进程状态：
send extsa staus
EXTRACT ZBDBA (PID 2269368)
Current status: Recovery complete: Processing data with empty data queue
Current read positions:
Redo thread #: 1
Sequence #: 36694
RBA: 35831764
Timestamp: 2014-10-17 16:18:28.000000
SCN: 3044.3022023259
Redo thread #: 2
Sequence #: 34709
RBA: 403776
Timestamp: 2014-10-17 16:18:28.000000
SCN: 3044.3022023265
Current write position:
Sequence #: 5160
RBA: 168381460
Timestamp: 2014-10-17 17:07:07.339050
Extract Trail: ./dirdat/sa
使用logdump
?
Logdump 254 >open /goldengate/dirdat/sa005160
Current LogTrail is /goldengate/dirdat/sa005160
Logdump 255 >ghdr on
Logdump 256 >detail on
Logdump 257 >detail data
Logdump 258 >usertoken on
Logdump 259 >pos 168381460
Reading forward from RBA 168381460
Logdump 260 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 226 (x00e2) IO Time : 2014/10/17 16:18:28.000.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 34709 AuditPos : 369920
Continued : N (x00) RecCount : 1 (x01)
2014/10/17 16:18:28.000.000 Insert Len 226 RBA 168381460
Name: MW_APP.MWT_UD_KW_SJBGJL
After Image: Partition 4 G s
0000 002c 0000 3641 4431 4545 4239 2d32 3830 382d | ...,..6AD1EEB9-2808-
3437 3030 2d42 4335 322d 4342 3936 4132 4130 4234 | 4700-BC52-CB96A2A0B4
3638 2d30 3537 3137 0001 002c 0000 3641 4431 4545 | 68-05717...,..6AD1EE
4239 2d32 3830 382d 3437 3030 2d42 4335 322d 4342 | B9-2808-4700-BC52-CB
3936 4132 4130 4234 3638 2d30 3537 3132 0002 0028 | 96A2A0B468-05712...(
0000 0024 3436 3930 3238 3835 2d39 3745 462d 3444 | ...$46902885-97EF-4D
3644 2d39 4446 322d 4536 3837 4637 3938 3039 3334 | 6D-9DF2-E687F7980934
Column 0 (x0000), Len 44 (x002c)
0000 3641 4431 4545 4239 2d32 3830 382d 3437 3030 | ..6AD1EEB9-2808-4700
2d42 4335 322d 4342 3936 4132 4130 4234 3638 2d30 | -BC52-CB96A2A0B468-0
3537 3137 | 5717
Column 1 (x0001), Len 44 (x002c)
0000 3641 4431 4545 4239 2d32 3830 382d 3437 3030 | ..6AD1EEB9-2808-4700
2d42 4335 322d 4342 3936 4132 4130 4234 3638 2d30 | -BC52-CB96A2A0B468-0
3537 3132 | 5712
Column 2 (x0002), Len 40 (x0028)
0000 0024 3436 3930 3238 3835 2d39 3745 462d 3444 | ...$46902885-97EF-4D
3644 2d39 4446 322d 4536 3837 4637 3938 3039 3334 | 6D-9DF2-E687F7980934
Column 3 (x0003), Len 31 (x001f)
0000 3230 3134 2d31 302d 3137 3a31 363a 3138 3a32 | ..2014-10-17:16:18:2
382e 3631 3335 3436 3030 30 | 8.613546000
Column 4 (x0004), Len 5 (x0005)
0000 0001 30 | ....0
Column 5 (x0005), Len 13 (x000d)
0000 0009 3438 3330 3730 3539 38 | ....483070598
Column 6 (x0006), Len 5 (x0005)
0000 0001 43 | ....C
Column 7 (x0007), Len 4 (x0004)
ffff 0000 | ....
Column 8 (x0008), Len 4 (x0004)
ffff 0000 | ....
Logdump 261 >
?
查看表：
?
SQL> select count(1) from MW_APP.MWT_UD_KW_SJBGJL;
COUNT(1)
----------
1217825
SQL> select count(1) from MW_APP.MWT_UD_KW_SJBGJL;
COUNT(1)
----------
1218487
SQL> select count(1) from MW_APP.MWT_UD_KW_SJBGJL;
COUNT(1)
----------
1219335
EXTRACT ZBDBA (PID 2269368)
Current status: Recovery complete: Processing data with empty data queue
Current read positions:
Redo thread #: 1
Sequence #: 36695
RBA: 36154920
Timestamp: 2014-1