Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\multimaster026.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>Removing a Master Site from 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="Removing a Master Site from 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="multimaster025.htm" title="Previous" type="text/html" /> <link rel="next" href="multimaster027.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="multimaster025.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster027.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BGBIIIFG" name="BGBIIIFG"></a><a id="ADVRP197" name="ADVRP197"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Removing a Master Site from a Master Group</h1> <p>After suspending the replication activity of a master group (<a href="multimaster019.htm#BGBBJCDC">Suspending Replication Activity for a Master Group</a>), you can remove master sites from the master group. To remove a master site from a master group:</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>You must not drop replicated objects without first removing them from the master group.</p> </div> <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 Multimaster Replication section, click the number link next to <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('MASTER_GROUPS');">Master Groups</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> <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>Select the master sites that you want to remove from the master group and click <span class="bold">Remove</span>.</p> </li> </ol> <p>After you have removed the master sites, generate replication support for all master group tables (<a href="multimaster018.htm#BGBEIDGB">Generating Replication Support for All Master Group Tables</a>), optionally apply the administrative requests (<a href="administer004.htm#BABDJHFG">Applying Administrative Requests</a>) that result from your changes at all master sites, and then resume replication activity for the master group (<a href="multimaster020.htm#BGBDGFIB">Resuming Replication Activity for a Master Group</a>).</p> <p>If you would like to use APIs to remove a site without quiescing, refer to <a href="#BGBHECGJ">Special Circumstances</a> for more information.</p> <div class="helpinfonote"> <p><span class="bold">API Equivalent: </span><code>DBMS_REPCAT.REMOVE_MASTER_DATABASES</code></p> </div> <a id="BGBHECGJ" name="BGBHECGJ"></a><a id="ADVRP393" name="ADVRP393"></a> <p class="subhead2">Special Circumstances</p> <p>The sites being removed from a master group do not need to be accessible. When a master site will not be available for an extended period of time due to a system or network failure, you might decide to drop the master site from the master group. However, because the site is unavailable, you most likely cannot suspend replication activity for the master group. You can use the <code>REMOVE_MASTER_DATABASES</code> procedure in the <code>DBMS_REPCAT</code> package to remove master sites from a master group, even if the master group is not quiesced.</p> <p>If this is the case, you are responsible for:</p> <ul> <li> <p>Cleaning up the deferred transaction queue</p> </li> <li> <p>Removing any data inconsistencies</p> </li> </ul> <p>Specifically, the next time that you suspend replication activity for a master group, you must complete the following steps as soon as possible after the unavailable master sites are removed:</p> <ol> <li> <p>Suspend replication activity for a master group. See <a href="multimaster019.htm#BGBBJCDC">Suspending Replication Activity for a Master Group</a> for instructions.</p> </li> <li> <p>Remove all deferred transactions from each master site where the destination for the transaction is a removed master site. See <a href="administer011.htm#BABEFBAA">Removing Deferred Transactions</a> for instructions.</p> </li> <li> <p>Remove all deferred transactions from removed master sites, as soon as they become available.</p> </li> <li> <p>Re-execute or delete all error transactions at each remaining master site. See <a href="administer011.htm#BABEFBAA">Removing Deferred Transactions</a> for instructions.</p> </li> <li> <p>Ensure that no deferred or error transactions exist at each remaining master. If you cannot remove one or more deferred transactions from a remaining master, execute the <code>DBMS_DEFER_SYS.DELETE_TRAN</code> procedure at the master site using SQL*Plus.</p> </li> <li> <p>Ensure that all replicated data is consistent. Use the <code>DBMS_RECTIFIER_DIFF</code> package to determine and fix differences.</p> </li> <li> <p>Resuming replication activity for a master group. See <a href="multimaster020.htm#BGBDGFIB">Resuming Replication Activity for a Master Group</a> for instructions.</p> </li> </ol> <div class="helpinfonote"> <p><span class="bold">Note: </span>After dropping an unavailable master site from a master group, you should also remove the master group from the dropped site to finish the cleanup, as soon as the dropped site becomes available.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="multimaster011.htm#BGBBFBGJ">Managing Master Groups</a></p> <p><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></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="multimaster025.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster027.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