OGG-00868 的解决办法(RAC节点)

来源:互联网 发布:网络电工是什么 编辑:程序博客网 时间:2024/06/10 11:25
2017-07-25 22:25:05  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, ymsextr.prm:  The number of Oracle redo threads (1) is not the same as the number of checkpoint threads (2). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT <group name>, TRANLOG, THREADS 1, BEGIN...).2017-07-25 22:25:05  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ymsextr.prm:  PROCESS ABENDING.

解决方法:

先将原来Add的extract 删掉,

GGSCI (yms243) 16> delete extract ymsextr

然后再以多节点形式加上,

GGSCI (yms243) 17> add extract ymsextr,tranlog,threads 1,begin nowEXTRACT added.GGSCI (yms243) 18> add exttrail dirdat/ym,extract ymsextr,megabytes 100EXTTRAIL added.GGSCI (yms243) 19> start extract ymsextrSending START request to MANAGER ...EXTRACT YMSEXTR starting