Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_repcont011.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 Tags for Avoiding Change Cycling</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 Tags for Avoiding Change Cycling" /> <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_repcont010.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_repcont012.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_repcont010.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont012.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABICHGF" name="BABICHGF"></a><a id="TDPII075" name="TDPII075"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>About Tags for Avoiding Change Cycling<a id="sthref154" name="sthref154"></a><a id="sthref155" name="sthref155"></a><a id="sthref156" name="sthref156"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p><span class="bold">Change cycling</span> means sending a change back to the database where it originated. Typically, change cycling should be avoided because it can result in each database change going through endless loops to the database where it originated. Such loops can result in unintended data in the database and tax the networking and computer resources of an environment. By default, Oracle Streams is designed to avoid change cycling.</p> <p>A <span class="bold">tag</span> is additional information in a change record. Each redo entry that records a database change and each logical change record (LCR) that encapsulates a database change includes a tag. The data type of the tag is <code>RAW</code>.</p> <p>By default, change records have the following tag values:</p> <ul> <li> <p>When a user or application generates database changes, the value of the tag is <code>NULL</code> for each change. This default can be changed for a particular database session.</p> </li> <li> <p>When an apply process generates database changes by applying them to database objects, the tag value for each change is the hexadecimal equivalent of <code>'00'</code> (double zero). This default can be changed for a particular apply process.</p> </li> </ul> <p>The tag value in an LCR depends on how the LCR was captured:</p> <ul> <li> <p>An LCR captured by a capture process has the tag value of the redo record that was captured.</p> </li> <li> <p>An LCR captured by a synchronous capture has the tag value of the database session that made the change.</p> </li> </ul> <p>Rules for Oracle Streams clients can include conditions for tag values. For example, the rules for a capture process can determine whether a change in the redo log is captured based on the tag value of the redo record. In an Oracle Streams replication environment, Oracle Streams clients use tags and rules to avoid change cycling.</p> <p>The following topics discuss how change cycling is avoided in a particular type of replication environment:</p> <ul> <li> <p><a href="tdpii_repcont021.htm#CIHDBCGD">Tutorial: Configuring Two-Database Replication with Local Capture Processes</a></p> </li> <li> <p><a href="tdpii_repcont023.htm#BABBIBCD">Tutorial: Configuring Hub-and-Spoke Replication with Local Capture Processes</a></p> </li> <li> <p><a href="tdpii_repcont024.htm#BABDEBBA">Tutorial: Configuring Two-Database Replication with Synchronous Captures</a></p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span><ul> <li> <p>Change cycling is not possible in a replication environment when changes to only one database are captured.</p> </li> <li> <p>You can also use tags to avoid replicating the changes made by a particular session. Use the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS504','newWindow').focus()"><code>DBMS_STREAMS.SET_TAG</code></a> procedure to set the tag for a session. See <a href="tdpii_adcont036.htm#CHDEBFIJ">"Correcting Apply Errors in Database Objects"</a> for an example.</p> </li> </ul> </p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_adcont035.htm#CHDJBAJD">Managing Apply Errors</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP008','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a> for detailed information about tags</p> <p><a href="tdpii_repcont001.htm#BABEHDDF">About Oracle Streams Replication</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 © 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_repcont010.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont012.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