Tuesday, December 26, 2017

How to check which Trail file Golden gate reading for replicat and RBA?

we can check the where the GG reads from the trail file using the below method.

step-1

using the info command find the current RBA where replicat its running
GGSCI (server_name) 1> info rep5

REPLICAT   LHGRP5    Last Started 2017-12-18 17:07   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint  File/dat/rt000043
                     2017-12-19 18:56:35.389347  RBA 6796391


GGSCI (server_name) 2> exit
step-2
open the logdump utility to check the latest trail file where GG writting and move the position to end using :POS EOF and not down the RBA,if both RBA matches then we can confirm that GG completed  the reading of trail file and it reached the end of the trail file with NO more records to process.
[ggsmgr@server_name]:/home8>logdump

Oracle GoldenGate Log File Dump Utility
Version 11.1.1.0.11 Build 001

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



Logdump 1 >/dat/rt000043
Current LogTrail is /dat/rt000043
Logdump 2 >pos eof
Reading forward from RBA 6796391

No comments:

Post a Comment