问题描述
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