Oracle GoldenGate Logdump – An Introduction

Oracle GoldenGate Logdump is a utility that allows you to read trails files created by Oracle GoldenGate.  Oracle GoldenGate is a replication program that is used to replicate homogeneous and heterogeneous data from a database to another database, java, flat file, etc.  GoldenGate transfers this data between source and target via proprietary, binary files called trail files.  These trail files are created by the extract process and read by the replicat process.  In addition, in the event of issues you can read trail files via the included utility called Oracle GoldenGate Logdump.  Oracle Goldengate Logdump allows you to read, search and perform analysis on an individual trail file.

For tools to help manage GoldenGate performance, click here

This series of blog entries will walk you through the basics of Oracle GoldenGate Lgdump along with some advanced uses of logdump.  We will get started with invoking logdump.  From the GoldenGate home directory run the following command to invoke Oracle GoldenGate Logdump.

[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

You will always want to turn on detail, detail data, header information (ghdr) and user and ggs tokens as shown above.  Once you have configured what you want to see, open a trail file by using the open command:

Logdump 6 >open dirdat/lb000000004

Current LogTrail is /u02/app/oracle/product/12.3.0.1/gghome_1/dirdat/lb000000004

Once the trail file is opened you can get some statistics by running count as shown here:

Logdump 18 >count

LogTrail /u02/app/oracle/product/12.3.0.1/gghome_1/dirdat/lb000000004 has 89053 records

Total Data Bytes           12588691

Avg Bytes/Record              141

Insert                        60702

Update                        28341

RestartOK                         1

Metadata Records                  8

Others                            1

After Images                  89044

Average of 28953 Transactions

Bytes/Trans …..        582

Records/Trans …          3

Files/Trans …..          0

Partition 0

Total Data Bytes                 79

Avg Bytes/Record               39

RestartOK                         1

Metadata Records                  1

After Images                      1

*FileHeader*                                       Partition 0

Total Data Bytes               1431

Avg Bytes/Record             1431

Others                            1

SOE.ADDRESSES                                      Partition 12

Total Data Bytes             458945

Avg Bytes/Record              158

Insert                         2892

After Images                   2892

SOE.ADDRESSES                                      Partition 0

Total Data Bytes                862

Avg Bytes/Record              862

Metadata Records                  1

SOE.CARD_DETAILS                                   Partition 0

Total Data Bytes                634

Avg Bytes/Record              634

Metadata Records                  1

SOE.CARD_DETAILS                                   Partition 12

Total Data Bytes             281765

Avg Bytes/Record              109

Insert                         2585

After Images                   2585

SOE.CUSTOMERS                                      Partition 12

Total Data Bytes             741810

Avg Bytes/Record              256

Insert                         2585

Update                          307

After Images                   2892

SOE.CUSTOMERS                                      Partition 0

Total Data Bytes               1534

Avg Bytes/Record             1534

Metadata Records                  1

SOE.INVENTORIES                                    Partition 12

Total Data Bytes            1578544

Avg Bytes/Record               88

Update                        17938

After Images                  17938

SOE.INVENTORIES                                    Partition 0

Total Data Bytes                330

Avg Bytes/Record              330

Metadata Records                  1

SOE.LOGON                                          Partition 12

Total Data Bytes            1499958

Avg Bytes/Record               53

Insert                        27781

After Images                  27781

SOE.LOGON                                          Partition 0

Total Data Bytes                321

Avg Bytes/Record              321

Metadata Records                  1

SOE.ORDERS                                         Partition 0

Total Data Bytes               1384

Avg Bytes/Record             1384

Metadata Records                  1

SOE.ORDERS                                         Partition 12

Total Data Bytes            4488690

Avg Bytes/Record              283

Insert                         6921

Update                         8939

After Images                  15860

SOE.ORDER_ITEMS                                    Partition 12

Total Data Bytes            3531449

Avg Bytes/Record              184

Insert                        17938

Update                         1157

After Images                  19095

SOE.ORDER_ITEMS                                    Partition 0

Total Data Bytes                955

Avg Bytes/Record              955

Metadata Records                  1

In the next installment two installments:

Viewing an Oracle GoldenGate Logdump Record

How to Traverse a Trail File in Logdump

We will provide more detail on how to best use the Oracle GoldenGate Logdump utility.

Announcement:   We are currently working on a GUI wrapper for LogDump which will be available for beta testing in the next few months. To participate in the Beta, please register here.

By | 2018-07-03T12:55:42+00:00 June 25th, 2018|Uncategorized|Comments Off on Oracle GoldenGate Logdump – An Introduction