Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_repcont001.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 Oracle Streams Replication</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="About Oracle Streams Replication" /> <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_repcont.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_repcont002.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_repcont.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont002.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABEHDDF" name="BABEHDDF"></a><a id="TDPII066" name="TDPII066"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>About Oracle Streams Replication<a id="sthref91" name="sthref91"></a><a id="sthref92" name="sthref92"></a><a id="sthref93" name="sthref93"></a><a id="sthref94" name="sthref94"></a><a id="sthref95" name="sthref95"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p><span class="bold">Replication</span> is the process of sharing database objects and data at multiple databases. To maintain the database objects and data at multiple databases, a change to one of these database objects at a database is shared with the other databases. In this way, the database objects and data are kept synchronized at all of the databases in the replication environment.</p> <p>Some replication environments must continually replicate the changes made to shared database objects. <span class="bold">Oracle Streams</span> is the Oracle Database feature for continuous replication. Typically, in such environments, the databases that contain the shared database objects are connected to the network nearly all the time and continually push database changes over these network connections.</p> <p>When a change is made to one shared database object, Oracle Streams performs the following actions to ensure that the same change is made to the corresponding shared database object at each of the other databases:</p> <ol> <li> <p>Oracle Streams automatically captures the change and stages it in a queue.</p> </li> <li> <p>Oracle Streams automatically pushes the change to a queue in each of the other databases that contain the shared database object.</p> </li> <li> <p>Oracle Streams automatically consumes the change at each of the other databases. During consumption, Oracle Streams dequeues the change and applies the change to the shared database object.</p> </li> </ol> <p><a href="#BABBCJFA">Figure: Oracle Streams Information Flow</a> shows the Oracle Streams information flow:</p> <div class="figure"><a id="BABBCJFA" name="BABBCJFA"></a><a id="TDPII218" name="TDPII218"></a> <p class="titleinfigure">Oracle Streams Information Flow</p> <img src="img/tdpii022.gif" alt="Description of this figure follows" title="Description of this figure follows" longdesc="img_text/tdpii022.htm" /><br /> <a id="sthref96" name="sthref96" href="img_text/tdpii022.htm">Description of "Oracle Streams Information Flow"</a><br /> <br /></div> <!-- class="figure" --> <p>You can use Oracle Streams replication to share data at multiple databases and efficiently keep the data current at these databases. For example, a company with several call centers throughout the world might want to store customer information in a local database at each call center. In such an environment, continuous replication with Oracle Streams can ensure that a change made to customer data at one location is pushed to all of the other locations as soon as possible.</p> <p><a id="sthref97" name="sthref97"></a><a id="sthref98" name="sthref98"></a><a id="sthref99" name="sthref99"></a>When you use Oracle Streams to capture changes to database objects, the changes are formatted into <span class="bold">logical change records (LCRs)</span>. An LCR is a message with a specific format that describes a database change. If the change was a data manipulation language (DML) operation, then a <span class="bold">row LCR</span> encapsulates each row change resulting from the DML operation. One DML operation might result in multiple row changes, and so one DML operation might result in multiple row LCRs. If the change was a data definition language (DDL) operation, then a single <span class="bold">DDL LCR</span> encapsulates the DDL change.</p> <p>The following topics describe Oracle Streams replication in more detail:</p> <ul> <li> <p><a href="tdpii_repcont002.htm#BABJGJEH">About Change Capture</a></p> </li> <li> <p><a href="tdpii_repcont005.htm#BABFIHAI">About Change Propagation Between Databases</a></p> </li> <li> <p><a href="tdpii_repcont006.htm#BABBAJFE">About Change Apply</a></p> </li> <li> <p><a href="tdpii_repcont007.htm#BABHHDGG">About Rules for Controlling the Behavior of Capture, Propagation, and Apply</a></p> </li> <li> <p><a href="tdpii_repcont008.htm#BABECEFJ">About Rule-Based Transformations for Nonidentical Copies</a></p> </li> <li> <p><a href="tdpii_repcont009.htm#CIHJCGBA">About Supplemental Logging</a></p> </li> <li> <p><a href="tdpii_repcont010.htm#BABGAACC">About Conflicts and Conflict Resolution</a></p> </li> <li> <p><a href="tdpii_repcont011.htm#BABICHGF">About Tags for Avoiding Change Cycling</a></p> </li> <li> <p><a href="tdpii_repcont012.htm#CIHGGCCB">About the Common Types of Oracle Streams Replication Environments</a></p> </li> <li> <p><a href="tdpii_repcont016.htm#CIHGFFFF">About Key Oracle Streams Supplied PL/SQL Packages and Data Dictionary Views</a></p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_intro2ii004.htm#CFHJAAEA">When to Replicate Data with Oracle Streams</a></p> <p><a href="tdpii_repcont019.htm#BABDHIIH">Preparing for Oracle Streams Replication</a></p> <p><a href="tdpii_repcont022.htm#BABIJCDG">Tutorial: Configuring Two-Database Replication with a Downstream Capture Process</a></p> <p><a href="tdpii_repcont023.htm#BABBIBCD">Tutorial: Configuring Hub-and-Spoke Replication with Local Capture Processes</a></p> <p><a href="tdpii_repcont024.htm#BABDEBBA">Tutorial: Configuring Two-Database Replication with Synchronous Captures</a></p> <p><a href="tdpii_adcont.htm#CHDHCDDJ">Administering an Oracle Streams Replication Environment</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_repcont.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont002.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