Suspending Replication Activity for a Master Group

Before completing most administrative operations for a master group or any of its replication objects, Oracle requires that you suspend replication activity for the master group at all master sites. Suspending replication activity is also called quiescing the master group.

Oracle requires that you suspend replication activity before completing the following administration tasks:

• Adding an object to a master group

• Altering the definition of an object in a master group

• Regenerating replication support for a replication object

• Adding or modifying conflict resolution for a replicated table

• Adding a master site destination to a master group

• Changing the propagation method for propagating deferred transactions from one site to another

You may need to suspend replication activity for a master group in other situations as well. For example, you may need to suspend replication activity so that you can perform queries and updates to resolve an unresolved conflict.

To suspend replication activity for a master group:

1. In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.

2. Click Data Movement.

3. Under the Advanced Replication section, click Manage.

   The Administration Overview page appears.

4. Under the Multimaster Replication section, click the number link next to Master Groups.

   The Master Groups page appears.

5. Under the Replication Activity column, click Quiesce.

   The button does not appear if the replication group is already quiesced.

After suspending replication activity for a master group, monitor the status of the master group at all master sites (Overview of Replication Administration) before completing any administrative operation at the master definition site. When you suspend replication activity for a master group, Oracle first pushes the deferred transaction queue at all master sites before quiescing the group. During the process, Oracle Enterprise Manager displays the status of the group "Stopping (Quiescing)." Once the process completes at all sites, Oracle Enterprise Manager displays the status of the group "Stopped (Quiesced)".