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

最新推荐文章于 2024-07-15 02:22:46 发布

HeavenBen

最新推荐文章于 2024-07-15 02:22:46 发布

阅读量6.5k

点赞数 1

本文链接：https://blog.csdn.net/QDseashore/article/details/76099813

版权

Oracle 同时被 3 个专栏收录

64 篇文章 0 订阅

订阅专栏

MiddleWare

7 篇文章 0 订阅

订阅专栏

GoldenGate

7 篇文章 0 订阅

订阅专栏

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). EXT
RACT 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 now
EXTRACT added.


GGSCI (yms243) 18> add exttrail dirdat/ym,extract ymsextr,megabytes 100
EXTTRAIL added.

GGSCI (yms243) 19> start extract ymsextr

Sending START request to MANAGER ...
EXTRACT YMSEXTR starting