Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdprc\softpatch2013.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>Minimum Downtime Patching</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1 Build 135" /> <meta name="date" content="2009-06-04T14:31:51Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Minimum Downtime Patching" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10743-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="softpatch2012.htm" title="Previous" type="text/html" /> <link rel="next" href="tdprc_troubleshoot_patching.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="softpatch2012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdprc_troubleshoot_patching.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDDDIFE" name="CHDDDIFE"></a><a id="TDPRC433" name="TDPRC433"></a></p> <div class="sect2"> <h1>Minimum Downtime Patching</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref408" name="sthref408"></a><a id="sthref409" name="sthref409"></a>In minimum downtime patching, one set of nodes is shut down and the patch is applied to those nodes. After the first set of nodes has been patched, the second set of nodes is shut down. The first set of nodes is then restarted and the patch is applied to the second set of nodes. After the patch has been applied to the second set of nodes, those nodes are restarted. This method leads to less downtime for Oracle RAC, compared to having all the nodes shut down at the same time.</p> <p>When you use the minimum downtime patching method, the following actions occur:</p> <ul> <li> <p>The local node is always patched first.</p> </li> <li> <p>The local node is used as a base to patch the other nodes.</p> </li> <li> <p>The user is prompted for the set of nodes to patch first from the remaining nodes.</p> </li> <li> <p>For each node in this first set, the user is asked to stop the instance and then the patch is propagated to that node before continuing to the next node. When the initial set of nodes has been patched, the user is asked to shut down the remaining nodes.</p> </li> <li> <p>After the local node is patched, the patch is propagated to the last set of nodes and the inventory is updated. The last instances are stopped on the remote nodes. You can then start up the patched nodes (the first set of nodes) before patching the remaining nodes.</p> </li> </ul> <a id="TDPRC434" name="TDPRC434"></a> <p class="subhead2">To apply a patch to your cluster database using the minimum downtime method:</p> <ol> <li> <p>Change to the directory where the unzipped patch is staged on disk, for example:</p> <pre xml:space="preserve" class="oac_no_warn"> $ cd <span class="italic">Oracle_home</span>/EMStagedPatches/4519934/4519934 </pre></li> <li> <p>Stop all user applications that use the Oracle RAC home directory for the group of nodes being patched. For example, to stop Enterprise Manager Database Control on the local node, use the following command, where <code><span class="italic">Oracle_home</span></code> is the home directory for your Oracle RAC installation:</p> <pre xml:space="preserve" class="oac_no_warn"> $ <span class="italic">Oracle_home</span>/bin/emctl stop dbconsole </pre></li> <li> <p>Shut down all Oracle RAC instances on the local node. To shut down an instance for an Oracle RAC database, enter a command similar to the following example, where <code><span class="italic">Grid_home</span></code> is the home directory for your Oracle Grid Infrastructure installation, <code>sales</code> is the name of the database, and <code>sales1</code> is the name of the instance:</p> <pre xml:space="preserve" class="oac_no_warn"> $ <span class="italic">CRS_home</span>/bin/srvctl stop instance -d sales -i "sales1" </pre></li> <li> <p>Make sure the <code>ORACLE_HOME</code> environment variable points to the software directory you want to patch, for example:</p> <pre xml:space="preserve" class="oac_no_warn"> $ echo $ORACLE_HOME /u01/app/oracle/11gR2/db_1 </pre></li> <li> <p>Use the following command from within the patch directory:</p> <pre xml:space="preserve" class="oac_no_warn"> $ opatch apply -minimize_downtime </pre> <p>If you run the OPatch command from the directory where the patch is staged on disk, you do not need to specify the patch ID.</p> <p>OPatch asks if you are ready to patch the local node. After you confirm that the Oracle RAC instances on the local node have been shut down, OPatch applies the patch to the Oracle home directory on the local node. You are then asked to select the next nodes to be patched.</p> </li> <li> <p>After you shut down the Oracle RAC instances on the other nodes in the cluster, you can restart the Oracle RAC instance on the local node. Then, instruct OPatch that you are ready to patch the remaining nodes.</p> </li> <li> <p>After all the nodes have been patched, restart the Oracle RAC instances on the other nodes in the cluster. The following command shows how to start the <code>sales2</code> instance for the Oracle RAC database named <code>sales</code>:</p> <pre xml:space="preserve" class="oac_no_warn"> $ <span class="italic">CRS_home</span>/bin/srvctl start instance -d sales -i "sales1" </pre></li> <li> <p>Verify that all the <code>nodeapps</code> were restarted on the nodes in the cluster.</p> <pre xml:space="preserve" class="oac_no_warn"> $ crsctl check crs </pre> <p>If any of the node applications did not restart, use the SRVCTL utility to restart them. For example, you can use commands similar the following to restart the listener on the <code>docrac1</code> node, where <span class="italic">Grid_home</span> is the home directory of your Oracle Grid Infrastructure installation:</p> <pre xml:space="preserve" class="oac_no_warn"> $ <span class="italic">CRS_home</span>/bin/srvctl start listener -n docrac1 </pre></li> <li> <p>Run any post-patch scripts that are mentioned in the patch instructions, for example:</p> <pre xml:space="preserve" class="oac_no_warn"> $ sqlplus /nolog SQL> connect sys/<span class="italic">password</span>@sales1 AS SYSDBA SQL> @<span class="italic">Oracle_home</span>/cpu/CPUOct2007/catcpu.sql SQL> @<span class="italic">Oracle_home</span>/rdbms/admin/utlrp.sql SQL> exit </pre></li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="softpatch2007.htm#BABBDEJC">Preparing to Use OPatch</a></p> <p><a href="tdprc_apply_patch.htm#CEGDCBDI">Using DB Control to Apply Patches to a Cluster Database</a></p> <p><a href="tdprc_patch_sets.htm#CHDCAJCH">Applying Patch Sets</a></p> <p><a href="tdprc_troubleshoot_patching.htm#CEGJJEAG">Troubleshooting Patch Deployment</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=OUICG008','newWindow').focus()"><span class="italic">Oracle Universal Installer and OPatch User's Guide for Windows and UNIX</span></a></p> </div> </div> <!-- class="sect2" --> <!-- 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 © 2006, 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="softpatch2012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdprc_troubleshoot_patching.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