Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_repextend001.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>About Extending an Oracle Streams Replication Environment</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T17:1:2Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Extending an Oracle Streams Replication Environment" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10703-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="tdpii_repextend.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_repextend002.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> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <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="tdpii_repextend.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repextend002.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BEBBEJHG" name="BEBBEJHG"></a><a id="TDPII172" name="TDPII172"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>About Extending an Oracle Streams Replication Environment<a id="sthref368" name="sthref368"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>Sometimes it is necessary to extend an Oracle Streams replication environment when the needs of your organization change. You can extend an Oracle Streams replication environment by adding database objects or databases.</p> <p>There are two ways to extend an Oracle Streams replication environment:</p> <ul> <li> <p><a href="#BEBDABHB">Use the Setup Streams Replication Wizard or a Single Configuration Procedure</a></p> </li> <li> <p><a href="#BEBBBFEE">Add the Oracle Streams Components Individually in Multiple Steps</a></p> </li> </ul> <a id="BEBDABHB" name="BEBDABHB"></a><a id="TDPII275" name="TDPII275"></a> <p class="subhead2">Use the Setup Streams Replication Wizard or a Single Configuration Procedure<a id="sthref369" name="sthref369"></a><a id="sthref370" name="sthref370"></a><a id="sthref371" name="sthref371"></a><a id="sthref372" name="sthref372"></a><a id="sthref373" name="sthref373"></a></p> <p>You can extend an Oracle Streams Replication environment using one of the following methods if the environment satisfies certain conditions:</p> <ul> <li> <p>Run the Setup Streams Replication Wizard in Oracle Enterprise Manager</p> </li> <li> <p>Run one of the following procedures in the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS305','newWindow').focus()"><code>DBMS_STREAMS_ADM</code></a> package:</p> <ul> <li> <p>The <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS825','newWindow').focus()"><code>MAINTAIN_GLOBAL</code> procedure</a> can add a new database to an environment that replicates changes to all of the database objects in the databases.</p> </li> <li> <p>The <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS826','newWindow').focus()"><code>MAINTAIN_SCHEMAS</code> procedure</a> can add one or more new schemas to the existing databases in the replication environment, or it can add a new database that replicates schemas that are currently being replicated.</p> </li> <li> <p>The <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS863','newWindow').focus()"><code>MAINTAIN_SIMPLE_TTS</code> procedure</a> can add a new simple tablespace to an existing replication environment, or it can add a new database that replicates a simple tablespace that is currently being replicated.</p> </li> <li> <p>The <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS827','newWindow').focus()"><code>MAINTAIN_TABLES</code> procedure</a> can add one or more new tables to the existing databases in the replication environment, or it can add a new database that replicates tables that are currently being replicated.</p> </li> <li> <p>The <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS864','newWindow').focus()"><code>MAINTAIN_TTS</code> procedure</a> can add a new set of tablespaces to an existing replication environment, or it can add a new database that replicates a set of tablespaces that are currently being replicated.</p> </li> </ul> </li> </ul> <p>To use the wizard or one of the procedures to extend an Oracle Streams replication environment, the environment must satisfy the following conditions:</p> <ul> <li> <p>It must be a two-database or hub-and-spoke replication environment that was configured by the Setup Streams Replication Wizard or one of the configuration procedures in the <code>DBMS_STREAMS_ADM</code> package. See <a href="tdpii_repcont012.htm#CIHGGCCB">"About the Common Types of Oracle Streams Replication Environments"</a> for information about these types of replication environments.</p> </li> <li> <p>It cannot use a synchronous capture at any database in the Oracle Streams replication environment. See <a href="tdpii_repcont004.htm#BABJJJDE">"About Change Capture with a Synchronous Capture"</a> for more information about synchronous capture.</p> </li> <li> <p>If you are adding a database to the environment, then each database that captures changes must use a local capture process. No database can use a downstream capture process. If you are adding one or more database objects to the environment, then the databases can use either local or downstream capture processes. See <a href="tdpii_repcont003.htm#BABBFECB">"About Change Capture with a Capture Process"</a> for more information about downstream capture.</p> </li> <li> <p>If you are adding database objects to the replication environment, then the database objects must exist at the database where you run the wizard or at the database specified in the <code>source_database</code> parameter of a configuration procedure, but these database object must not exist at any of the other databases.</p> </li> <li> <p>If you are adding a database to the replication environment, then the new database must not contain any of the database objects that are replicated in the current environment.</p> </li> </ul> <p>If your replication environment meets these conditions, then you can use the Setup Streams Replication Wizard or a single procedure to extend the environment. For instructions about adding to a replication environment using the wizard, see the following topics:</p> <ul> <li> <p><a href="tdpii_repextend002.htm#CIHCDDIJ">Tutorial: Adding Database Objects to a Replication Environment</a></p> </li> <li> <p><a href="tdpii_repextend003.htm#CIHIDHEH">Tutorial: Adding Databases to a Replication Environment</a></p> </li> </ul> <p>For instructions about adding to a replication environment using a single procedure, see <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP613','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a>.</p> <a id="BEBBBFEE" name="BEBBBFEE"></a><a id="TDPII276" name="TDPII276"></a> <p class="subhead2">Add the Oracle Streams Components Individually in Multiple Steps</p> <p>If you cannot extend the Oracle Streams replication environment by using the Setup Streams Replication Wizard or a configuration procedure in the <code>DBMS_STREAMS_ADM</code> package, then you must complete the configuration steps manually. These steps include adding the necessary rules and Oracle Streams components to the environment, as well as other configuration steps.</p> <p>If you must extend the Oracle Streams replication environment manually, then see the instructions in <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP058','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a>.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont.htm#BABEFAFI">Replicating Data Using Oracle Streams</a></p> <p><a href="tdpii_repcont014.htm#CIHJEIDB">About Hub-And-Spoke Replication Environments</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS878','newWindow').focus()"><span class="italic">Oracle Database PL/SQL Packages and Types Reference</span></a> for information about the procedures in the <code>DBMS_STREAMS_ADM</code> chapter</p> </div> </div> <!-- class="sect1" --> <!-- 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 © 2007, 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="tdpii_repextend.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repextend002.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