OGG的rep进程处理大事务时的查看rep处理进度的命令

2015-07-24 07:05:39 · 作者: · 浏览: 1
GGSCI (hosta) 17> info repxy

REPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNING
Checkpoint Lag       11:35:56 (updated 00:00:31 ago)
Log Read Checkpoint  File /u03/ggs/dirdat/aa004004
                     2015-07-10 01:50:21.094559  RBA 42328189


GGSCI (hosta) 18> !
info repxy

REPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNING
Checkpoint Lag       11:35:56 (updated 00:01:29 ago)
Log Read Checkpoint  File /u03/ggs/dirdat/aa004004
                     2015-07-10 01:50:21.094559  RBA 42328189--->记住这个RBA号(以下称为“info repxy”RBA号)


GGSCI (hosta) 19> send repxy, status

Sending STATUS request to REPLICAT REPXY ...
  Current status: Processing data
  Sequence #: 4004
  RBA: 49440615 --->记住这个RBA号(以下称为“send repxy, status”RBA号)
  36521 records in current transaction


GGSCI (hosta) 20> info REPXY

REPLICAT   REPXY     Last Started 2015-07-10 13:17   Status RUNNING
Checkpoint Lag       11:35:56 (updated 00:01:54 ago)
Log Read Checkpoint  File /u03/ggs/dirdat/aa004004
                     2015-07-10 01:50:21.094559  RBA 42328189--->
还是这个RBA号(“info repxy”RBA号未变) GGSCI (hosta) 21> send repxy, status Sending STATUS request to REPLICAT REPXY ... Current status: Processing data Sequence #: 4005 RBA: 7106039 --->(“send repxy, status”RBA号已经该改变,实际上已经切换到了4005号trail,见一行。) 63454 records in current transaction GGSCI (hosta) 22> info REPXY REPLICAT REPXY Last Started 2015-07-10 13:17 Status RUNNING Checkpoint Lag 11:35:56 (updated 00:02:22 ago) Log Read Checkpoint File /u03/ggs/dirdat/aa004004 2015-07-10 01:50:21.094559 RBA 42328189--->还是这个RBA号(“info repxy”RBA号未变)

?

总结:若是rep进程处理大的事务,会导致rep进程检查点的更新有延迟,此种情况下,使用"info rep进程"命令不足以真实反映rep进程的处理进度,此时,应该使用"send rep进程, status"命令