好记性不如烂笔头:
Logdump 15 >open ./dirdat/lt622504
Current LogTrail is /golden/goldengate/dirdat/lt622504
Logdump 16 >fileheader on
Logdump 18 >ghdr on
Logdump 19 >detail on
Logdump 20 >count
LogTrail /golden/goldengate/dirdat/lt622504 has 80859 records
Total Data Bytes 92318134
Avg Bytes/Record 1141
Insert 80858
Others 1
After Images 80858
Average of 2 Transactions
Bytes/Trans ..... 1940616
Records/Trans ... 40429
Files/Trans ..... 1
*FileHeader* Partition 0
Total Data Bytes 1315
Avg Bytes/Record 1315
Others 1
Logdump 46 >filter clear
Logdump 47 >filter inc filename PAYADM.PTCTJRN
Logdump 48 >filter match all
Logdump 49 >count
Scanned 10000 records, RBA 2965221, 2017/02/23 06:06:42.000.000
Scanned 20000 records, RBA 5904454, 2017/02/23 06:06:56.000.000
......
LogTrail /golden/goldengate/dirdat/lt623091 has 2851 records
Total Data Bytes 1254253
Avg Bytes/Record 439
Insert 986
FieldComp 1865
After Images 2851
Filtering matched 2851 records
suppressed 286089 records
Average of 2851 Transactions
Bytes/Trans ..... 48
Records/Trans ... 1
Files/Trans ..... 0
PAYADM.PTCTJRN Partition 4
Total Data Bytes 1254253
Avg Bytes/Record 439
Insert 986
FieldComp 1865
After Images 2851
Logdump 66 >pos 20410168
Reading in reverse from RBA 20410168
Logdump 67 >ggstoken detail
Logdump 68 >sfh
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 25 (x0019) IO Time : 2017/02/23 06:08:28.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 90836 AuditPos : 100416388
Continued : N (x00) RecCount : 1 (x01)
2017/02/23 06:08:28.000.000 Delete Len 25 RBA 20410007
Name: PAYADM.PUBLCKREC
Before Image: Partition 4 G s
0000 0015 0000 0011 4f4d 4b4d 5055 4231 3034 3031 | ........OMKMPUB10401
3030 3032 39 | 00029
Column 0 (x0000), Len 21 (x0015)
0000 0011 4f4d 4b4d 5055 4231 3034 3031 3030 3032 | ....OMKMPUB104010002
39 | 9
GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4275 7547 4144 6641 4141 4235 4a41 4137 0001 | AABuuGADfAAAB5JAA7..
TokenID x4c 'L' LOGCSN Info x00 Length 12
3335 3633 3132 3530 3132 3534 | 356312501254
TokenID x36 '6' TRANID Info x00 Length 15
3436 3639 2e33 302e 3631 3236 3537 33 | 4669.30.6126573
TokenID x69 'i' ORATHREADID Info x01 Length 2
0002 | ..
Logdump 15 >open ./dirdat/lt622504
Current LogTrail is /golden/goldengate/dirdat/lt622504
Logdump 16 >fileheader on
Logdump 18 >ghdr on
Logdump 19 >detail on
Logdump 20 >count
LogTrail /golden/goldengate/dirdat/lt622504 has 80859 records
Total Data Bytes 92318134
Avg Bytes/Record 1141
Insert 80858
Others 1
After Images 80858
Average of 2 Transactions
Bytes/Trans ..... 1940616
Records/Trans ... 40429
Files/Trans ..... 1
*FileHeader* Partition 0
Total Data Bytes 1315
Avg Bytes/Record 1315
Others 1
Logdump 46 >filter clear
Logdump 47 >filter inc filename PAYADM.PTCTJRN
Logdump 48 >filter match all
Logdump 49 >count
Scanned 10000 records, RBA 2965221, 2017/02/23 06:06:42.000.000
Scanned 20000 records, RBA 5904454, 2017/02/23 06:06:56.000.000
......
LogTrail /golden/goldengate/dirdat/lt623091 has 2851 records
Total Data Bytes 1254253
Avg Bytes/Record 439
Insert 986
FieldComp 1865
After Images 2851
Filtering matched 2851 records
suppressed 286089 records
Average of 2851 Transactions
Bytes/Trans ..... 48
Records/Trans ... 1
Files/Trans ..... 0
PAYADM.PTCTJRN Partition 4
Total Data Bytes 1254253
Avg Bytes/Record 439
Insert 986
FieldComp 1865
After Images 2851
Logdump 66 >pos 20410168
Reading in reverse from RBA 20410168
Logdump 67 >ggstoken detail
Logdump 68 >sfh
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 25 (x0019) IO Time : 2017/02/23 06:08:28.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 90836 AuditPos : 100416388
Continued : N (x00) RecCount : 1 (x01)
2017/02/23 06:08:28.000.000 Delete Len 25 RBA 20410007
Name: PAYADM.PUBLCKREC
Before Image: Partition 4 G s
0000 0015 0000 0011 4f4d 4b4d 5055 4231 3034 3031 | ........OMKMPUB10401
3030 3032 39 | 00029
Column 0 (x0000), Len 21 (x0015)
0000 0011 4f4d 4b4d 5055 4231 3034 3031 3030 3032 | ....OMKMPUB104010002
39 | 9
GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4275 7547 4144 6641 4141 4235 4a41 4137 0001 | AABuuGADfAAAB5JAA7..
TokenID x4c 'L' LOGCSN Info x00 Length 12
3335 3633 3132 3530 3132 3534 | 356312501254
TokenID x36 '6' TRANID Info x00 Length 15
3436 3639 2e33 302e 3631 3236 3537 33 | 4669.30.6126573
TokenID x69 'i' ORATHREADID Info x01 Length 2
0002 | ..
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/308563/viewspace-2136310/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/308563/viewspace-2136310/