- 最后登录
- 2013-7-31
- 在线时间
- 48 小时
- 威望
- 0
- 金钱
- 259
- 注册时间
- 2012-12-10
- 阅读权限
- 10
- 帖子
- 45
- 精华
- 0
- 积分
- 0
- UID
- 802
|
1#
发表于 2013-7-17 01:02:29
|
查看: 3285 |
回复: 0
本帖最后由 Teddy.huang 于 2013-7-17 01:10 编辑
OS: SUSE 11 P1 DB: 11G R2
测试了一个两节点上的gg,在ACFS上部署的,
节点1上的状态:
GGSCI (crmdb1) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING MYEXT 00:00:00 00:00:03
EXTRACT RUNNING MYPUMP 00:00:00 00:00:00
节点2上的状态:
GGSCI (crmdb2) 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING MYEXT 00:00:00 00:00:07
EXTRACT ABENDED MYPUMP 00:00:00 00:00:04
为什么两边都是running, 然后mypump节点2上状态又不对,
不过数据都可以正常同步到target,
然后添加了ggatevip, ggateapp,但是却没法relocate,只能在节点1上运行,没法实现failover,
relocate的时候在节点2上报错:
2013-07-16 00:38:08 ERROR OGG-01224 Oracle GoldenGate Manager for Oracle, mgr.prm: Address already in use.
2013-07-16 00:38:08 ERROR OGG-01668 Oracle GoldenGate Manager for Oracle, mgr.prm: PROCESS ABENDING.
请问节点2上的进程状态正常吗?是不是应该stop?
多谢。
我是参考
https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=302529894878916&id=1313703.1&_afrWindowMode=0&_adf.ctrl-state=uw1unx9yb_537
|
|