Using Filtering in GoldenGate Logdump

Filtering a Trail File in GoldenGate Logdump

Now that you have had a chance to read my blogs on GoldenGate Logdump and understanding how to browse around the trailfile we will start looking at some more advanced topics. As a review, use the following to invoke GoldenGate logdump.
From the GoldenGate home directory run the following command to invoke the logdump command.[oracle@ora-oem gghome_1]$ ./logdump

Oracle GoldenGate Log File Dump Utility for Oracle
Version 12.3.0.1.2 OGGCORE_12.3.0.1.0_PLATFORMS_171208.0005

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.

Logdump 1 >detail on
Logdump 2 >detail data
Logdump 3 >ghdr on
Logdump 4 >ggstoken detail
Logdump 5 >usertoken detail
Logdump 6 >open dirdat/lb000000004 — Replaced by your trailfile

Once you have opened the trailfile you can view records, run counts, etc.. We covered many of those commands in a previous blog entry.
In this installment you will learn how to use the filter command within GoldenGate Logdump. Filtering allows you to either include or exclude specific data. Filtering can be done on start and end time, specific data and/or table names. The following allows for filtering of a specific table:

Logdump 437 >filter filename GG20AP01.SOE.ORDER_ITEMS
Logdump 438 >count
** Count begins at RBA 1922
Scanned 10000 records, RBA 2676695, 2018/04/19 10:05:15.000.000
Scanned 20000 records, RBA 5367683, 2018/04/19 10:05:22.000.000
Scanned 30000 records, RBA 8051374, 2018/04/19 10:05:30.000.000
Scanned 40000 records, RBA 10753634, 2018/04/19 10:05:36.000.000
Scanned 50000 records, RBA 13455306, 2018/04/19 10:05:42.000.000
LogTrail /u01/app/oracle/product/12.3.0.1.2/gghome_1/dirdat/la000000013 has 11833 records
Total Data Bytes 2155001
Avg Bytes/Record 182
Insert 9438
FieldComp 2394
Metadata Records 1
Before Images 1197
After Images 10635
Filtering matched 11833 records
suppressed 55502 records

Average of 2114 Transactions
Bytes/Trans ….. 1288
Records/Trans … 5
Files/Trans ….. 0

GG20AP01.SOE.ORDER_ITEMS Partition 0
Total Data Bytes 955
Avg Bytes/Record 955
Metadata Records 1

GG20AP01.SOE.ORDER_ITEMS Partition 12
Total Data Bytes 2154046
Avg Bytes/Record 182
Insert 9438
FieldComp 2394
Before Images 1197
After Images 10635

This count information refers to the filtered table only.
To see what filters are set use filter show. To clear a filter user filter clear.
To see all the options to filter use the help feature of GoldenGate logdump.

FILTER SHOW
FILTER ENABLE | ON – Enable filtering
FILTER DISABLE | OFF – Disable filtering
FILTER CLEAR [ | ] FILTER MATCH ANY | ALL
FILTER [INClude | EXCLude] are
RECTYPE
STRING [BOTH] // [] HEX [] TRANSID
FILENAME
PROCESS
INT16
INT32
INT64
STARTTIME
ENDTIME
SYSKEY [] SYSKEYLEN [] [] TRANSIND [] UNDOFLAG [] RECLEN [] AUDITRBA [] ANSINAME
GGSTOKEN [] [] USERTOKEN [] [] CSN | LogCSN [] []

:, ie 0:231

=, ==, !=, , , = EQ, GT, LE, GE, LE, NE

GoldenGate Logdump filtering can be used to find data that has caused an issue in GoldenGate or corrupted data. Please note that GoldenGate Logdump operates on one trail file at a time. So, if you are looking for specific data it might be quite time consuming if you are searching many trailfiles.

By | 2018-05-18T16:39:16+00:00 April 26th, 2018|GoldenGate|Comments Off on Using Filtering in GoldenGate Logdump