How to use Goldengate Logdump Utility
Go to the Oracle GoldenGate Software directory.
Open a Trail File
To open a trail file and read it’s content, specify the trail file at the logdump prompt. Trail files are usually found in the GoldenGate dirdat directory.
ls -lrt $GG_HOME/dirata
-rw-rw-rw- 1 oracle oinstall 78325 Dec 7 10:38 GG000001
-rw-rw-rw- 1 oracle oinstall 78325 Dec 7 10:42 GG000002
-rw-rw-rw- 1 oracle oinstall 78325 Dec 7 10:55 GG000003
You can also determine the current trail file directory/name by running the “INFO process_name” command at the ggsci prompt.
Open and view the details of local trail file.
Logdump> OPEN ./dirdat/GG000001
Change the file name and location as required.
Set Output Format
Enable the following options so that you are able to view the results in a readable format in your Logdump sessionL
Set trail file header detail on
The FILEHEADER contains the header details of the currently opened trail file.
Logdump> FILEHEADER DETAIL
Logdump> GHDR ON
Set Column Details on
It displays the list of columns, their ID, length, Hex values etc.
Logdump> DETAIL ON
User token details
User token is the user defined information stored in trail, associated with the table mapping statements. The CSN (SCN in Oracle Database) associated with the transaction is available in this section.
Logdump> USERTOKEN DETAIL
Set length of the record to be displayed
In this case it is 128 characters.
Logdump> RECLEN 128
Viewing the Records
To view particular records in the trail files, navigate as below in the local trail file.
First record in the trail file
Here “0” is the beginning of the trial file
Logdump> POS 0
Move to a specific record, at a particular RBA
The “xxxx” is the RBA number.
Logdump> POS xxxx
Next record in the opened trail file