You can use the GoldenGate Logdump utility to view records in the GoldenGate trail files. The Logdump utility is part of the regular GoldenGate software installation. Logdump lets you view the unstructured trail data in hex and ASCII format and count the number of records in the trail for debugging purposes. You can also filter the trail for desired records and save them to a new trail for reprocessing if needed.?
how to use logdump：
[oracle@ogg1 ogg]$ ./logdump
Oracle GoldenGate Log File Dump Utility for Oracle Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Logdump 44 >help
FC [ | ] – Edit previous command HISTORY – List previous commands OPEN | FROM – Open a Log file RECORD | REC - Display audit record NEXT [ ] - Display next data record SKIP [ ] [FILTER] – Skip down records FILTER – Apply filter during skip COUNT – Count the records in the file [START[time] ,] [END[time] ,] [INT[erval] ,] [LOG[trail] ,] [FILE ,] [DETAIL ] format is [[yy]yy-mm-dd] [hh[:mm][:ss]] POSITION [ | FIRST | LAST | EOF ] – Set position in file REVerse | FORward - Set read direction RECLEN [ ] - Sets max output length EXIT | QUIT - Exit the program FILES | FI | DIR – Display filenames ENV - Show current settings VOLUME | VOL | V – Change default volume DEBUG - Enter the debugger GHDR ON | OFF – Toggle GHDR display DETAIL ON | OFF | DATA – Toggle detailed data display RECLEN - Set data display length SCANFORHEADER (SFH) [PREV] - Search for the start of a header SCANFORTYPE (SFT) – Find the next record of | [,] SCANFORRBA (SFR) – Find the next record with - syskey = -1 scans for next record , SCANFORTIME (SFTS) – Find the next record with timestamp [,] format is [[yy]yy-mm-dd] [hh[:mm][:ss]] SCANFORENDTRANS (SFET) – Find the end of the current transaction SCANFORNEXTTRANS (SFNT) – Find start of the next transaction SHOW
]
HEX [
] TRANSID FILENAME PROCESS INT16 <16-bit integer> INT32 <32-bit integer> INT64 <64-bit integer> STARTTIME ENDTIME SYSKEY [] <32/64-bit syskey> SYSKEYLEN [] [] TRANSIND [] UNDOFLAG [] RECLEN [] AUDITRBA [] ANSINAME GGSTOKEN [] [] USERTOKEN [] [] CSN | LogCSN [] [] :, ie 0:231 =, ==, !=, <>, <, >, <=, >= EQ, GT, LE, GE, LE, NE X [string] - Execute TRANSHIST nnnn - Set size of transaction history TRANSRECLIMIT nnnn - Set low record count threshold TRANSBYTELIMIT nnnn – Set low byte count threshold LOG {STOP} | { [TO] } – Write a session log BEGIN – Set next read position using a timestamp SAVEFILECOMMENT on | OFF - Toggle comment records in a savefile SAVE [!] - Write data to a savefile are nnn RECORDS | nnn BYTES [NOCOMMENT] - Suppress the Comment header/trailer recs, Default [COMMENT] - Insert Comment header/trailer recs [OLDFORMAT] - Force oldformat records [NEWFORMAT] - Force newformat records [TRUNCATE ] - purgedata an existing savefile [EXT ( , [,])] – Savefile Extent sizes on NSK [MEGabytes ] – For extent size calculation [TRANSIND ] – Set the transind field [COMMITTS ] – Set the committs field USERTOKEN on | OFF