暂无图片
暂无图片
4
暂无图片
暂无图片
暂无图片

RAC新增节点,OGG如何调整

原创 问题归档 2019-03-20
1248

问题描述

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

专家解答

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

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 gro
最后修改时间:2019-04-14 10:17:00
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论