暂无图片
分享
Voyager
2019-03-19
Ogg

Rac新增了节点,ogg抽取进程如何调整?

收藏
分享
2条回答
默认
最新
章芋文

需要删除进程后重新添加:

1、On the source and target systems, run GGSCI.

2、Stop Extract and Replicat.

STOP EXTRACT group
STOP REPLICAT group

3、On the source system, issue the following command to delete the primary Extract group and the data pump.

DELETE EXTRACT group
DELETE EXTRACT pump_group

4、On the target system, issue the following command to delete the Replicat groups.

DELETE REPLICAT group

5、Using standard operating system commands, remove the local and remote trail files.

6、Add the primary Extract group again with the same name as before, specifying the new number of RAC threads.

ADD EXTRACT group TRANLOG, THREADS n, BEGIN NOW

7、Add the local trail again with the same name as before.

ADD EXTTRAIL trail, EXTRACT group

8、Add the data pump Extract again, with the same name as before.

ADD EXTRACT group EXTTRAILSOURCE trail, BEGIN NOW

9、Add the remote trail again with the same name as before.

ADD RMTTRAIL trail, EXTRACT group

10、Add the Replicat group with the same name as before. Leave off any BEGIN options so that processing begins at the start of the trail.

ADD REPLICAT group EXTTRAIL trail

11、Start all processes, using wildcards as appropriate. If the re-created processes are the only ones in the source and target Oracle GoldenGate instances, you can use START ER * instead of the following commands.

START EXTRACT group
START REPLICAT grou
暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