Introduction to the use of Logdump tools in GoldenGate
The Logdump tool is a tool provided by GoldenGate for querying, analyzing, filtering, viewing and saving data stored in trail files or extract files.
1. Start the Logdump tool
[oracle@rhel6] $cd / ogg [oracle@rhel6 ogg] $. / logdumpOracle GoldenGate Log File Dump Utility for OracleVersion 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.Logdump 8 >
2. Use Logdump
# View header information of data record Logdump 1 > GHDR ON# view column information, including quantity and length Logdump 2 > DETAIL ON# view hex and ASCII data values Logdump 3 > DETAIL DATA# view user-defined information Logdump 5 > USERTOKEN ON# Open a trail file, you can write relative path or absolute path Logdump 6 > OPEN. / dirdat/zx000000006Current LogTrail is / ogg/dirdat/zx000000006 # sequentially view the information in the trail file NEXT or NLogdump 7 > N2016 Universe 12 Accord 08 14 FileHeader Len 1515 10.814.788 FileHeader Len 1359 RBA 0 Name: * FileHeader* 3000 02f0 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0.0.G.. TL.. 1. 0005 3200 0004 2000 0000 3300 0008 02f2 6953 040a |.. 2. ... 3.iS.. 3644 3400 0018 0016 7572 693a 7268 656c 363a 3a6f | 6D4.uri:rhel6::o 6767 3a45 5854 5f45 4d50 3600 0016 0014 2e2f 6469 | gg:EXT_EMP6./di 7264 6174 2f7a 7830 3030 3030 3036 3700 0001 | rdat/zx0000000067... 0138 0000 0400 0000 0639 ff00 0800 0000 0000 0000 | .8.9. 003a 0000 8101 3000 0000 0000 0000 |.: .0.# specify a RBA number Logdump 12 > pos 2239Reading forward from RBA 2239 Logdump 13 > n _ Hdr-Ind E (x45) Partition:. (X0C) UndoFlag:. (X00) BeforeAfter: a (x41) RecLength: 121( x0079) IO Time: 2016-12-08 1414 OrigNode 47.000.000 IOType: 5 (x05) OrigNode: 255 (xff) TransInd:. (X00) FormatType: r (x52) SyskeyLen: 0 (X00) Incomplete:. (X00) AuditRBA: 84 AuditPos: 5428240 Continued: n (X00) RecCount: 1 (X01) 2016-12-08 14 purl 16 purl 47.000.000 Insert Len 121RBA 2239 Name: ZHAOXU.EMP (TDR Index: 1) After Image: Partition 12 GB 0000 000a 0000 0000 0000 1cc9 0001 0009 0000 |. 0005 534d 4954 4800 0200 0900 0000 0543 4c45 524b |.. SMITH.CLERK 0003 000a 0000 0000 0000 1ede 0004 0015 0000 |. 3139 3830 2d31 322d 3137 3a30 303a 3030 3a30 3000 | 1980-12-17 3a30 00. 0500 0a00 0000 0000 0000 0138 8000 0600 0aff ff00 | .8. 0000 0000 0000 0700 0a00 0000 0000 0000 |. 14 |. Column 0 (x0000), Len 10 (x000a) 0000 0000 0000 1cc9 |. Column 1 (x0001), Len 9 (x0009) 0000 0005 534d 4954 48 |.... SMITH Column 2 (x0002), Len 9 (x0009) 0000 0005 434c 4552 4b |.... CLERK Column 3 (x0003), Len 10 (x000a) 0000 0000 0000000 1ede |. Column 4 (x0004), Len 21 (x0015) 0000 3139 3830 2d31 322d 3137 3a30 303a 3030 3a30 |. 1980-12-17 Column 0000 Column 030 | 0 Column 5 (x0005), Len 10 (x000a) 0000 0000 0000 0001 3880 | .8. Column 6 (x0006), Len 10 (x000a) ffff 0000 0000 0000 |. Column 7 (x0007), Len 10 (x000a) 0000 0000 0000 0014 |.
3. Introduction of some commands
OPEN | FROM # Open a trail file HISTORY # View history command POSITION [| FIRST | LAST | EOF] # specify an address to view, which can be abbreviated as POS,RBA, starting with FIRST and 0 LAST and EOF set the current environment for the last ENV # View SHOW # View options [OPEN] # [TIME] # View time [ENV] # View environment settings as ENV [RECTYPE] # View operation type [FILTER] # View filtering settings FILTER [INClude | EXCLude] # used to set filtering The default is INclude are # filtering option RECTYPE # sets the operation type of filtering, and only finds records of the specified type FILTER RECTYPE UPDATE STRING [BOTH] / / [] # HEX [] # TRANSID # FILENAME # sets the filter object to find only the information of the specified object based on the object name or group name [catalog.]. FILTER FILENAME SCOTT.EMP (case sensitive) PROCESS # INT16 # INT32 # INT64 # STARTTIME # set the start time Starting to find information after the specified time, FILTER STARTTIME 2016-12-09 12:00:00 ENDTIME # sets the stop time to find only the data before the specified time FILTER ENDTIME 2016-12-09 13:00:00 SYSKEY [] # SYSKEYLEN [] # TRANSIND [] # UNDOFLAG [] # RECLEN [] # AUDITRBA [] # ANSINAME # GGSTOKEN [] [] # USERTOKEN [] [] # CSN | LogCSN [] [] # #: Ie 0GT 231 # # =, =,! =, = EQ, GT, LE, GE, LE, NE # FILTER SHOW # View filter settings Same as SHOW FILTERFILTER ENABLE | ON # enable filtering FILTER DISABLE | OFF # disable filtering FILTER CLEAR [|] # clear filtering setting FILTER MATCH ANY | ALL # set to match any item or all to match NEXT [] # View the next record by default NEXT 20 looks at the next 20 records, which can be abbreviated to N
4. Get command help
Logdump > HELP
Official document: http://docs.oracle.com/goldengate/c1221/gg-winux/GLOGD/GUID-471CB1E3-B124-44C0-9B81-B8FF42B4EF92.htm#GLOGD109
