<!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:55">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_ch12vxdbagui.fm">
     
<title>Managing Storage Checkpoints </title>

</HEAD>

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

<a name="251217"></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_ch12vxdbagui_sf_dbag123_250669.html" title="Previous - Using the Monitoring Agent">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch12vxdbagui_sf_dbag125_252561.html" title="Next - Managing Snapshots with Database FlashSnap">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>
	
<h1><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="+1" color="#000000"><a name="251217"></a>Managing Storage Checkpoints </font>
</h1>
 
  
  
  

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251218"></a>A Storage Checkpoint is like an online backup of a database that contains a point-in-time database image. Storage Checkpoints can later be used to restore the image of a datafile, a tablespace, or the entire database to any earlier state recorded by the Storage Checkpoints. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251221"></a>VERITAS Storage Foundation <em>for Oracle</em> uses the VxDBA repository to determine the list of tablespaces, datafiles, and file systems for Storage Checkpoint creation and removal. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251224"></a>For more information about Storage Checkpoints, see <a href="oracle_hp_ch8storageckpts_sf_dbag77_140160.html#140206">Understanding Storage Checkpoints and Storage Rollback</a> and <a href="oracle_hp_ch8storageckpts_sf_dbag77_140160.html#140160">Using Storage Checkpoints and Storage Rollback for Backup and Restore</a>.</font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="251253"></a>Creating a Storage Checkpoint</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251254"></a>You have the option to create an offline, online, or instant Storage Checkpoint. If the database is online when the Storage Checkpoint is created, VERITAS Storage Foundation <em>for Oracle</em> switches the database to online<em> </em>backup mode before creating the Storage Checkpoint. Once the Storage Checkpoint is created, VERITAS Storage Foundation <em>for Oracle</em> switches the database back to its normal operation mode.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251257"></a>For the instant option, the database should be online and it can be running in either ARCHIVELOG or NOARCHIVELOG mode. You can only roll back the entire database to an instant Storage Checkpoint. After the rollback is complete, you need to perform Oracle database instance recovery. Rolling the database forward is not supported; that is, you cannot apply archived redo logs. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251258"></a>In addition to creating a Storage Checkpoint, the GUI automatically backs up the associated control files, initialization file, and log information. Suppose that you made a structural change to your database, and then needed to roll back the database to a Storage Checkpoint that was created before the structural change. The Storage Rollback would only be successful if you could also reconstruct the database to the same structure that it was when the Storage Checkpoint was created. You can recreate the previous database structure using the control files, initialization file, and log information that were backed up when the Storage Checkpoint was created.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="251259"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251263"></a>Enable <font face="Courier New, Courier, sansserif, sans serif" size="2">ARCHIVELOG</font> mode before taking online Storage Checkpoints. See <a href="oracle_hp_ch8storageckpts_sf_dbag81_141397.html#141397">Backing Up and Recovering the Database Using Storage Checkpoints</a> and <a href="oracle_hp_ch8storageckpts_sf_dbag77_140160.html#140160">Using Storage Checkpoints and Storage Rollback for Backup and Restore</a>.</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="251292"></a>&nbsp;&nbsp;<b>To create a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251293"></a>Click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoints</b></font> icon in the object tree. (You may need to expand the tree view to find the icon.)
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251294"></a>Select one of the following methods to create a Storage Checkpoint.
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251295"></a>From the menu bar, select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoints </b></font>&gt; <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Create Storage Checkpoint</b></font>.</font>
</li>
<ul><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251296"></a>or</font>
</p>
</ul><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251297"></a>Right click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoints</b></font> icon to bring up a pop-up menu. Then, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Create Storage Checkpoint</b></font>.</font>
</li>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251298"></a>The Create a Storage Checkpoint wizard is displayed.</font>
</p>
</ul>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251299"></a>Verify the Oracle SID, which is the Oracle System Identifier, for which you are creating the Storage Checkpoint. This is a read-only field.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251300"></a>Select one of the following options:
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251301"></a>To create an online Storage Checkpoint, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Online</b></font> button.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251302"></a>To create an offline Storage Checkpoint, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Offline</b></font> button.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251303"></a>To create an instant Storage Checkpoint, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Instant</b></font> button.</font>
</li>
</ul>
</p>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251304"></a>If you want to remove the Storage Checkpoint when the file system becomes full, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Remove This Storage Checkpoint</b></font> button.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251305"></a>or</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251306"></a>If you want to retain the Storage Checkpoint when the file system becomes full, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Retain This Storage Checkpoint</b></font> button.</font>
</p>
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251307"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Create</b></font> to continue.
</font>
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251308"></a>At the prompt, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to proceed with creating the Storage Checkpoint.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251309"></a>If the Storage Checkpoint was successfully created, you will receive a confirmation message. To see details, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Show Details</b></font> checkbox. The details are displayed in a pop-up window.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251310"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font> to continue.</font>
</p>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="251311"></a>Viewing Storage Checkpoint Details</font>
</h2>
 
