Data Management

Adding a New Site in an Existing Oracle Multimaster Replication without Quiescing the Replication

Date Added: Aug 2011
Format: PDF

In this paper, the authors present a new solution, which adds a new database server on an existing oracle multi-master data replication system with Online Instantiation method. During this time the system is down, because they cannot execute DML statements on replication objects but they can only make queries. The time for adding the new database server depends on the number of objects, on the replication group and on the network conditions. They propose to add a new layer between replication objects and the database sessions, which contain DML statements.