Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_repcont019.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>Preparing for 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="Preparing for 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_repcont018.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_repcont020.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_repcont018.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont020.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABDHIIH" name="BABDHIIH"></a><a id="TDPII076" name="TDPII076"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Preparing for Oracle Streams Replication<a id="sthref205" name="sthref205"></a><a id="sthref206" name="sthref206"></a><a id="sthref207" name="sthref207"></a><a id="sthref208" name="sthref208"></a><a id="sthref209" name="sthref209"></a><a id="sthref210" name="sthref210"></a><a id="sthref211" name="sthref211"></a><a id="sthref212" name="sthref212"></a><a id="sthref213" name="sthref213"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>Before configuring Oracle Streams replication, prepare the databases that will participate in the replication environment.</p> <p class="orderedlisttitle">To prepare for Oracle Streams replication: </p> <ol> <li> <p>Set initialization parameters properly before you configure a replication environment with Oracle Streams:</p> <ul> <li> <p><span class="bold">Global Names:</span> Set the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10065','newWindow').focus()"><code>GLOBAL_NAMES</code></a> initialization parameter to <code>TRUE</code> at each database that will participate in the Oracle Streams replication environment. See <a href="tdpii_common_ii001.htm#BGBEEDCD">"Setting the GLOBAL_NAMES Initialization Parameter to TRUE"</a>.</p> </li> <li> <p><span class="bold">Compatibility:</span> To use the latest features of Oracle Streams, it is best to set the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10019','newWindow').focus()"><code>COMPATIBLE</code></a> initialization parameter as high as you can. If possible, then set this parameter to <code>11.2.0</code> or higher.</p> </li> <li> <p><span class="bold">System Global Area (SGA) and the Oracle Streams pool:</span> Ensure that the Oracle Streams pool is large enough to accommodate the Oracle Streams components created for the replication environment. The Oracle Streams pool is part of the System Global Area (SGA). You can manage the Oracle Streams pool by setting the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10285','newWindow').focus()"><code>MEMORY_TARGET</code></a> initialization parameter (Automatic Memory Management), the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10256','newWindow').focus()"><code>SGA_TARGET</code></a> initialization parameter (Automatic Shared Memory Management), or the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10243','newWindow').focus()"><code>STREAMS_POOL_SIZE</code></a> initialization parameter. See <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP202','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a> for more information about the Oracle Streams pool.</p> <p>The memory requirements for Oracle Streams components are:</p> <ul> <li> <p>Each queue requires at least 10 MB of memory.</p> </li> <li> <p>Each capture process parallelism requires at least 10 MB of memory. The <code>parallelism</code> capture process parameter controls the number of processes used by the capture process to capture changes. You might be able to improve capture process performance by adjusting capture process parallelism.</p> </li> <li> <p>Each propagation requires at least 1 MB of memory.</p> </li> <li> <p>Each apply process parallelism requires at least 1 MB of memory. The <code>parallelism</code> apply process parameter controls the number of processes used by the apply process to apply changes. You might be able to improve apply process performance by adjusting apply process parallelism.</p> </li> </ul> </li> <li> <p><span class="bold">Processes and Sessions:</span> Oracle Streams capture processes, propagations, and apply processes use processes that run in the background. You might need to increase the value of the <code>PROCESSES</code> and <code>SESSIONS</code> initialization parameters to accommodate these processes.</p> </li> </ul> </li> <li> <p><a id="sthref215" name="sthref215"></a><a id="sthref216" name="sthref216"></a>Review the best practices for Oracle Streams replication environments and follow the best practices when you configure the environment. See <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP150','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a> for information about best practices.</p> <p>Following the best practices ensures that your environment performs optimally and avoids problems. The Setup Streams Replication Wizard in Oracle Enterprise Manager and the configuration procedures in the <code>DBMS_STREAMS_ADM</code> package follow the best practices automatically. However, if you plan to configure an Oracle Streams replication environment without using the wizard or a configuration procedure, then learn about the best practices and follow them whenever possible.</p> <p>The following are some of the important best practices to follow during Oracle Streams configuration:</p> <ul> <li> <p>Configure a separate tablespace for the Oracle Streams administrator. The instructions in <a href="tdpii_common_ii002.htm#BGBHDJHF">"Tutorial: Configuring an Oracle Streams Administrator"</a> follow this best practice.</p> </li> <li> <p>Use separate queues for capture processes, synchronous captures, and apply processes. For the best performance, these components typically should not share a queue.</p> </li> <li> <p>Use queue-to-queue propagations.</p> </li> </ul> <p>After the Oracle Streams environment is configured, the following are some of the important best practices to follow for operation of the Oracle Streams environment:</p> <ul> <li> <p>Monitor performance and make adjustments when necessary.</p> </li> <li> <p>Monitor queues for size.</p> </li> <li> <p>Follow the Oracle Streams best practices for backups.</p> </li> <li> <p>Check the alert log for Oracle Streams information.</p> </li> <li> <p>Set capture process parallelism for best performance.</p> </li> <li> <p>Set apply process parallelism for best performance.</p> </li> <li> <p>Check for apply errors and manage them if they occur.</p> </li> </ul> </li> </ol> <p>See <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP150','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a> for detailed information about these best practices, and for information about other Oracle Streams best practices.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont001.htm#BABEHDDF">About Oracle Streams Replication</a></p> <p><a href="tdpii_adcont.htm#CHDHCDDJ">Administering an Oracle Streams Replication Environment</a></p> <p><a href="topicid:ADMQS053">Viewing and Modifying Initialization Parameters</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP201','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a> for information about initialization parameters that are important in an Oracle Streams environment</p> </div> </div> <!-- class="sect1" --> <!-- 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_repcont018.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont020.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