Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\multimaster012.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Adding a Master Site to a Master Group</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-23T10:13:5Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Adding a Master Site to a Master Group" /> <meta name="relnum" content="11g Release 1 (11.1)" /> <meta name="partnum" content="A12345-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="multimaster011.htm" title="Previous" type="text/html" /> <link rel="next" href="multimaster013.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="multimaster011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BGBDGBHD" name="BGBDGBHD"></a><a id="ADVRP182" name="ADVRP182"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Adding a Master Site to a Master Group</h1> <p>Before adding a new master site to a master group, you must:</p> <ul> <li> <p>Prepare the new master site with the necessary replication administrator, propagator, receiver, schemas, and links to existing master sites.</p> </li> <li> <p>Modify the existing master sites so that they are aware of the new master site.</p> </li> <li> <p>Change to the master definition site of the specified master group to be able to add the required master site to the master group.</p> </li> </ul> <p>To complete these tasks, use the Configure Master Sites for Replication Wizard. When using the Wizard, consider the following issues:</p> <ul> <li> <p>You must specify all master sites in the system, <span class="italic">including all new master sites as well as the sites that the system already supports</span>. To specify all the master sites in the system, click <span class="bold">Add</span> on the <span class="bold">Master Sites</span> 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.</p> </li> <li> <p>The wizard will ask you to enter the passwords for the <code>SYSTEM</code> accounts and existing propagators in the system.</p> </li> <li> <p>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.</p> </li> </ul> <p>See <a href="setting_up001.htm#BABHDIJF">Setting Up Master Sites</a> for instructions on using the Configure Master Sites for Replication Wizard.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>When adding a master site to a master group that contains tables with circular dependencies or a table that contains a self-referential constraint, you must precreate the table definitions (<a href="multimaster032.htm#BGBCHBDB">Replicating Object Definitions to Master Sites</a>) and manually load the data at the new master site. The following is an example of a circular dependency: <code>Table A</code> has a foreign key constraint on <code>Table B</code>, and <code>Table B</code> has a foreign key constraint on <code>Table A</code>.</p> </div> <p>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:</p> <ul> <li> <p>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.</p> <p>If you choose this option, then see <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication Management API Reference</span></a> for instructions.</p> </li> <li> <p>Use Oracle Enterprise Manager. This options requires that the master group is quiesced.</p> </li> </ul> <p>If you choose to use Oracle Enterprise Manager, then, after suspending replication activity of the master group (<a href="multimaster019.htm#BGBBJCDC">Suspending Replication Activity for a Master Group</a>) 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:</p> <ol> <li> <p>In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.</p> </li> <li> <p>Click <span class="bold">Data Movement</span>.</p> </li> <li> <p>Under the Advanced Replication section, click <span class="bold">Manage</span>.</p> <p>The Administration Overview page appears.</p> </li> <li> <p>Under the <span class="bold">Multimaster Replication</span> section, click the number link next to <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('MASTER_GROUPS');"><span class="bold">Master Groups</span></a> to open the Master Groups page.</p> </li> <li> <p>Select the target master group that contains the master site that you want to remove and click <span class="bold">Edit</span>.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>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. <p>Under the Replication Activity column, click <span class="bold">Quiesce</span> to do so.</p> </p> </div> <p>The General subpage of the Edit Master Group page appears.</p> </li> <li> <p>Click <span class="bold">Master Sites</span>.</p> <p>The Master Sites subpage of the Edit Master Group page appears.</p> </li> <li> <p>Click <span class="bold">Add</span>.</p> <p>The Add Master Sites page appears.</p> </li> <li> <p>Select the database links for the master sites you want to add from the Database Link column.</p> </li> <li> <p>Select the appropriate propagation method for your master group:</p> <ul> <li> <p><span class="bold">Asynchronous:</span> 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.</p> </li> <li> <p><span class="bold">Synchronous:</span> 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.</p> </li> </ul> </li> <li> <p>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.</p> <p>See <a href="multimaster032.htm#BGBCHBDB">Replicating Object Definitions to Master Sites</a> for more information.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>For clustered tables, this option must be enabled. That is, the clustered table must be pre-created at the destination site.</p> </div> </li> <li> <p>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.</p> <p>See <a href="multimaster035.htm#BGBFDJIJ">Replicating Table Data to Master Sites</a> for more information.</p> </li> <li> <p>Click <span class="bold">OK</span> when you have completed selecting the target database links. The Add Destinations to Group dialog box appears.</p> </li> </ol> <p>After you have added the master site, then generate replication support for all master group tables (<a href="multimaster016.htm#BGBFEEAD">Generating Replication Support for Master Group Objects</a>); optionally apply the administrative requests that result from your changes at all master sites (<a href="administer004.htm#BABDJHFG">Applying Administrative Requests</a>), and then resume replication activity for the master group(<a href="multimaster020.htm#BGBDGFIB">Resuming Replication Activity for a Master Group</a>).</p> <div class="helpinfonote"> <p><span class="bold">API Equivalent: </span><code>DBMS_REPCAT.ADD_MASTER_DATABASE</code></p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="basic_concepts007.htm#BABIFJCG">What Is Multimaster Replication?</a></p> <p><a href="multimaster011.htm#BGBBFBGJ">Managing Master Groups</a></p> </div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2005, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="multimaster011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de