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
RECORD | REC - Display audit record
NEXT [ ] - Display next data record
SKIP [ ] [FILTER] – Skip down
FILTER – Apply filter during skip
COUNT – Count the records in the file
[START[time] ,]
[END[time] ,]
[INT[erval] ,]
[LOG[trail] ,]
[FILE ,]
[DETAIL ]
[[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
SCANFORHEADER (SFH) [PREV] - Search for the start of a header
SCANFORTYPE (SFT) – Find the next record of
[,]
SCANFORRBA (SFR) – Find the next record with
,
SCANFORTIME (SFTS) – Find the next record with timestamp
[,]
[[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 [] []
=, ==, !=, <>, <, >, <=, >= EQ, GT, LE, GE, LE, NE
X
TRANSHIST nnnn - Set size of transaction history
TRANSRECLIMIT nnnn - Set low record count threshold
TRANSBYTELIMIT nnnn – Set low byte count threshold
LOG {STOP} | { [TO]
BEGIN
SAVEFILECOMMENT on | OFF - Toggle comment records in a savefile
SAVE
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