GoldenGate Logdump Cheat Sheet

Reviewing Trail Files

ghdr on
fileheader detail
detail on
detail data
usertoken detail
decrypt on KEYNAME secretkey
ggstokens detail data

ghdr - Controls the display of header information.

fileheader

Filtering and Counting

Filter by table name (FILENAME in GoldenGate speak):

FILTER FILENAME DB.SCHEMA.TABLENAME
COUNT
FILTER
FILTER OFF

Filter by string

ghdr on
fileheader detail
detail on
detail data
usertoken detail
open ./dirdat/AA0000001
pos 0
FILTER INCLUDE STRING '2098157';
filter match all
n
n
n