Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adcont037.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>Retrying or Deleting Apply Error Transactions</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="Retrying or Deleting Apply Error Transactions" /> <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_adcont036.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adcont038.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_adcont036.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont038.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDBEFAF" name="CHDBEFAF"></a><a id="TDPII176" name="TDPII176"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Retrying or Deleting Apply Error Transactions<a id="sthref361" name="sthref361"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p><a href="tdpii_adcont036.htm#CHDEBFIJ">"Correcting Apply Errors in Database Objects"</a> describes correcting the problem that caused one or more error transactions. After you correct the problem, you can retry the error transactions or delete them:</p> <ul> <li> <p>Retry the transactions if the changes in the transaction should be made to the destination table. Retry them only if you have not already modified the data in the table to make these changes.</p> </li> <li> <p>Delete the transactions if you made all of the changes in the transactions to the destination table, or if the changes should not be made to the table.</p> </li> </ul> <p class="orderedlisttitle">To retry or delete apply error transactions: </p> <ol> <li> <p>In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.</p> </li> <li> <p>Go to the Database Home page.</p> </li> <li> <p>Click <span class="bold">Data Movement</span> to open the Data Movement subpage.</p> </li> <li> <p>Click <span class="bold">Manage Replication</span> in the Streams section.</p> <p>The Streams page appears, showing the Overview subpage.</p> </li> <li> <p>Click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('STREAMS_APPLY');"><span class="bold">Streams</span></a> to open the Streams subpage.</p> <p>An apply error might cause an apply process to abort. When an apply process aborts, the status of the apply process is <code>ABORTED</code>.</p> </li> <li> <p>Select the apply process with error transactions in the list of components. If necessary, use the search tool to find the apply process, and then select it.</p> </li> <li> <p>Select <span class="bold">View Errors</span> in Action.</p> </li> <li> <p>Click <span class="bold">Go</span> to open the Apply Errors page.</p> <p>You can view detailed information about an error by clicking the icon in the View Error LCRs field for the error transaction. The detailed information appears on the View Error LCRs page and includes each change in the transaction.</p> <p>To drill down further, select a row change and click <span class="bold">Compare Values</span>. The Compare Values page appears and compares the row change with the data in the table to which the change should be applied.</p> </li> <li> <p>If you drilled down to more information about an error, then go back to the Apply Errors page by clicking the Apply Errors link.</p> </li> <li> <p>On the Apply Errors page, complete one of the following actions:</p> <ul> <li> <p>To retry all error transactions, click <span class="bold">Retry all Errors</span>.</p> </li> <li> <p>To delete all error transactions, click <span class="bold">Delete All</span>.</p> </li> <li> <p>To retry a specific error transaction, select the error transaction and click <span class="bold">Retry Error</span>.</p> </li> <li> <p>To delete a specific error transaction, select the error transaction and click <span class="bold">Delete</span>.</p> </li> </ul> </li> </ol> <div class="helpinfonote"> <p><span class="bold">Note: </span>You can also use the following procedures in the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS300','newWindow').focus()"><code>DBMS_APPLY_ADM</code></a> package to delete or reexecute error transactions: <ul> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS510','newWindow').focus()"><code>DELETE_ALL_ERRORS</code></a></p> </li> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS534','newWindow').focus()"><code>DELETE_ERROR</code></a></p> </li> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS536','newWindow').focus()"><code>EXECUTE_ALL_ERRORS</code></a></p> </li> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=ARPLS326','newWindow').focus()"><code>EXECUTE_ERROR</code></a></p> </li> </ul> </p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont006.htm#BABBAJFE">About Change Apply</a></p> <p><a href="tdpii_adcont006.htm#CHDIJJGJ">Managing Apply Processes</a></p> <p><a href="tdpii_adcont021.htm#CHDBJIHG">Monitoring Apply Processes</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STRMS112','newWindow').focus()"><span class="italic">Oracle Streams Concepts and Administration</span></a></p> </div> </div> <!-- class="sect3" --> <!-- 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_adcont036.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont038.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