TimesTen同步日志积压了28个,明显是同oracle的同步出现了问题。
Command> call ttlogholds;
< 5749,
242335368, Replication , ABC:_ORACLE >
< 5776, 13678576, Checkpoint , abc.ds0 >
< 5776, 71723432, Checkpoint , abc.ds1 >
3 rows found.
红色字体的数据一直不变。说明同步出现异常。
ttstatus检查rep和cache的状态都是启动的:
[root@abc abc]# ttstatus
TimesTen status report as of Wed Mar 21 14:07:24 2012
Daemon pid 23627 port 17001 instance tt70
TimesTen server pid 23636 started on port 17003
TimesTen webserver pid 23634 started on port 17005
Replication 16976 0x0000000012012630 LOGFORCE 11
Replication 16976 0x000000001208b640 REPHOLD 2
Replication 16976 0x00000000120dc3c0 RECEIVER 17
Replication 16976 0x00000000120fc7d0 TRANSMITTER 42
Replication 16976 0x0000000012472fb0
RECEIVER 85
Replication 16976 0x0000000012693c90
RECEIVER 86
Replication 16976 0x000000001286d0f0
RECEIVER 83
Replication 16976 0x0000000012a8dc00
RECEIVER 15
Replication 16976 0x0000000012c492b0
RECEIVER 90
Replication 16976 0x0000000012dfe9c0
RECEIVER 91
。。。
Replication policy : Manual
Replication agent is running.
Cache agent policy : Manual
TimesTen's Cache agent is running for this data store
多出了很多Replication
RECEIVER进程,这让我想起了刚才在修改TimesTen同步指向时,没有停止rep agent导致同步异常。接下来重启了TimesTen复制后,同步状态恢复正常:
[root@abc abc]# ttadmin -repstop abc
RAM Residence Policy : inUse
Replication Agent Policy : manual
Replication Manually Started : False
Cache Agent Policy : manual
Cache Agent Manually Started : True
[root@abc abc]# ttadmin -repstart abc
RAM Residence Policy : inUse
Replication Agent Policy : manual
Replication Manually Started : True
Cache Agent Policy : manual
Cache Agent Manually Started : True
小结:修改TimesTen的同步指向前要停掉rep agent。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12355989/viewspace-719178/
,如需转载,请注明出处,否则将追究法律责任。