Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_repcont020.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>Configuring Oracle Streams Replication: Examples</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:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Configuring Oracle Streams Replication: Examples" /> <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_repcont019.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_repcont021.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_repcont019.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont021.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHFHFFJ" name="CIHFHFFJ"></a><a id="TDPII192" name="TDPII192"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Configuring Oracle Streams Replication: Examples</h1> <a name="BEGIN" id="BEGIN"></a> <p>This section uses examples to show you how to configure Oracle Streams replication environments. The examples configure the most common types of Oracle Streams replication environments.</p> <p>The following are descriptions of the examples:</p> <ul> <li> <p><a href="tdpii_repcont021.htm#CIHDBCGD">Tutorial: Configuring Two-Database Replication with Local Capture Processes</a></p> <p>This example configures an Oracle Streams replication environment that replicates data manipulation language (DML) changes to all of the tables in the <code>hr</code> schema at two databases. The configuration uses capture processes to capture the changes to the replicated database objects.</p> <p>The example shows you how to configure the environment for one-way replication or bi-directional replication. With one-way replication, only one database allows changes to the database objects. With bi-directional replication, both databases allow changes to the database objects.</p> <p>Use this configuration when you want to configure a relatively simple replication environment that only involves two databases. You might configure a one-way replication environment if you want to use a second database for reporting or data analysis. You might configure a two-way replication environment if the data must be read/write at both databases. For example, two-way replication can be used to improve scalability or increase the availability of the data.</p> <p>See <a href="tdpii_repcont013.htm#CIHGHCGI">"About Two-Database Replication Environments"</a> for more information about two-database replication environments.</p> </li> <li> <p><a href="tdpii_repcont022.htm#BABIJCDG">Tutorial: Configuring Two-Database Replication with a Downstream Capture Process</a></p> <p>This example configures an Oracle Streams replication environment that replicates data manipulation language (DML) changes to all of the tables in the <code>hr</code> schema at two databases. The example shows you how to configure the environment for one-way replication, where changes to the replicated database objects are only allowed at one source database. The configuration uses a downstream capture process at a destination database to capture the changes that were made to these database objects at the source database. The database objects are read-only at the destination database.</p> <p>Use this configuration when you want to offload reporting or data analysis from a primary database to another database. In this example, the capture process runs on the second database to reduce the load on the primary database.</p> <p>See <a href="tdpii_repcont013.htm#CIHGHCGI">"About Two-Database Replication Environments"</a> for more information about two-database replication environments.</p> </li> <li> <p><a href="tdpii_repcont023.htm#BABBIBCD">Tutorial: Configuring Hub-and-Spoke Replication with Local Capture Processes</a></p> <p>This example configures an Oracle Streams replication environment that replicates data manipulation language (DML) changes to all of the tables in the <code>hr</code> schema at three databases. This example configures a hub-and-spoke replication environment with one hub and two spokes. A hub-and-spoke replication environment is one in which a central database, or hub, communicates with secondary databases, or spokes. In this example, the spoke databases allow changes to the replicated database objects. The configuration uses capture processes to capture the changes to the replicated database objects.</p> <p>Use this configuration when you have a central database that must replicate data with several secondary databases. For example, a business with a central database at headquarters and several secondary databases at sales offices might choose this configuration.</p> <p>See <a href="tdpii_repcont014.htm#CIHJEIDB">"About Hub-And-Spoke Replication Environments"</a> for more information about hub-and-spoke replication environments.</p> </li> <li> <p><a href="tdpii_repcont024.htm#BABDEBBA">Tutorial: Configuring Two-Database Replication with Synchronous Captures</a></p> <p>This example configures an Oracle Streams replication environment that replicates data manipulation language (DML) changes to the <code>employees</code> and <code>departments</code> tables in the <code>hr</code> schema at two databases. This example configures bi-directional replication between the two databases. So, changes to the databases objects are allowed at each database. The configuration uses synchronous captures to capture the changes to the replicated database objects.</p> <p>Use this configuration when you want to configure a relatively simple replication environment that only involves two databases and a small number of tables. You might also choose to use synchronous captures if you have Oracle Database 11<span class="italic">g</span> Standard Edition. To use capture processes, you must have Oracle Database 11<span class="italic">g</span> Enterprise Edition.</p> <p>See <a href="tdpii_repcont013.htm#CIHGHCGI">"About Two-Database Replication Environments"</a> for more information about two-database replication environments.</p> </li> </ul> <p>This section also includes an example that configures conflict resolution for a table. See <a href="tdpii_repcont025.htm#CIHIACBB">"Tutorial: Configuring Latest Time Conflict Resolution for a Table"</a>. Use conflict resolution in a replication environment that allows more than one database to perform DML changes on replicated tables. This example configures latest time conflict resolution. Therefore, when a conflict occurs for a row change to a table, the most recent change is retained, and the older change is discarded. See <a href="tdpii_repcont010.htm#BABGAACC">"About Conflicts and Conflict Resolution"</a> for more information about conflict resolution.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>Another common Oracle Streams replication environment is the n-way environment. See <a href="tdpii_repcont015.htm#CIHEBHDG">"About N-Way Replication Environments"</a>.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont012.htm#CIHGGCCB">About the Common Types of Oracle Streams Replication Environments</a></p> </div> <!-- 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_repcont019.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont021.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --></div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de