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

最新推荐文章于 2022-01-22 20:11:34 发布

msdnchina

最新推荐文章于 2022-01-22 20:11:34 发布

阅读量5.1k

点赞数 1

分类专栏： Oracle GoldenGate

本文链接：https://blog.csdn.net/msdnchina/article/details/46840407

版权

Oracle GoldenGate 专栏收录该内容

101 篇文章 0 订阅

订阅专栏

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"命令