Adding a Master Site to a Master Group

Before adding a new master site to a master group, you must:

• Prepare the new master site with the necessary replication administrator, propagator, receiver, schemas, and links to existing master sites.

• Modify the existing master sites so that they are aware of the new master site.

• Change to the master definition site of the specified master group to be able to add the required master site to the master group.

To complete these tasks, use the Configure Master Sites for Replication Wizard. When using the Wizard, consider the following issues:

• You must specify all master sites in the system, including all new master sites as well as the sites that the system already supports. To specify all the master sites in the system, click Add on the Master Sites page of the wizard to open the Add Site dialog box. Use the Add Master Sites page to specify all of the master sites in the system, including the existing master sites and the new master sites.

• The wizard will ask you to enter the passwords for the SYSTEM accounts and existing propagators in the system.

• Optionally, you can choose to change system settings in the multimaster environment, including the administrator and propagator/receiver accounts, and default and site-specific propagation settings.

See Setting Up Master Sites for instructions on using the Configure Master Sites for Replication Wizard.

After you use the Configure Master Sites for Replication Wizard to prepare a multimaster replication system for the addition of a new master site, you are ready to add the new master site to the group. You have two ways to add master sites to the master group:

• Use the Advanced Replication Management API Reference. This option enables you to add a new master site to a master group without quiescing the master group.

  If you choose this option, then see Oracle Database Advanced Replication Management API Reference for instructions.

• Use Oracle Enterprise Manager. This options requires that the master group is quiesced.

If you choose to use Oracle Enterprise Manager, then, after suspending replication activity of the master group (Suspending Replication Activity for a Master Group) and changing to the master definition site of the specified master group, add a new destination to the master group by completing the following steps:

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 to open the Master Groups page.

5. Select the target master group that contains the master site that you want to remove and click Edit.

   Note: If the master group is not quiesced, then Oracle Enterprise Manager displays a message stating that the master site cannot be added unless the master group is quiesced.

   Under the Replication Activity column, click Quiesce to do so.

   The General subpage of the Edit Master Group page appears.

6. Click Master Sites.

   The Master Sites subpage of the Edit Master Group page appears.

7. Click Add.

   The Add Master Sites page appears.

8. Select the database links for the master sites you want to add from the Database Link column.

9. Select the appropriate propagation method for your master group:

   • Asynchronous: Changes to local replicated tables are stored in a local queue and then pushed to the master site either by a job or a manual push. Also known as store-and-forward data replication.

   • Synchronous: Changes to the local replica are applied to the master site as part of the same transaction. Also known as real-time data replication. Synchronous propagation requires very reliable network connections and systems because, if a transaction cannot be applied to all sites in the master group for any reason, it is rolled back at all sites.

10. Select the box under Use Existing Object column if the object you are adding to a replicated environment already exists at the destination site. In this case, Oracle uses the existing object.

    See Replicating Object Definitions to Master Sites for more information.

    Note: For clustered tables, this option must be enabled. That is, the clustered table must be pre-created at the destination site.

11. Select the box in the Copy Row Data column if you want to initially populate replicated objects by copying row data from the master site to the replicated objects when the objects are added to new destinations.

    See Replicating Table Data to Master Sites for more information.

12. Click OK when you have completed selecting the target database links. The Add Destinations to Group dialog box appears.

After you have added the master site, then generate replication support for all master group tables (Generating Replication Support for Master Group Objects); optionally apply the administrative requests that result from your changes at all master sites (Applying Administrative Requests), and then resume replication activity for the master group(Resuming Replication Activity for a Master Group).