<!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/13/05 10:35:38">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_ch8storageckpts.fm">
     
<title>Backing Up Using a Storage Checkpoint</title>

</HEAD>

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

<a name="141456"></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="oracle_hp_ch8storageckpts_sf_dbag81_141397.html" title="Previous - Backing Up and Recovering the Database Using Storage Checkpoints">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html" title="Next - Guidelines for Oracle Recovery">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_dbag_splashpage_docCD_sf_dbag1_103036.vxhd" title="Storage Foundation for Databases Guides title page ">Storage Foundation for Databases 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="oracle_hp_dbag_titlepage_docCD_sf_dbag2_73700.vxhd" title="Storage Foundation 4.1 for Oracle Administrator's Guide title page ">Storage Foundation 4.1 for Oracle Administrator's Guide</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="141456"></a> Backing Up Using a Storage Checkpoint</font>
</h2>

        
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141457"></a>You can back up a database by creating a Storage Checkpoint using the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptcreate</font> command, mount the Storage Checkpoint as read-only using the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptmount</font> command, and then back it up using tools such as <font face="Courier New, Courier, sansserif, sans serif" size="2">tar</font> or <font face="Courier New, Courier, sansserif, sans serif" size="2">cpio</font>.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="141459"></a><b>Usage Notes</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141460"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptcreate</font>(1M), <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptmount</font>(1M), <font face="Courier New, Courier, sansserif, sans serif" size="2">tar</font>(1), and <font face="Courier New, Courier, sansserif, sans serif" size="2">cpio</font>(1) manual pages for more information.</font>
</li>
</ul>
</p>
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="141462"></a>&nbsp;&nbsp;<b>To back up a frozen database image using the command line</b></font>
</p>
<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="141465"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">In this example, all the database datafiles reside on one VxFS file system named <font face="Courier New, Courier, sansserif, sans serif" size="2">/db01</font>.
</font>
<hr noshade size="2" width="100%" color="#000000">
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141467"></a>Create a Storage Checkpoint using the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptcreate</font> command:
</font>
<a name="141468"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">			$ <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptcreate -S PROD -H /oracle/product -o online</b></font></font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="141469"></a>&nbsp;&nbsp;&nbsp;Creating&nbsp;online&nbsp;Storage&nbsp;Checkpoint&nbsp;of&nbsp;database&nbsp;PROD.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="141470"></a>&nbsp;&nbsp;&nbsp;Storage&nbsp;Checkpoint&nbsp;Checkpoint_903937870&nbsp;created.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141472"></a>Mount the Storage Checkpoint using the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptmount</font> command:
</font>
<a name="141473"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">			$ <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptmount -S PROD -c</b></font> \<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>			Checkpoint_903937870 -m /tmp/ckpt_ro</b></font></font>
<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="141475"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If the specified mount point directory does not exist, then <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptmount</font> creates it before mounting the Storage Checkpoint, as long as the Oracle DBA user has permission to create it.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141477"></a>Use <font face="Courier New, Courier, sansserif, sans serif" size="2">tar</font> to back up the Storage Checkpoint:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="141478"></a>&nbsp;&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cd&nbsp;/tmp/ckpt_ro</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="141479"></a>&nbsp;&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ls</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="141480"></a>&nbsp;&nbsp;&nbsp;db01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="141481"></a>&nbsp;&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>tar&nbsp;cvf&nbsp;/tmp/PROD_db01_903937870.tar&nbsp;./db01</b></font>
</font>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="141482"></a>Recovering a Database Using a Storage Checkpoint</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141483"></a>Since Storage Checkpoints record the before images of blocks that have changed, you can use them to do a file-system-based storage rollback to the exact time when the Storage Checkpoint was taken. You can consider Storage Checkpoints as backups that are online, and you can use them to roll back an entire database, a tablespace, or a single database file. Rolling back to or restoring from any Storage Checkpoint is generally very fast because only the changed data blocks need to be restored.</font>
</p>

<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="141484"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Some database changes made after a Storage Checkpoint was taken may make it impossible to perform an incomplete recovery of the databases after Storage Rollback of an online or offline Storage Checkpoint using the current control files. For example, you cannot perform incomplete recovery of the database to the point right before the control files have recorded the addition or removal of datafiles. To provide recovery options, a backup copy of the control file for the database is saved under the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/</font><font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_SID</font><font face="Courier New, Courier, sansserif, sans serif" size="2">/checkpoint_dir/</font><font face="Courier New, Courier, sansserif, sans serif" size="2">CKPT_NAME</font> directory immediately after a Storage Checkpoint is created. You can use this file to assist with database recovery, if necessary. If possible, both ASCII and binary versions of the control file will be left under the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/</font><font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_SID</font><font face="Courier New, Courier, sansserif, sans serif" size="2">/checkpoint_dir/</font><font face="Courier New, Courier, sansserif, sans serif" size="2">CKPT_NAME</font> directory. The binary version will be compressed to conserve space. Use extreme caution when recovering your database using alternate control files.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141485"></a>Suppose a user deletes a table by mistake right after 4:00 p.m., and you want to recover the database to a state just before the mistake. You created a Storage Checkpoint (<font face="Courier New, Courier, sansserif, sans serif" size="2">Checkpoint_903937870</font>) while the database was running at 11:00 a.m., and you have <font face="Courier New, Courier, sansserif, sans serif" size="2">ARCHIVELOG</font> mode enabled. </font>
</p>

</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="141486"></a>&nbsp;&nbsp;<b>To recover the database using a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141487"></a>Ensure that the affected datafiles, tablespaces, or database are offline, and use storage rollback to roll back any datafiles in the database that contained the table data from the Storage Checkpoint you created at 11:00 a.m.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141490"></a>Start up the database instance if it is down.
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141495"></a>Use <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>recover database until cancel</b></font>, <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>recover database until change</b></font>, or <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>recover database until time</b></font> to re-apply archive logs to the point before the table was deleted to recover the database to 4:00 p.m.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141498"></a>Open the database with <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>alter database open resetlogs</b></font>. 
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141499"></a>Delete the Storage Checkpoint you created at 11:00 a.m. and any other Storage Checkpoints created before that time.
</font>
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="141500"></a>Create a new Storage Checkpoint.
</font>
<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="141522"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"> For more information on storage rollback and recovering to Storage Checkpoints, see <a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html#397420">Rolling Back the Database to a Storage Checkpoint</a>, <a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html#397478">Rolling Back a Tablespace to a Storage Checkpoint</a>, and <a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html#397620">Rolling Back Datafiles to a Storage Checkpoint</a>.
</font>
<hr noshade size="2" width="100%" color="#000000">
</ol>

<!-- 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="oracle_hp_ch8storageckpts_sf_dbag82_141456.html" title="Backing Up Using a Storage Checkpoint">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="oracle_hp_ch8storageckpts_sf_dbag81_141397.html" title="Previous - Backing Up and Recovering the Database Using Storage Checkpoints">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html" title="Next - Guidelines for Oracle Recovery">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_dbag_splashpage_docCD_sf_dbag1_103036.vxhd" title="Storage Foundation for Databases Guides title page ">Storage Foundation for Databases 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="oracle_hp_dbag_titlepage_docCD_sf_dbag2_73700.vxhd" title="Storage Foundation 4.1 for Oracle Administrator's Guide title page ">Storage Foundation 4.1 for Oracle Administrator's Guide</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>
