<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Transitional//EN">
<HTML>
<HEAD>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

      For third-party license citations, please see the bottom of this file.
    *************************************************************************************
  -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="TEMPLATEBASE" content="vx_vxhelp_2005c">
<meta name="LASTUPDATED" content="06/15/05 07:50:11">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="08_checkpoints.fm">
     
<title>Guidelines for Oracle Recovery</title>

</HEAD>

<BODY bgcolor="#FFFFFF" link="#000066" vlink="#0000ff" marginheight="0" topmargin="0">
<basefont=1>

<a name="125577"></a>

<div align="left">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
   <td height="2" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#000000">
   </td>
 </tr>
 <tr>
   <td height="15" width="50%" border="0" cellspacing="0" cellpadding="0" bgcolor="#cccccc">
    <img src="images/vxsymbol.gif" height="20" width="31" border="0" cellspacing="0" cellpadding="0" align="left">
     
     
   </td>
   <td align="right" width="50%" bgcolor="#cccccc">

<!-- Header Breadcrumbs -->
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="08_checkpoints_sf_ora_rac67_125048.html" title="Previous - Verifying a Storage Checkpoint Using the Command Line">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="08_checkpoints_sf_ora_rac69_141431.html" title="Next - Using the Storage Checkpoint Command Line Interface (CLI)">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
   </td>
 </tr>

 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_ora_rac_splashpage_docCD_sf_ora_rac1_103036.vxhd" title="Storage Foundation for Oracle RAC Guides title page ">Storage Foundation for Oracle RAC Guides</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>
 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="sfrac_icg_titlepage_docCD_sf_ora_rac2_73700.vxhd" title="Storage Foundation 4.1 for Oracle RAC Installation and Configuration title page ">Storage Foundation 4.1 for Oracle RAC Installation and Configuration</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>


</table>
</div>

<div align="left">
 <table border="0" width="100%" bgcolor="#FFFFFF">
  <tr>
   <td width="100%" valign="top" bgcolor="#FFFFFF">

<!-- Start Main Topic Content -->
        <a name="startcontent"></a>
	
<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="125577"></a> Guidelines for Oracle Recovery</font>
</h2>

        
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="156947"></a>For optimal Oracle recovery, follow these guidelines:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="156949"></a>Back up all control files before storage rollback in case the subsequent Oracle recovery is not successful. Oracle recommends that you keep at least two copies of the control files for each Oracle database and that you store the copies on different disks. It is also a good idea to back up the control files before and after making structural changes to databases.</font>
</li>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="156955"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The <font face="Courier New, Courier, sansserif, sans serif" size="2">sfrac_ckptcreate</font> command automatically saves control file and log information when you create a Storage Checkpoint. See <a href="08_checkpoints_sf_ora_rac72_126968.html#126968">Creating Storage Checkpoints Using sfrac_ckptcreate</a> for more information.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="156980"></a>Make sure that the control files are <em>not</em> rolled back. </font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="156981"></a>A control file is a small binary file that describes the structure of the database and must be available to mount, open, and maintain the database. The control file stores all necessary database file information, log file information, the name of the database, the timestamp of database creation, and synchronization information, such as the Storage Checkpoint and log-sequence information needed for recovery. Rolling back the control file will result in an inconsistency between the physical database structure and the control file.</font>
</blockquote>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="125598"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If your intention is to roll back the database to recover from structural changes that you do not want to maintain, you may want to use the backup control file that was created by the <font face="Courier New, Courier, sansserif, sans serif" size="2">sfrac_ckptcreate</font> command. The backup control file is located in the directory $VXDBA_DBPATH/<font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_SID</font><font face="Courier New, Courier, sansserif, sans serif" size="2">/</font><font face="Courier New, Courier, sansserif, sans serif" size="2">checkpoint_di</font>r/CKPT_NAME.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157002"></a>Make sure that all archived redo logs are available.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157004"></a>A database backup with online and archived logs is required for a complete database recovery. Query <font face="Courier New, Courier, sansserif, sans serif" size="2">V$ARCHIVED_LOG</font> to list all the archived log information and <font face="Courier New, Courier, sansserif, sans serif" size="2">V$ARCHIVE_DEST</font> to list the location of archive destinations.</font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157008"></a>To restore the necessary archived redo log files, you can query <font face="Courier New, Courier, sansserif, sans serif" size="2">V$LOG_HISTORY</font> to list all the archived redo log history or query <font face="Courier New, Courier, sansserif, sans serif" size="2">V$RECOVERY_LOG</font> to list only the archived redo logs needed for recovery. The required archived redo log files can be restored to the destination specified in the <font face="Courier New, Courier, sansserif, sans serif" size="2">LOG_ARCHIVE_DEST</font> parameter or to an alternate location. If the archived redo logs were restored to an alternate location, use the <font face="Courier New, Courier, sansserif, sans serif" size="2">ALTER&nbsp;DATABASE&nbsp;RECOVER&nbsp;...&nbsp;FROM</font> statement during media recovery.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157016"></a>After storage rollback, perform Oracle recovery, applying some or all of the archived redo logs.</font>
</li>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="157017"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">After rolling back the database (including control files and redo logs) to an instant Storage Checkpoint, you need to recover the Oracle database instance. Rolling the database forward is not supported; that is, you cannot apply archived redo logs. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157019"></a>To perform a complete media recovery:</font>
</li>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="157020"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>SET&nbsp;AUTORECOVERY&nbsp;ON;</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="157021"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>RECOVER&nbsp;DATABASE;</b></font>
</font>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157023"></a>To perform an incomplete media recovery, use one of the following:</font>
</li>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="157024"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;RECOVER&nbsp;DATABASE&nbsp;UNTIL&nbsp;CANCEL;</b></font>
</font>
<ul><blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="140864"></a>	or</font>
</blockquote>
</ul><br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="157029"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;RECOVER&nbsp;DATABASE&nbsp;UNTIL&nbsp;TIME&nbsp;'yyyy-mm-dd:hh:mm:ss';</b></font>
</font>
<ul><blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157030"></a>(You can confirm the time of error by checking the <font face="Courier New, Courier, sansserif, sans serif" size="2">../bdump/alert*.log</font> file.)</font>
</blockquote>
<ul><blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="140950"></a>or</font>
</blockquote>
</ul></ul><a name="157035"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2"><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>				RECOVER DATABASE UNTIL TIME 'yyyy-mm-dd:hh:mm:ss' using</b></font> \<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>				backup controlfile;</b></font></font>
<ul><blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="140975"></a>or</font>
</blockquote>
</ul><br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="157041"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;RECOVER&nbsp;DATABASE&nbsp;UNTIL&nbsp;CHANGE&nbsp;scn;</b></font>
</font>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157043"></a>To open the database after an incomplete media recovery, use the following:</font>
</li>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="157045"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;ALTER&nbsp;DATABASE&nbsp;OPEN&nbsp;RESETLOGS;</b></font>
</font>
<ul><blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="157046"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">RESETLOGS</font> resets the log sequence. The <font face="Courier New, Courier, sansserif, sans serif" size="2">RESETLOGS</font> option is required after an incomplete media recovery. After opening the database with the <font face="Courier New, Courier, sansserif, sans serif" size="2">RESETLOGS</font> option, remove the Storage Checkpoint you just rolled back to as well as any Storage Checkpoints that were taken before that one. These earlier Storage Checkpoints can no longer be used for  storage rollback. After removing these Storage Checkpoints, be sure to create a new Storage Checkpoint.</font>
</blockquote>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/caution.gif" alt="Caution " height="16" width="16">&nbsp;<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="157047"></a><b>Caution  &nbsp;&nbsp;</b></font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"> After rolling back, be sure to delete the Storage Checkpoint that you rolled back to and then create a new one.</font>
<hr noshade size="2" width="100%" color="#000000">
</ul></ul>
</p>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="149913"></a>See your Oracle documentation for complete information on recovery.</font>
</p>


