OGG rep process to view the rep processing progress when processing large transactions, oggrep
GGSCI (hosta) 17> info repxyREPLICAT REPXY Last Started 11:35:56 Status RUNNINGCheckpoint Lag 00:00:31 (updated 01:50:21 ago) Log Read Checkpoint File/u03/ggs/dirdat/aa004004. 094559 RBA 42328189 GGSCI (hosta) 18>! Info repxyREPLICAT REPXY Last Started 11:35:56 Status RUNNINGCheckpoint Lag 00:01:29 (updated 01:50:21 ago) Log Read Checkpoint File/u03/ggs/dirdat/aa004004. 094559 RBA 42328189 ---> remember this RBA ("info repxy" RBA) GGSCI (hosta) 19> send repxy, statusSending STATUS request to replicat repxy... current status: Processing data Sequence #: 4004 RBA: 49440615 ---> remember this RBA number (hereinafter referred to as "s End repxy, status "RBA) 36521 records in current transactionGGSCI (hosta) 20> info repxyreplicat repxy Last Started 11:35:56 Status RUNNINGCheckpoint Lag 00:01:54 (updated ago) log Read Checkpoint File/u03/ggs/dirdat/aa004004 2015-07-10 01:50:21. 094559 RBA 42328189 ---> This RBA number ("info repxy" RBA number has not changed) GGSCI (hosta) 21> send repxy, statusSending STATUS request to replicat repxy... curre Nt status: Processing data Sequence #: 4005 RBA: 7106039 ---> ("send repxy, status" RBA has already changed. In fact, it has already switched to trail 4005. See this line .) 63454 records in current transactionGGSCI (hosta) 22> info repxyreplicat repxy Last Started 11:35:56 Status RUNNINGCheckpoint Lag 00:02:22 (updated ago) log Read Checkpoint File/u03/ggs/dirdat/aa004004 2015-07-10 01:50:21. 094559 RBA 42328189 ---> or this RBA number ("info repxy" RBA number has not changed)
Summary: If the rep process processes large transactions, the update of the rep process checkpoint may be delayed. In this case, the "info rep process" command is not enough to reflect the progress of the rep process, in this case, use the "send rep process, status" command
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.