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
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