ALTER_CATCHUP_PARAMETERS Procedure</ti tle> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <meta http-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name="ro bots" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Database Advanced Replication Mana gement API Reference 10g Release 1 (10.1)"> <meta name="partno" content="B10733-01"> <link rel="Start" href="../../index.htm" title=" Home" type="text/html"> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html"> <link rel="Style sheet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" href="toc.htm" title="Contents" type= "text/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Prev" href="rarrcat7.htm" title="Previous" type="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrcat9.htm" title="Next" type="text/html"> <link rel="alternate" href="../b10733.pdf" title="PDF version" type="application/pdf"> </head> <body> <div class="h eader"> <p><a name="top" id="top" href="#BEGIN">Skip Headers</a></p> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><font color="#330099" face="Helvetica, Arial, sans-serif"><strong>Oracle® Database Advanced Re plication Management API Reference<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B10733-01</font></td> <td valign="bottom " align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../i ndex.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</font></a></ td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to Book List" border="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommon/ gifs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign=" top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0"><br> <font size="-2">Index</font></a ></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs/mix.gif" alt="Go to Master Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/html /feedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></ a></td></tr></table></td></tr></table> <hr> <table summary="layout table" cellspacing="0" cellpadding="0" width="100%"> <tr> <td alig n="left" valign="top"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center " valign="top"><a href="rarrcat7.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size=" -2">Previous</font></a></td> <td align="center" valign="top"><a href="rarrcatp.htm"><img src="../../dcommon/gifs/uarrow.gif" alt="Go to current chapter" border="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a href="rarrcat9.htm"><img sr c="../../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td al ign="right" valign="top"><a href="../b10733.pdf"><font size="-2">View PDF</font></a></td></tr></table> <a name="BEGIN"></a></div> <di v class="IND"> <a name="102241"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099">AL TER_CATCHUP_PARAMETERS Procedure</font></h2> <a name="102389"></a> <p class="BP">This procedure alters the values for the following parameters stored in the <code>DBA_REPEXTENSIONS</code> data dictionary view:</p> <ul class="LB1"> <li class="LB1" type="disc"><a nam e="102398"></a><code>percentage_for_catchup_mdef</code></li> <li class="LB1" type="disc"><a name="102399"></a><code>cycle_seconds_mde f</code></li> <li class="LB1" type="disc"><a name="102406"></a><code>percentage_for_catchup_new</code></li> <li class="LB1" type="dis c"><a name="102407"></a><code>cycle_seconds_new</code></li></ul> <a name="102410"></a> <p class="BP">These parameters were originall y set by the <code>ADD_NEW_MASTERS</code> procedure. The new values you specify for these parameters are used during the remaining st eps in the process of adding new master sites to a master group. These changes are only to the site at which it is executed. Therefor e, it must be executed at each master site, including the master definition site, if you want to alter parameters at all sites.</p> < a name="103869"></a> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" s ummary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="NoteAlso"> <td class="No teAlso"><a name="103861"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></font> <a name="103868"> </a> <ul class="NL"> <li class="NL" type="disc"><a name="104010"></a><a href="rarrcat4.htm#101338">"ADD_NEW_MASTERS Procedure"</a><a href="rarrcat4.htm#101338"></a></li> <li class="NL" type="disc"><a name="103999"></a><a href="rarmanma.htm#33125">"Adding New Master Sites"</a><a href="rarmanma.htm#33125"></a> for more information about adding master sites to a master group</li></ul></td></tr></ta ble></div> <a name="102256"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Syntax</font></h3> <pre c lass="CE"><a name="102448"></a>DBMS_REPCAT.ALTER_CATCHUP_PARAMETERS ( <a name="102449"></a> extension_id IN RAW , <a name="102453"></a> percentage_for_catchup_mdef IN BINARY_INTEGER := NULL, <a name="102450"></a> cycle_seconds_mdef IN BINARY_INTEGER := NULL, <a name="102267"></a> percentage_for_catchup_new IN BINARY_INTEGER := NULL, <a name="102268"></a> cycle_seconds_new IN BINARY_INTEGER := NULL); </pre> <a name="102722"></a> <h3 class="CMS" ><font face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font></h3> <h5 class="TT"><a name="102574"></a><a name="102518 "></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-15 ALTER_CATCHUP_PARAMETERS Procedure Parameters </em></f ont></strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing ="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name="102522"></a > <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font></th> <th class="Formal" align="left" valign="bottom" sc ope="col"><a name="102524"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbod y> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="102545"></a>extension_id </pre> </td> <td class="Formal"><a name="102547"></a> <p class="TB">The identifier for the current pending request to add master database without quiesce. You can find the <code>extension_id</code> by querying the <code>DBA_REPSITES_NEW</code> and <code>DBA_REPEXTENSIONS</code> data dictionary views.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="1049 83"></a>percentage_for_catchup_mdef </pre> </td> <td class="Formal"><a name="104986"></a> <p class="TB">The percentage of propagation resources that should be used for catching up propagation to the master definition site. Must be a multiple of 10 and must be betwee n 0 and 100.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="104979"></a>cy cle_seconds_mdef </pre> </td> <td class="Formal"><a name="104981"></a> <p class="TB">This parameter is meaningful when <code>percenta ge_for_catchup_mdef</code> is both meaningful and set to a value between 10 and 90, inclusive. In this case, propagation to the maste rdef alternates between replication groups that are not being extended and replication groups that are being extended, with one push to each during each cycle. This parameter indicates the length of the cycle in seconds.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="104974"></a>percentage_for_catchup_new </pre> </td> <td class="Formal">< a name="104977"></a> <p class="TB">The percentage of propagation resources that should be used for catching up propagation to new mas ter sites. Must be a multiple of 10 and must be between 0 and 100.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td cl ass="Formal"> <pre class="CEW"><a name="104970"></a>cycle_seconds_new </pre> </td> <td class="Formal"><a name="104972"></a> <p class= "TB">This parameter is meaningful when <code>percentage_for_catchup_new</code> is both meaningful and set to a value between 10 and 9 0, inclusive. In this case, propagation to a new master alternates between replication groups that are not being extended and replica tion groups that are being extended, with one push to each during each cycle. This parameter indicates the length of the cycle in sec onds.</p></td></tr></tbody></table> <a name="102335"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099"> Exceptions</font></h3> <h5 class="TT"><a name="102369"></a><a name="102338"></a> <strong><font face="Arial, Helvetica, sans-serif"><e m>Table 18-16 ALTER_CATCHUP_PARAMETERS Procedure Exceptions </em></font></strong></h5> <table summary="" class="Formal" border= "1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th cl ass="Formal" align="left" valign="bottom" scope="col"><a name="102342"></a> <font face="Arial, Helvetica, sans-serif"><strong>Excepti on</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="102344"></a> <font face="Arial, Helvetic a, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" align="left" valign="top"> <td class= "Formal"> <pre class="CEW"><a name="102350"></a>typefailure </pre> </td> <td class="Formal"><a name="102352"></a> <p class="TB">The p arameter value specified for one of the parameters is not appropriate.</p></td></tr> <tr class="Formal" align="left" valign="top"> <t d class="Formal"> <pre class="CEW"><a name="102366"></a>dbnotcompatible </pre> </td> <td class="Formal"><a name="102368"></a> <p clas s="TB">Feature is incompatible with database version. All databases must be at 9.0.1 or higher compatibility level.</p></td></tr></tb ody></table></div> <div class="footer"> <hr> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td style="width: 3 3%;" align="left"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" va lign="top"><a href="rarrcat7.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2"> Previous</font></a></td> <td align="center" valign="top"><a href="rarrcatp.htm"><img src="../../dcommon/gifs/uarrow.gif" alt="Go to c urrent chapter" border="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a href="rarrcat9.htm"><img src=". ./../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td style= "width: 34%;" align="center"><img src="../../dcommon/gifs/oracle.gif" alt="Oracle"><br> <a href="../../dcommon/html/cpyr.htm"><font s ize="-2">Copyright © 1996, 2003 Oracle Corporation</font></a><br> <font size="-2">All Rights Reserved.</font></td> <td style="wi dth: 33%;" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href ="../../index.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</fo nt></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to B ook List" border="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../.. /dcommon/gifs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0"><br> <font size="-2">Index< /font></a></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs/mix.gif" alt="Go to Master Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dco mmon/html/feedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback </font></a></td></tr></table></td></tr></table></div> </body> </html>