<!-- End Main Topic Content -->

   </td>
  </tr>
 </table>
</div>

<div>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
  <td height="18" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
  </td>
 </tr>
  <td align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&nbsp;&#94;&nbsp;<a href="08_checkpoints_sf_ora_rac68_125577.html" title="Guidelines for Oracle Recovery">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="08_checkpoints_sf_ora_rac67_125048.html" title="Previous - Verifying a Storage Checkpoint Using the Command Line">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="08_checkpoints_sf_ora_rac69_141431.html" title="Next - Using the Storage Checkpoint Command Line Interface (CLI)">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
  </td>
 <tr>
   <td height="9" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
   </td>
 </tr>

<!-- Footer Breadcrumbs -->
<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_ora_rac_splashpage_docCD_sf_ora_rac1_103036.vxhd" title="Storage Foundation for Oracle RAC Guides title page ">Storage Foundation for Oracle RAC Guides</a>&nbsp;&nbsp;</font></td>
</tr>

<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="sfrac_icg_titlepage_docCD_sf_ora_rac2_73700.vxhd" title="Storage Foundation 4.1 for Oracle RAC Installation and Configuration title page ">Storage Foundation 4.1 for Oracle RAC Installation and Configuration</a>&nbsp;&nbsp;</font></td>
</tr>


 <tr>
  <td colspan="2" align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" color="#000000" align="right" size="-2">
<em>VERITAS Software Corporation
</em></font><br>

<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">www.veritas.com</font><br>
  </td>
 </tr>
</table>
</div>

</BODY>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

    VERITAS, VERITAS SOFTWARE, the VERITAS Logo, and VERITAS Software Documentation 
    are trademarks or registered trademarks of VERITAS Software Corporation 
    or its affiliates in the U.S. and other countries. Other names may be 
    trademarks of their respective owners. 

    Apache Jakarta Lucene:
    Apache Software License
    Version 1.1

    Copyright (c) 2000 The Apache Software Foundation. All rights reserved.

    Redistribution and use in source and binary forms, with or without modification, 
    are permitted provided that the following conditions are met:

    1. Redistributions of source code must retain the above copyright notice, this 
    list of conditions and the following disclaimer.

    2. Redistributions in binary form must reproduce the above copyright notice, this 
    list of conditions and the following disclaimer in the documentation and/or other 
    materials provided with the distribution.

    3. The end-user documentation included with the redistribution, if any, must include 
    the following acknowledgment: "This product includes software developed by the Apache 
    Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may 
    appear in the software itself, if and wherever such third-party acknowledgments 
    normally appear.

    4. The names "Apache" and "Apache Software Foundation" must not be used to endorse or 
    promote products derived from this software without prior written permission. For 
    written permission, please contact apache@apache.org.

    5. Products derived from this software may not be called "Apache", nor may "Apache" 
    appear in their name, without prior written permission of the Apache Software Foundation.

    THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, 
    BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A 
    PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION 
    OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, 
    OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS 
    OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 
    ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
    ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    This software consists of voluntary contributions made by many individuals on behalf 
    of the Apache Software Foundation. For more information on the Apache Software Foundation, 
    please see <http://www.apache.org/>. Portions of this software are based upon public domain 
    software originally written at the National Center for Supercomputing Applications, University 
    of Illinois, Urbana-Champaign.
    
    This product includes WebWindow Software developed by Horst Heistermann.
    *************************************************************************************
  -->
</HTML>
