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

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