How to Use Logdump and how to use logdump

How to Use Logdump and how to use logdump

How to Use Logdump

 

 

 

 

 

Written on Thursday, April 16, 2015

Prepared by: snail mail

QQ: 295013648

 

 

Use the following command in GGSCI to view the currently processed queue file and RBA number, for example:

Example 9-47:

 

GGSCI (br-jl-accs-db1) 3> info REPYXA

Replicat repyxa Last Started Status RUNNING

CheckpointLag 00:00:00 (updated 136: 41: 42ago)

LogRead Checkpoint File./dirdat/p1000556First Record RBA 59193235

 

Run the logdump command in the GoldenGate installation directory to open the queue file to be viewed:

Example 9-48:

 

Logdump1> open./dirdat/p1000556

CurrentLogTrail is./dirdat/p1000556

Logdump2> ghdr on

Logdump3> detail on

Logdump4> detail data

Logdump5> usertoken on

Logdump6> pos 59193235 the RBA number displayed by the INFO command above

Logdump7> n

 

Continue to input n to display the currently processed tables and related operations.