Logdump enables you to search for,filter,view,and save data that is stored in a trail or extract file.

查看记录

[oracle@odb07ogg]$./logdump

OracleGoldenGateLogFileDumpUtilityforOracle
Version12.2.0.1.1OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

Copyright(C)1995,2015,Oracleand/oritsaffiliates.Allrightsreserved.

Logdump65>open/u01/app/oracle/product/ogg/dirdat/i1000000215
CurrentLogTrailis/u01/app/oracle/product/ogg/dirdat/i1000000215
Logdump66>ghdron
Logdump67>headertokenon
Logdump68>usertokenon
Logdump69>detailon
Logdump70>detaildata
Logdump71>n
TokenIDx46'F'RecordHeaderInfoxff80Length1770
TokenIDx30'0'TrailInfoInfox00Length832
TokenIDx31'1'MachineInfoInfox00Length108
TokenIDx32'2'DatabaseInfoInfox00Length362
TokenIDx33'3'ProducerInfoInfox00Length119
TokenIDx34'4'ContinunityInfoInfox00Length321
TokenIDx5a'Z'RecordTrailerInfoxff80Length1770

2016/07/2613:14:34.395.885FileHeaderLen1762RBA0
Name:*FileHeader*
300003403000000847470d0a544c0a0d31000002|0..@0...GG..TL..1...
000532000004200000003300000802f25eb66eb7|..2......3.....^.n.
3ced34000030002e7572693a6f646230313a3a75|<.4..0..uri:odb01::u
30313a6170703a6f7261636c653a70726f647563|01:app:oracle:produc
743a6f67673a52484e5f444d5031350000343500|t:ogg:RHN_DMP15..45.
0030002e7572693a6f646230313a3a7530313a61|.0..uri:odb01::u01:a
70703a6f7261636c653a70726f647563743a6f67|pp:oracle:product:og

Logdump72>n
TokenIDx47'G'RecordHeaderInfox01Length131
TokenIDx48'H'GHDRInfox00Length35
TokenIDx44'D'DataInfox00Length80
TokenIDx5a'Z'RecordTrailerInfox01Length131
___________________________________________________________________
Hdr-Ind:E(x45)Partition:.(x00)
UndoFlag:.(x00)BeforeAfter:A(x41)
RecLength:80(x0050)IOTime:2016/07/1210:44:47.757.005
IOType:170(xaa)OrigNode:1(x01)
TransInd:.(x01)FormatType:R(x52)
SyskeyLen:0(x00)Incomplete:.(x00)
DDR/TDRIdx:(001,000)AuditPos:11542052
Continued:N(x00)RecCount:1(x01)

2016/07/1210:44:47.757.005MetadataLen80RBA1770
Name:
*
DDRVersion:1
Databasetype:ORACLE
CharactersetID:UTF-8
NationalcharactersetID:UTF-16
Locale:neutral
Casesensitivity:14141414141414141414141411141414
TimeZone:GMT
Globalname:RHNDB
*
Logdump73>n
TokenIDx47'G'RecordHeaderInfox01Length1379
TokenIDx48'H'GHDRInfox00Length57
TokenIDx44'D'DataInfox00Length1306
TokenIDx5a'Z'RecordTrailerInfox01Length1379
___________________________________________________________________
Hdr-Ind:E(x45)Partition:.(x00)
UndoFlag:.(x00)BeforeAfter:A(x41)
RecLength:1306(x051a)IOTime:2016/07/1216:34:42.662.334
IOType:170(xaa)OrigNode:2(x02)
TransInd:.(x01)FormatType:R(x52)
SyskeyLen:0(x00)Incomplete:.(x00)
DDR/TDRIdx:(001,001)AuditPos:12479340
Continued:N(x00)RecCount:1(x01)

2016/07/1216:34:42.662.334MetadataLen1306RBA1901
Name:SPWUSER.RHNPACKAGEFILE
*
1)Name2)DataType3)ExternalLength4)FetchOffset5)Scale6)Level
7)Null8)BumpifOdd9)InternalLength10)BinaryLength11)TableLength12)MostSigDT
13)LeastSigDT14)HighPrecision15)LowPrecision16)ElementaryItem17)Occurs18)KeyColumn
19)SubDataType20)NativeDataType21)CharacterSet22)CharacterLength23)LOBType24)PartialType
*
TDRversion:1
DefinitionfortableSPWUSER.RHNPACKAGEFILE
RecordLength:1032
Columns:17
PACKAGE_ID645000010505050000010122-1000
CAPABILITY_ID6450560010505050000010122-1000
DEVICE64501120010505050000010022-1000
INODE64501680010505050000010022-1000
FILE_MODE64502240010505050000010022-1000
USERNAME6432280001032320000010001-1000
GROUPNAME6432318001032320000010001-1000
RDEV64503560010505050000010022-1000
FILE_SIZE64504120010505050000010022-1000
MTIME19229468001029292906001000232-1000
CHECKSUM_ID64505000010505050000010022-1000
LINKTO6425655600102562560000010001-1000
FLAGS64508180010505050000010022-1000
VERIFYFLAGS64508740010505050000010022-1000
LANG6432930001032320000010001-1000
CREATED19229968001029292906001000232-1000
MODIFIED192291000001029292906001000232-1000
Endofdefinition