</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="251312"></a>&nbsp;&nbsp;<b>To view the details of a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251313"></a>Click a specific <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint</b></font> in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.)
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251314"></a>The Storage Checkpoint information is displayed on the right side of the window.</font>
</p>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251315"></a>To view file system quota information for the Storage Checkpoint, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>File System Quota</b></font> tab at the top of the window, just above the Storage Checkpoint details.
</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="251316"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The file system quota information is only available for disk layout version 6.
</font>
<hr noshade size="2" width="100%" color="#000000">
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="251317"></a>Mounting a Storage Checkpoint</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251318"></a>You can mount and write to Storage Checkpoints just as you can do with any file system. See <a href="oracle_hp_ch8storageckpts_sf_dbag77_140160.html#140160">Using Storage Checkpoints and Storage Rollback for Backup and Restore</a> for more information.</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="251337"></a>&nbsp;&nbsp;<b>To mount a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251338"></a>Click a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.)
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251339"></a>Select one of the following methods to mount the Storage Checkpoint.
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251340"></a>From the menu bar, select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint </b></font>&gt; <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Mount Storage Checkpoint</b></font>.</font>
</li>
<ul><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251341"></a>or</font>
</p>
</ul><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251342"></a>Right click the Storage Checkpoint you want to mount to bring up a pop-up menu. Then click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Mount Storage Checkpoint</b></font>.</font>
</li>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251343"></a>The Mount a Storage Checkpoint wizard then displays.</font>
</p>
</ul>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251344"></a>Verify that you are mounting the correct Storage Checkpoint and click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Next</b></font> to continue. If you selected the wrong Storage Checkpoint, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Cancel</b></font>. The information on this screen is read-only.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251345"></a>On the second screen, enter the mount point (absolute path) where the Storage Checkpoint should be mounted.
</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="251346"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The directory containing the mount point must be writable by the database administrator group. You should have created this group during installation. If not, create the group before mounting the Storage Checkpoint.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251347"></a>To mount the Storage Checkpoint as read-only, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Read Only</b></font>.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251348"></a>or</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251349"></a>To mount the Storage Checkpoint as read-write, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Read/Write</b></font>. This will allow you to make changes to the Storage Checkpoint.</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="251350"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">When you select the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Read/Write</b></font> option, the GUI creates an identical Storage Checkpoint with the same name plus a <font face="Courier New, Courier, sansserif, sans serif" size="2">wr</font><em>001</em> suffix, where <em>001</em> is a sequential number. The GUI mounts the new Storage Checkpoint and leaves the original Storage Checkpoint unmounted. This allows you to roll back to the original Storage Checkpoint.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251351"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Mount</b></font> to mount the Storage Checkpoint.
</font>
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251352"></a>At the prompt, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to proceed with mounting the Storage Checkpoint.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251353"></a>When you have finished viewing the details in the Confirmation dialog, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK </b></font>to continue.</font>
</p>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="251355"></a>Unmounting a Storage Checkpoint</font>
</h2>
 
