1 Reply Latest reply: Apr 17, 2013 3:49 AM by 962344 RSS

    goldengate抽取延迟3-4小时

    962344
      请教刘大及各位高手:

      目前我们生产库的一套ogg进程,抽取进程延迟达到3-4个小时,请问有何办法可以减少延迟?

      环境介绍如下:
      现在共三套数据库,复制关系从A->B->C,A&B为同机房,C为异地。A为IBM小机P750,B为P550,C为PCSERVER,数据库的版本皆为10.2.0.5,OGG版本为112101.
      目前A->B的extract进程无延迟,B的replicat进程(REPB&REPC&REPD)延迟为3-5S,从B机配置了抽取进程exsb,转发进程pumsb,C端有replicat,目前B端的exsb延迟比较大,显示如下:
      GGSCI (lmsdb2) 1> info all

      Program Status Group Lag at Chkpt Time Since Chkpt

      MANAGER RUNNING
      EXTRACT RUNNING EXSB 00:59:28 00:00:03
      EXTRACT RUNNING PUMSB 00:00:00 00:00:09
      REPLICAT RUNNING REPB 00:00:00 00:00:00
      REPLICAT RUNNING REPC 00:00:00 00:00:00
      REPLICAT RUNNING REPD 00:00:00 00:00:01


      GGSCI (lmsdb2) 2> lag exsb

      Sending GETLAG request to EXTRACT EXSB ...
      Last record lag: 3575 seconds.


      GGSCI (lmsdb2) 3> lag pumsb

      Sending GETLAG request to EXTRACT PUMSB ...
      Last record lag: 3582 seconds.