Loading or Re-Synchronising Data in a Replication Cluster
To strop replication and not to place a system into read only status please execute following steps.
Execute DBMS_REPUTIL.replication_OFF;
You need to execute this API at each site. This will disable all triggers and you can manually load data at respective sites.
Once the job is done enable Triggers using
Execute DBMS_REPUTIL.replication_On;
Now all further changes would be replicated.
What is a difference between QUISCED Group and Replication off?
A quisced group puts all sites under read only status while above API could be used on individual replication master sites.
If you want to sync Table Data at Multimaster Replicated Sites please seeĀ this post
Leave a Reply
You must be logged in to post a comment.