</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="251356"></a>&nbsp;&nbsp;<b>To unmount a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251357"></a>Click a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the 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="251358"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If you want to unmount a Storage Checkpoint that was originally mounted with the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Read/Write</b></font> option, you should unmount the new Storage Checkpoint that was automatically created by the GUI, which is the Storage Checkpoint that contains the <font face="Courier New, Courier, sansserif, sans serif" size="2">wr</font><em>001</em> suffix, where <em>001</em> is a sequential number, at the end of the name.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251359"></a>Select one of the following methods to unmount the Storage Checkpoint.
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251360"></a>From the menu bar, select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint </b></font>&gt; <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Unmount a Storage Checkpoint</b></font>.</font>
</li>
<ul><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251361"></a>or</font>
</p>
</ul><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251362"></a>Right click the Storage Checkpoint you want to unmount to bring up a pop-up menu. Then click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Unmount Storage Checkpoint</b></font>.</font>
</li>
</ul>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251363"></a>Verify that you are unmounting the correct Storage Checkpoint and click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Unmount</b></font> to continue. If you selected the wrong Storage Checkpoint, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Cancel</b></font>. The information on this screen is read-only.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251364"></a>At the prompt, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to proceed with unmounting the Storage Checkpoint.
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251365"></a>A confirmation dialog is displayed. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font> to continue.
</font>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="251366"></a>Removing a Storage Checkpoint</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251368"></a>Occasionally, you may need to manually remove Storage Checkpoints that are no longer needed. For example, you can remove a Storage Checkpoint on a file system to free up needed space.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="251370"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251371"></a>Before you can remove a mounted Storage Checkpoint, you must first unmount it.</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="251373"></a>&nbsp;&nbsp;<b>To remove a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251374"></a>Click a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.)
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251375"></a>Select one of the following methods to remove the Storage Checkpoint.
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251376"></a>From the menu bar, select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint </b></font>&gt; <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Remove Storage Checkpoint</b></font>.</font>
</li>
<ul><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251377"></a>or</font>
</p>
</ul><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251378"></a>Right click the Storage Checkpoint you want to remove to bring up a pop-up menu. Then click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Remove Storage Checkpoint</b></font>.</font>
</li>
</ul>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251379"></a>At the prompt, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to remove the Storage Checkpoint.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251380"></a>If the Storage Checkpoint was successfully removed, you will receive a confirmation message. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font> to continue.</font>
</p>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="251381"></a>Rolling Back to a Storage Checkpoint</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251383"></a>You can roll back a database file, a list of database files, a single tablespace, or the entire database to a Storage Checkpoint. To perform a Storage Rollback, you must have a valid Storage Checkpoint. This option is not available with an instant Storage Checkpoint.</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="251384"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The GUI does not automatically roll back the control file associated with a Storage Checkpoint. See <a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html#142213">Guidelines for Oracle Recovery</a> for information on database recovery.
</font>
<hr noshade size="2" width="100%" color="#000000">
<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="251403"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You must be the Database Administrator to perform Storage Rollback operations. You must shut down the instance to perform full Storage Rollback of the database, or you can choose to leave the database up to roll back a datafile or tablespace. In this situation, VERITAS Storage Foundation <em>for Oracle</em> checks to see if the target database objects are offline before proceeding. See <a href="oracle_hp_ch8storageckpts_sf_dbag81_141397.html#141397">Backing Up and Recovering the Database Using Storage Checkpoints</a>, and<a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html#142213">Guidelines for Oracle Recovery</a> for more information.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251443"></a>Storage Checkpoints can only be used to roll back files that are damaged due to a software error or a human error (for example, accidental deletion of a table). Because Storage Checkpoints reside on the same physical disks as the primary file system, when a file is corrupted due to a media failure, the file on the Storage Checkpoints will not be available either. In this case, you need to restore files from a tape backup.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251444"></a>After the files are rolled back, you may need to follow the recovery procedure described in your Oracle manuals to recover the database before the database can be used.</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="251445"></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 run Storage Rollback successfully. For example, you cannot successfully run Storage Rollback if the control files for the database 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><em>ORACLE_SID</em><font face="Courier New, Courier, sansserif, sans serif" size="2">/checkpoint_dir/</font><em>CKPT_NAME</em> directory just after a Storage Checkpoint is created. You can use this file to assist with database recovery, if necessary. If possible, both an ASII and binary version of the control file will be left under the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/</font><em>ORACLE_SID</em><font face="Courier New, Courier, sansserif, sans serif" size="2">/checkpoint_dir/</font><em>CKPT_NAME</em> directory, with the binary version being compressed to conserve space. Use extreme caution when recovering your database using alternate control files.
</font>
<hr noshade size="2" width="100%" color="#000000">



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="251446"></a>Rolling Back the Database to a Storage Checkpoint</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251448"></a>Rolling back the entire database rolls back all the datafiles used by the database, except the redo logs and control files, to a Storage Checkpoint. </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="251450"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">While the Storage Rollback process is running, it creates a temporary file, <font face="Courier New, Courier, sansserif, sans serif" size="2">/</font><font face="Courier New, Courier, sansserif, sans serif" size="2">filesystem</font><font face="Courier New, Courier, sansserif, sans serif" size="2">/.VRTSstrb.lock</font>, in each file system. Do not remove these temporary lock files.
</font>
<hr noshade size="2" width="100%" color="#000000">
</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="251452"></a>&nbsp;&nbsp;<b>To rollback the database to a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251453"></a>Shut down the Oracle database from the GUI.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251454"></a>Click the a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.)
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251455"></a>Select one of the following methods to rollback to the selected Storage Checkpoint.
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251456"></a>From the menu bar, select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint </b></font>&gt; <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back Storage Checkpoint</b></font>.</font>
</li>
<ul><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251457"></a>or</font>
</p>
</ul><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251458"></a>Right click the Storage Checkpoint to which you want to rollback to bring up a pop-up menu. Then, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back Storage Checkpoint</b></font>.</font>
</li>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251459"></a>The Rollback a Storage Checkpoint wizard is displayed.</font>
</p>
</ul>
</p>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251460"></a>Verify that you are rolling back to the correct Storage Checkpoint and click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Next</b></font> to continue. If you selected the wrong Storage Checkpoint, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Cancel</b></font>. The information on this screen is read-only.
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251461"></a>On the second screen, use the drop-down menu to select the appropriate buffer size in the Rollback Buffer Size field. The default buffer size is 128K.
</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="251462"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The buffer size configured for reads and writes when performing a Storage Rollback can affect performance. Vary the size to determine the optimal setting for your system.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251463"></a>Use the drop-down menu to select the appropriate number of threads in the Number of Threads field. The default number of threads is four.
</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="251464"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Depending on the number of CPUs available on your system and the type of volume on which the file system is located, this default setting may specify too few or too many threads.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251465"></a>Click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll back a database </b></font>button to indicate that you are rolling back the entire database to the Storage Checkpoint.
</font>
<li value="8">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251466"></a>Click Next to continue. Click Roll Back to continue. 
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251467"></a>If the Storage Rollback was successful, a confirmation message is displayed.</font>
</p>
<li value="9">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251468"></a>To see the Storage Rollback details, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Show details</b></font> checkbox. The details are displayed in the pop-up window.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251469"></a>When you have finished viewing the details, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font>.</font>
</p>
<li value="10">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251470"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to roll back the tablespace or tablespaces. Perform any necessary Oracle recovery. See <a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html#142213">Guidelines for Oracle Recovery</a> for more information. (You cannot recover your database through the GUI.)
</font>
<li value="11">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251489"></a>Restart the database from the GUI.
</font>
</ol>



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="251490"></a>Rolling Back a Tablespace to a Storage Checkpoint</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251491"></a>If a tablespace is corrupted or removed due to a software error or a human mistake, this operation rolls back all of the files of the corrupted or removed tablespace to a Storage Checkpoint.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251492"></a>This option is only available for offline and online Storage Checkpoints. You cannot roll back a tablespace to an instant Storage Checkpoint.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251493"></a>Rolling back a tablespace is used for complete recovery of the tablespace. It is not designed for point-in-time (incomplete) tablespace recovery, which is more complicated and requires interaction with Oracle Customer Support. The tablespace point-in-time recovery requires using a clone database. See <a href="oracle_hp_ch12vxdbagui_sf_dbag121_249570.html#249570">Creating Clone Database</a> for more information.</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="251500"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You can perform this operation while the database is online as long as the tablespace is offline.
</font>
<hr noshade size="2" width="100%" color="#000000">
</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="251501"></a>&nbsp;&nbsp;<b>To roll back a tablespace to a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251502"></a>Verify that the tablespace to which you want to roll back is offline.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251503"></a>Click the a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.)
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251504"></a>Select one of the following methods to rollback to the selected Storage Checkpoint.
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251505"></a>From the menu bar, select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint </b></font>&gt; <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Rollback a Storage Checkpoint</b></font>.</font>
</li>
<ul><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251506"></a>or</font>
</p>
</ul><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251507"></a>Right click the Storage Checkpoint to which you want to rollback to bring up a pop-up menu. Then, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Rollback a Storage Checkpoint</b></font>.</font>
</li>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251508"></a>If the database is online, you will receive a prompt asking you if you want to continue. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to continue the Storage Rollback.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251509"></a>The Rollback a Storage Checkpoint wizard is displayed.</font>
</p>
</ul>
</p>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251510"></a>Verify that you are rolling back to the correct Storage Checkpoint and click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Next</b></font> to continue. If you selected the wrong Storage Checkpoint, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Cancel</b></font>. The information on this screen is read-only.
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251511"></a>On the second screen, use the drop-down menu to select the appropriate buffer size in the Rollback Buffer Size field. The default buffer size is 128K.
</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="251512"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The buffer size configured for reads and writes when performing a Storage Rollback can affect performance. Vary the size to determine the optimal setting for your system.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251513"></a>Use the drop-down menu to select the appropriate number of threads in the Number of Threads field. The default number of threads is four.
</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="251514"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Depending on the number of CPUs available on your system and the type of volume on which the file system is located, this default setting may specify too few or too many threads.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251515"></a>Click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Rollback a Tablespace</b></font> button to indicate that you are rolling back the tablespace to the Storage Checkpoint.
</font>
<li value="8">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251516"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Next</b></font> to continue. Select the tablespace, or tablespaces, you would like to roll back by clicking the appropriate checkbox in the Tablespace list. 
</font>
<li value="9">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251517"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back </b></font>to continue.
</font>
<li value="10">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251518"></a>If the Storage Rollback was successful, you will receive a confirmation message. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font> to continue. 
</font>
<li value="11">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251519"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to rollback the datafile or datafiles. Perform any necessary Oracle media recovery. See <a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html#142213">Guidelines for Oracle Recovery</a> for more information. (You cannot recover database information through the GUI.)
</font>
<li value="12">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251529"></a>Put the recovered tablespace back online.
</font>
</ol>



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="251531"></a>Rolling Back Datafiles to a Storage Checkpoint</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251532"></a>Rolling back datafiles rolls back database files to a Storage Checkpoint. You can also use this operation to roll back more than one datafile.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251533"></a>This option is only available for offline and online Storage Checkpoints. You cannot roll back a datafile to an instant Storage Checkpoint.</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="251534"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You can perform this operation while the tablespace is online as long as the datafile is offline.
</font>
<hr noshade size="2" width="100%" color="#000000">
</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="251535"></a>&nbsp;&nbsp;<b>To roll back datafiles to a Storage Checkpoint</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251536"></a>Verify that the datafile to which you want to roll back is offline.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251537"></a>Click the a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.)
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251538"></a>Select one of the following methods to rollback to the selected Storage Checkpoint.
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251539"></a>From the menu bar, select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint </b></font>&gt; <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Rollback a Storage Checkpoint</b></font>.</font>
</li>
<ul><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251540"></a>or</font>
</p>
</ul><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251541"></a>Right click the Storage Checkpoint to which you want to rollback to bring up a pop-up menu. Then click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Rollback a Storage Checkpoint</b></font>.</font>
</li>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251542"></a>If the database is online, you will receive a prompt asking you if you want to continue. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Yes</b></font> to continue the Storage Rollback.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251543"></a>The Rollback a Storage Checkpoint wizard is displayed.</font>
</p>
</ul>
</p>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251544"></a>Verify that you are rolling back to the correct Storage Checkpoint and click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Next</b></font> to continue. If you selected the wrong Storage Checkpoint, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Cancel</b></font>. The information on this screen is read-only.
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251545"></a>On the second screen, use the drop-down menu to select the appropriate buffer size in the Rollback Buffer Size field. The default buffer size is 128K.
</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="251546"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The buffer size configured for reads and writes when performing a Storage Rollback can affect performance. Vary the size to determine the optimal setting for your system.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251547"></a>Use the drop-down menu to select the appropriate number of threads in the Number of Threads field. The default number of threads is four.
</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="251548"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Depending on the number of CPUs available on your system and the type of volume on which the file system is located, this default setting may specify too few or too many threads.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251549"></a>Click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll back a Datafile</b></font> button to indicate that you are rolling back the datafile to the Storage Checkpoint.
</font>
<li value="8">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251550"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Next</b></font> to continue.
</font>
<li value="9">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251551"></a>Select the datafile, or datafiles, you would like to roll back by clicking on the appropriate checkbox in the Datafile list. 
</font>
<li value="10">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251552"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back </b></font>to continue.
</font>
<li value="11">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251553"></a>If the Storage Rollback was successful, you will receive a confirmation message. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font> to continue. You are then returned to the rollback window.
</font>
<li value="12">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251556"></a>Perform any necessary Oracle media recovery. See <a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html#142213">Guidelines for Oracle Recovery</a> for more information.
</font>
<li value="13">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251564"></a>Put the recovered datafile back online.
</font>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="251565"></a>Using a Storage Checkpoint Policy for Space Management</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251566"></a>A Storage Checkpoint policy establishes how many Storage Checkpoints you would like to keep in the event your file system becomes full. You can also determine what to do with old Storage Checkpoints when you run out of space. You should set up a Storage Checkpoint policy before creating any Storage Checkpoint schedules. </font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="251568"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251569"></a>You must enable the Monitoring Agent to use the Storage Checkpoint policy.</font>
</li>
</ul>
</p>



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="251571"></a>Creating a Storage Checkpoint Policy</font>
</h3>
</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="251573"></a>&nbsp;&nbsp;<b>To create a Storage Checkpoint policy</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251574"></a>Click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoints</b></font> icon in the object tree. (You may need to expand the tree view to find the icon.)
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251575"></a>Select one of the following methods to create a Storage Checkpoint policy.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251576"></a>Right click the Storage Checkpoint icon to bring up a pop-up menu. Then, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Policy</b></font>.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251577"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint Policy</b></font> window is displayed.</font>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251578"></a>Enter the maximum number of Storage Checkpoints to keep on the file system in the Maximum field.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251579"></a>To enable the policy, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Enable</b></font> button.
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251580"></a>To remove old Storage Checkpoints if the maximum number is exceeded, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Remove Old Storage Checkpoints</b></font>.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251581"></a>or</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251582"></a>If you would like to keep old Storage Checkpoints after the maximum number is exceeded, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Retain Old Storage Checkpoints</b></font>. (This option will prevent any new Storage Checkpoints from being created if the file system runs out of space.)</font>
</p>
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251583"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Policy Update</b></font> to save your changes.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251584"></a>If the Storage Checkpoint policy was successfully created, you will receive a confirmation message. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font> to continue.</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="251585"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If your Monitoring Agent is disabled, you will receive warning stating that you must active the Monitoring Agent in order to use the Storage Checkpoint policy.
</font>
<hr noshade size="2" width="100%" color="#000000">
</ol>



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="251586"></a>Disabling a Storage Checkpoint Policy</font>
</h3>
</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="251587"></a>&nbsp;&nbsp;<b>To disable a Storage Checkpoint policy</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251588"></a>Click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoints</b></font> icon in the object tree. (You may need to expand the tree view to find the icon.)
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251589"></a>Select one of the following methods to disable a Storage Checkpoint policy.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251590"></a>Right click the Storage Checkpoint icon to bring up a pop-up menu. Then, click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Policy</b></font>.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251591"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint Policy</b></font> window is displayed.</font>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251592"></a>To disable the policy, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Disable</b></font> button.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251593"></a>Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Policy Update</b></font> to save your changes.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="251594"></a>If the Storage Checkpoint policy was successfully disabled, you will receive a confirmation message. Click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font> to continue.</font>
</p>
</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_ch12vxdbagui_sf_dbag124_251217.html" title="Managing Storage Checkpoints ">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_ch12vxdbagui_sf_dbag123_250669.html" title="Previous - Using the Monitoring Agent">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch12vxdbagui_sf_dbag125_252561.html" title="Next - Managing Snapshots with Database FlashSnap">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>
