Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\configure001.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 Conflict Resolution Methods</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-23T10:13:6Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Conflict Resolution Methods" /> <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="configure.htm" title="Previous" type="text/html" /> <link rel="next" href="configure002.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="configure.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="configure002.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CACJABIJ" name="CACJABIJ"></a><a id="ADVRP288" name="ADVRP288"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>About Conflict Resolution Methods</h1> <p>Asynchronous multimaster and updatable materialized view replication environments must address the possibility of replication conflicts that may occur when, for example, two transactions originating from different sites update the same row at nearly the same time. When data conflicts occur, you need a mechanism to ensure that the conflict is resolved in accordance with your business rules and to ensure that the data converges correctly at all sites.</p> <p>In addition to logging any conflicts that may occur in your replicated environment, Advanced Replication offers a variety of built-in conflict resolution methods that enable you to define a conflict resolution system for your database that resolves conflicts in accordance with your business rules. If you have a unique situation that Oracle's built-in conflict resolution methods cannot resolve, you have the option of building and using your own conflict resolution methods.</p> <p>Conflict resolution operates at the column group level. Column groups provide the organization mechanism to group all columns that are involved in a conflict resolution method. If a conflict occurs in one of the columns of the group, the remainder of the group's columns may be used to resolve the conflict. For example, if a column group for a table contains a <code>MIN_PRICE</code>, <code>LIST_PRICE</code>, <code>COST_PRICE</code>, and <code>TIMESTAMP</code> field and a conflict arises for the <code>LIST_PRICE</code> field, the <code>TIMESTAMP</code> field may be used to resolve the conflict, assuming that a timestamp conflict resolution routine has been used.</p> <p>Three types of conflicts are possible: update, uniqueness, and delete. The following list summarizes each type of conflict; each conflict occurs when the conflicting actions occur within the same interval:</p> <ul> <li> <p><span class="bold">Update Conflict</span>: An update conflict occurs when the replication of an update to a row conflicts with another update to the same row. Update conflicts can happen when two transactions, originating from different sites, update the same row at nearly the same time.</p> </li> <li> <p><span class="bold">Uniqueness Conflict</span>: A uniqueness conflict occurs when the replication of a row attempts to violate entity integrity, such as a <code>PRIMARY KEY</code> or <code>UNIQUE</code> constraint. For example, consider what happens when two transactions originate from two different sites each inserting a row into a respective table replica with the same primary key value. In this case, replication of the transactions causes a uniqueness conflict.</p> </li> <li> <p><span class="bold">Delete Conflict</span>: A delete conflict occurs when two transactions originate from different sites, with one transaction deleting a row and another transaction updating or deleting the same row, because in this case the row does not exist to be either updated or deleted.</p> <p>See the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPLN','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication</span></a> for detailed information about these methods.</p> </li> </ul> <p>This topic comprises the following subtopics:</p> <ul> <li> <p><a href="configure002.htm#CACBEFGB">Timestamp</a></p> </li> <li> <p><a href="configure003.htm#CACJJEAB">Overwrite and Discard Methods</a></p> </li> <li> <p><a href="configure004.htm#CACEBGFF">Minimum and Maximum</a></p> </li> <li> <p><a href="configure005.htm#CACCGEAD">Priority Groups</a></p> </li> <li> <p><a href="configure006.htm#CACEJIAI">Site Priority</a></p> </li> <li> <p><a href="configure007.htm#CACJFIHE">Additive and Average</a></p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="getting_started002.htm#CHDFHHJC">Flowchart for Creating a Replication Environment</a></p> <p><a href="multimaster008.htm#BGBEGACJ">Flowchart for Creating a Master Group</a></p> <p><a href="configure008.htm#CACIECGJ">Before Configuring Conflict Resolution</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 © 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="configure.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="configure002.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