Logdump74>n
TokenIDx47'G'RecordHeaderInfox01Length345
TokenIDx48'H'GHDRInfox00Length36
TokenIDx44'D'DataInfox00Length265
TokenIDx54'T'GGSTokensInfox00Length24
TokenIDx5a'Z'RecordTrailerInfox01Length345
___________________________________________________________________
Hdr-Ind:E(x45)Partition:.(x0c)
UndoFlag:.(x00)BeforeAfter:A(x41)
RecLength:265(x0109)IOTime:2016/07/2613:23:33.321.599
IOType:5(x05)OrigNode:255(xff)
TransInd:.(x01)FormatType:R(x52)
SyskeyLen:0(x00)Incomplete:.(x00)
AuditRBA:2286AuditPos:24811252
Continued:N(x00)RecCount:1(x01)

2016/07/2613:23:33.321.599InsertLen265RBA3280
Name:SPWUSER.RHNPACKAGEFILE(TDRIndex:1)
AfterImage:Partition12Gm
000000090000000534313534360001000c000000|........41546.......
0831303936313531340002000500000001310003|.10961514........1..
0009000000053139323534000400090000000531|......19254........1
363837370005000800000004726f6f7400060008|6877........root....
00000004726f6f74000700050000000130000800|....root........0...
0800000004343039360009001f0000323031332d|.....4096......2013-
31322d31333a31353a32313a35362e3030303030|12-13:15:21:56.00000
Column0(x0000),Len9(x0009)
000000053431353436|....41546
Column1(x0001),Len12(x000c)
000000083130393631353134|....10961514
Column2(x0002),Len5(x0005)
0000000131|....1
Column3(x0003),Len9(x0009)
000000053139323534|....19254
Column4(x0004),Len9(x0009)
000000053136383737|....16877
Column5(x0005),Len8(x0008)
00000004726f6f74|....root
Column6(x0006),Len8(x0008)
00000004726f6f74|....root
Column7(x0007),Len5(x0005)
0000000130|....0
Column8(x0008),Len8(x0008)
0000000434303936|....4096
Column9(x0009),Len31(x001f)
0000323031332d31322d31333a31353a32313a35|..2013-12-13:15:21:5
362e303030303030303030|6.000000000
Column10(x000a),Len4(x0004)
ffff0000|....
Column11(x000b),Len4(x0004)
ffff0000|....
Column12(x000c),Len5(x0005)
0000000130|....0
Column13(x000d),Len14(x000e)
0000000a34323934393637323633|....4294967263
Column14(x000e),Len4(x0004)
ffff0000|....
Column15(x000f),Len31(x001f)
0000323031362d30372d32363a30353a31343a32|..2016-07-26:05:14:2
392e353438343338303030|9.548438000
Column16(x0010),Len31(x001f)
0000323031362d30372d32363a30353a31343a32|..2016-07-26:05:14:2
392e353438393231303030|9.548921000

查看trail文件的总记录数

Logdump78>count
**CountbeginsatRBA3280
LogTrail/u01/app/oracle/product/ogg/dirdat/i1000000215has145742records
TotalDataBytes36538835
AvgBytes/Record250
Delete27613
Insert67738
Update49834
GGSPKUpdate107
LargeObject395
MetadataRecords55
BeforeImages27613
AfterImages118074

Averageof70155Transactions
Bytes/Trans.....620
Records/Trans...2
Files/Trans.....0
.......
SPWUSER.RHNVIRTUALINSTANCEINFOPartition0
TotalDataBytes648
AvgBytes/Record648
MetadataRecords1

SPWUSER.RHNVIRTUALINSTANCEINFOPartition12
TotalDataBytes122
AvgBytes/Record122
Insert1
AfterImages1

查看环境变量

Logdump76>env
Version:Linux,x64,64bit(optimized)onDec11201516:52:17

CurrentDirectory:/u01/app/oracle/product/ogg
LogTrail:/u01/app/oracle/product/ogg/dirdat/i1000000215
TrailFormat:New
TrailFormatVersion:RELEASE12.2
ObjectdefsIncluded:Yes
EndofFile:49999890
CurrentPosition:3280Forward
NextPosition:3280
LastModtime:2016/07/2720:14:03.000.000
DisplayRecLen:140
LogtrailFilter:On
ShowGhdr:On
Detail:Data
HeaderToken:On
UserToken:On
TransHistory:0Transactions,Records100,Bytes100000
LargeBlockI/O:On,Blocksize57344
LocalSystem:LittleEndian
MetadataByteOrder:BigEndian
LogtrailData:BigEndian/ASCII
LogtrailHeaders:ASCII
Dump:ASCII
Savefilecomments:Off
Timeoffset:LOCAL
ScanNotifyInterval:10000records,ScrollingOn

参考文献：Logdump Reference for Oracle GoldenGate