RAC新增节点,OGG如何调整

问题归档 2019-03-20
59
2 0
摘要:Rac新增了节点,ogg抽取进程如何调整?

问题描述

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
「喜欢文章,快来给作者赞赏墨值吧」

评论

0
2
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
近期活动
全部
相关课程
全部