This discussion is archived
1 Reply Latest reply: Apr 17, 2013 1:49 AM by 962344 RSS

goldengate抽取延迟3-4小时

962344 Newbie
Currently Being Moderated
请教刘大及各位高手:

目前我们生产库的一套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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points