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

</HEAD>

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

<a name="397037"></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_ch13vxdba_sf_dbag130_396536.html" title="Previous - Using VxDBA to Perform Administrative Operations">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch13vxdba_sf_dbag132_398516.html" title="Next - Configuring Statistics Collection">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="397037"></a> Managing Storage Checkpoints</font>
</h2>

        
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397038"></a>Use the<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Checkpoint Administration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to create, display, mount, unmount, and remove Storage Checkpoints. A Storage Checkpoint can be considered an online database backup that contains a point-in-time database image. Storage Checkpoints can later be used to restore the image of a file, 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="397039"></a>This operation displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption0"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba25_t.htm">
<img src="images/oracle_hp_ch13vxdba25.gif" width="110" height="69" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397055"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397057"></a>VxDBA uses the repository to determine the list of tablespaces, datafiles, and file systems for Storage Checkpoint creation and removal. Select from the following Storage Checkpoint Administration operations:</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397058"></a><b> Create New Storage Checkpoints</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397059"></a>Use this menu option to create a Storage Checkpoint as a point-in-time image of the database and to back up control file, initialization file, and log information. The database can be offline or online when you create a Storage Checkpoint. </font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397060"></a><b> Display Storage Checkpoints.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397061"></a>Use this menu option to display the Storage Checkpoints created by VxDBA. After displaying the VxDBA Storage Checkpoints, VxDBA asks if you want to display any other Storage Checkpoints, such as Storage Checkpoints created by the Capacity Planning Utility or NetBackup.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397062"></a><b> Mount Storage Checkpoints</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397063"></a>Use this menu option to mount a Storage Checkpoint into the file system namespace. Mounted Storage Checkpoints appear as any other file system on the machine, and you can access mounted Storage Checkpoints using all normal file system-based commands.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397064"></a><b> Unmount Storage Checkpoints</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397065"></a>Use this menu option to unmount a mounted Storage Checkpoint.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397066"></a><b> Remove Storage Checkpoints</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397067"></a>Use this menu option to remove Storage Checkpoints that you no longer need.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397069"></a>Creating Storage Checkpoints</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397071"></a>This operation creates a Storage Checkpoint (point-in-time image) of the database instance. A Storage Checkpoint for a database is a collection of Storage Checkpoints created at the same time on each of the file systems where the database files reside.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397072"></a>It is recommended that you take a Storage Checkpoint after you convert to or from Quick I/O files.</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="397076"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Enable <font face="Courier New, Courier, sansserif, sans serif" size="2">ARCHIVELOG</font> mode before taking Storage Checkpoints. See <a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html#397069">Creating Storage Checkpoints</a> and <a href="oracle_hp_ch8storageckpts_sf_dbag76_139653.html#139653">Using Storage Checkpoints and Storage Rollback</a>.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397093"></a>The database can be offline or online when a Storage Checkpoint is created. If the database is online when the Storage Checkpoint is created, VxDBA switches the database to online<em> </em>backup mode before creating the Storage Checkpoint. Once the Storage Checkpoint is created, VxDBA 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="397095"></a>In addition to creating a Storage Checkpoint, VxDBA also 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>

<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="397096"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">VxDBA does not automatically roll back the control file associated with a Storage Checkpoint. See <a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html#397420">Rolling Back the Database to a Storage Checkpoint</a> for more information on rolling back control files and <a href="oracle_hp_ch8storageckpts_sf_dbag83_142213.html#142213">Guidelines for Oracle Recovery</a> for information on Oracle recovery.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397115"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Create New Storage Checkpoints</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption1"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba27_t.htm">
<img src="images/oracle_hp_ch13vxdba27.gif" width="110" height="140" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<a name="no_figure_caption2"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba29_t.htm">
<img src="images/oracle_hp_ch13vxdba29.gif" width="110" height="28" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->






<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397166"></a>Displaying Storage Checkpoints</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397168"></a>This operation displays the list of Storage Checkpoints created by the VxDBA utility on the file systems used by the Oracle instance. VxDBA also asks if you want to display Storage Checkpoints created by other applications, such as Capacity Planning Utility or NetBackup.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397169"></a>While you see and manage only a single Storage Checkpoint, the Storage Checkpoint is a collection of Storage Checkpoints. Each file system used by the database contains a Storage Checkpoint of the same name, and it is this collection of Storage Checkpoints across file systems that you manage as a single Storage Checkpoint in VxDBA.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397170"></a>Storage Checkpoints are of the following types:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397171"></a>ON&#8211;Online</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397172"></a>OF&#8211;Offline</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397173"></a>IN&#8211;Instant</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397174"></a>UN&#8211;Unknown</font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397175"></a>Storage Checkpoints may have additional status appended to show other attributes. Current additional status modifiers are:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397176"></a>M&#8211;Mounted</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397177"></a>R&#8211;Read-only</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397178"></a>W&#8211;Writable</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397179"></a>I&#8211;Invalid for current Oracle SID</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397180"></a>C&#8211;Complete</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397181"></a>P&#8211;Partial</font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397182"></a>The status of a Storage Checkpoint can be 'C' for Complete or 'P' for partial. Complete means that the Storage Checkpoint successfully completed across all file systems used by the database, and each file system contains the same Storage Checkpoint name. Partial means that the Storage Checkpoint operation did not successfully complete or that one or more of the file systems used by the database does not contain the named Storage Checkpoint. Partial Storage Checkpoints can happen if, for example:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397184"></a>You are in the middle of creating a new Storage Checkpoint and the database or system crashes. When the system or database is back online, VxDBA detects that not all of the file systems used by the database contain the named Storage Checkpoint.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397185"></a>You should consider deleting partial Storage Checkpoints that are a result of a database or system crash, and create a new Storage Checkpoint.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397187"></a>After taking a successful, complete Storage Checkpoint, you add a tablespace on a new file system or a file system that was not previously used by the database. Again, VxDBA detects that not all of the file systems used by the database contain the named Storage Checkpoint. In this case, you can use the partial Storage Checkpoint for Storage Rollback, but only datafiles on file systems that contain complete Storage Checkpoints can be rolled back.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397188"></a>Be sure you understand the ramifications of rolling back to such a Storage Checkpoint (for example, losing the new tablespace). See the <em>Oracle Backup and Recovery Guide</em> for information and tips on restoring databases from an old backup.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397192"></a>One of the file systems used by your database runs out of space and VxFS automatically removes the oldest Storage Checkpoint on that file system. VxDBA detects that the Storage Checkpoint on that file system is missing and marks the Storage Checkpoint as partial. Here again, you may be able to use the partial Storage Checkpoint for Storage Rollback, but do consider the ramifications of doing so.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397194"></a>To avoid this situation, use VxDBA's Monitoring Agent to monitor file system space usage on all file systems used by the database and allow VxDBA to automatically grow the file systems when they are running out of space. See <a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html#397877">Managing File System Space</a> for more information.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397206"></a>One or more of the file systems used by the database are not VxFS file systems and, therefore, do not support Storage Checkpoints. VxDBA detects that one or more file system Storage Checkpoints are missing and marks the Storage Checkpoint as partial.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397208"></a>Avoid using mixed file systems in support of databases when possible.</font>
</blockquote>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397209"></a>Mounted means that the Storage Checkpoint is currently mounted. Writable means that the Storage Checkpoint has been modified, by <font face="Courier New, Courier, sansserif, sans serif" size="2">fsck</font> or by being mounted as read-write, and is not suitable for Storage Rollback operations.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397210"></a>Ordering of the displayed Storage Checkpoints is by default from most recently created to least recently created. This ordering may not be intuitive, especially if you want to keep the existing list items in the same order. If you need to modify this ordering, set the VXDBA_CKPT_SORT environment variable. The default ordering for sorting Storage Checkpoint names is &quot;-r&quot; (most to least recent). By setting this variable to another sort option, the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Status</b></font> field identifies if the Storage Checkpoint is partial (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">P</font>), complete (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">C</font>), invalid (I), mounted (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">M</font>), read-only (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">R</font>), or writable (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">W</font>).</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397213"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display Storage Checkpoints</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption3"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba31_t.htm">
<img src="images/oracle_hp_ch13vxdba31.gif" width="110" height="85" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->






<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397238"></a>Mounting Storage Checkpoints</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397240"></a>This operation lets you mount a Storage Checkpoint. You can mount, access, and write to Storage Checkpoints just as you can 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>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397250"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Mount Storage Checkpoints</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption4"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba33_t.htm">
<img src="images/oracle_hp_ch13vxdba33.gif" width="110" height="115" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<a name="no_figure_caption5"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba35_t.htm">
<img src="images/oracle_hp_ch13vxdba35.gif" width="110" height="48" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397300"></a></font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397302"></a>Unmounting Storage Checkpoints</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397304"></a>This operation lets you unmount a previously mounted Storage Checkpoint. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397305"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Unmount Storage Checkpoints</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption6"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba37_t.htm">
<img src="images/oracle_hp_ch13vxdba37.gif" width="110" height="79" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397332"></a></font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397335"></a>Removing Storage Checkpoints</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397337"></a>This operation removes 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>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397339"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Remove Storage Checkpoints</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption7"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba39_t.htm">
<img src="images/oracle_hp_ch13vxdba39.gif" width="110" height="120" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<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="397374"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">When you remove Storage Checkpoints created by NetBackup, remember to restart the backup schedule. Also remember that NetBackup needs two Storage Checkpoints to perform an incremental backup. If you remove Storage Checkpoints needed for incremental backups, NetBackup will perform a full backup instead of an incremental backup.
</font>
<hr noshade size="2" width="100%" color="#000000">



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="397376"></a>Managing Storage Rollback</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397378"></a>Use the<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Rollback Administration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu to roll back a database file, a list of database files, a single tablespace, or the entire database 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="397379"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You must be the Oracle Database Administrator to perform Storage Rollback operations. You must shut down the instance to perform full Storage Rollback of the database, or you can elect to leave the database up to roll back a file or tablespace. In this situation, VxDBA checks to see if the target database objects are offline before proceeding. See <a href="oracle_hp_ch8storageckpts_sf_dbag77_140160.html#140160">Using Storage Checkpoints and Storage Rollback for Backup and Restore</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="397398"></a>This operation displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption8"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba41_t.htm">
<img src="images/oracle_hp_ch13vxdba41.gif" width="111" height="76" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397416"></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>

<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="397417"></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, will 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/$ORACLE_SID/checkpoint_dir/CKPT_NAME</font> directory just after a Storage Checkpoint is created. You can use this file to assist with database recovery, if necessary. If possible, both an ascii 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/$ORACLE_SID/checkpoint_dir/CKPT_NAME</font> 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">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397418"></a>After the files are rolled back, you may need to follow the recovery procedure described in the Oracle manuals to recover the database before the database can be used.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397420"></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="397422"></a>This operation rolls back the entire database (all the datafiles used by the database, except the redo logs and control files) to a Storage Checkpoint. You must shut down the database to roll back the database.</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="397424"></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">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397425"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back the Database to a Storage Checkpoint</b></font> displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption9"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba43_t.htm">
<img src="images/oracle_hp_ch13vxdba43.gif" width="110" height="103" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<a name="no_figure_caption10"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba45_t.htm">
<img src="images/oracle_hp_ch13vxdba45.gif" width="110" height="43" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397473"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397474"></a>VxDBA first displays a list of Storage Checkpoints for selection. After a Storage Checkpoint is selected, VxDBA rolls back every database file in parallel. Parallel Storage Rollback significantly reduces the time required to roll back a database.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397478"></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="397479"></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 tablespace 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="397481"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">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_appAcli_sf_dbag153_165980.html#165980">Cloning the Oracle Instance Using dbed_clonedb</a> for more information.
</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="397491"></a>&nbsp;&nbsp;<b>If the database is offline</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397492"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back a Tablespace to a Storage Checkpoint</b></font> displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption11"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba47_t.htm">
<img src="images/oracle_hp_ch13vxdba47.gif" width="110" height="98" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397515"></a>VxDBA prompts you for a tablespace name, and then displays a list of Storage Checkpoints:</font>
</p>

<a name="no_figure_caption12"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba49_t.htm">
<img src="images/oracle_hp_ch13vxdba49.gif" width="110" height="109" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397548"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397549"></a>After you select a Storage Checkpoint, VxDBA rolls back the files of the selected tablespace in parallel. Parallel Storage Rollback significantly reduces the time required to roll back a tablespace.</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="397551"></a>&nbsp;&nbsp;<b>If the database is online</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397552"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back a Tablespace to a Storage Checkpoint</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption13"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba50_t.htm">
<img src="images/oracle_hp_ch13vxdba50.gif" width="110" height="118" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397580"></a>VxDBA prompts you for a tablespace name, and then displays a list of Storage Checkpoints:</font>
</p>

<a name="no_figure_caption14"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba51_t.htm">
<img src="images/oracle_hp_ch13vxdba51.gif" width="110" height="122" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397617"></a>After you select a Storage Checkpoint, VxDBA rolls back the files of the selected tablespace in parallel. Parallel Storage Rollback significantly reduces the time required to roll back a tablespace.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397620"></a>Rolling Back Datafiles to a Storage Checkpoint</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397622"></a>This operation rolls back database files to a Storage Checkpoint. You can also use this operation to roll back more than one tablespace. Specify the list of files for Storage Rollback in a list file, or enter the list of files one by one. If the database is offline <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back Files to a Storage Checkpoint</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following: </font>
</p>

<a name="no_figure_caption15"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba52_t.htm">
<img src="images/oracle_hp_ch13vxdba52.gif" width="110" height="101" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<a name="no_figure_caption16"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba53_t.htm">
<img src="images/oracle_hp_ch13vxdba53.gif" width="110" height="97" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397682"></a>After you select a Storage Checkpoint, VxDBA rolls back the files to the selected Storage Checkpoint in parallel. Parallel Storage Rollback significantly reduces the time required to roll back files. When all the files are rolled back, follow the Oracle recovery procedure to recover the database before the database is used.</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="397685"></a>&nbsp;&nbsp;<b>If the database is online</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397686"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Roll Back Files to a Storage Checkpoint</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following: </font>
</p>

<a name="no_figure_caption17"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba54_t.htm">
<img src="images/oracle_hp_ch13vxdba54.gif" width="110" height="135" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<a name="no_figure_caption18"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba55_t.htm">
<img src="images/oracle_hp_ch13vxdba55.gif" width="110" height="97" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397759"></a>After you select a Storage Checkpoint, VxDBA rolls back the files to the selected Storage Checkpoint in parallel. Parallel Storage Rollback significantly reduces the time required to roll back files. When all the files are rolled back, follow the Oracle recovery procedure to recover the database before the database is used.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397763"></a>Setting the Number of Storage Rollback Threads</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397765"></a>This operation lets you configure the number of threads used when rolling back an Oracle datafile. Performance is a critical factor when rolling a file back to a Storage Checkpoint. By default, 8 lightweight threads are used to partition up and recover a datafile. 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>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397766"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Set Number of Storage Rollback Threads</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following: </font>
</p>

<a name="no_figure_caption19"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba56_t.htm">
<img src="images/oracle_hp_ch13vxdba56.gif" width="110" height="49" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397783"></a>This menu option lets you experiment with various settings to achieve optimal performance for your system. You do not need to change the default number of threads if the Storage Rollback performance on your system is satisfactory. The maximum number of threads you can set is 63, and the minimum number of threads is 1.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397787"></a>Setting the Buffer Size for Storage Rollback</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397789"></a>This operation lets you configure the buffer size used for Storage Rollback. As with setting the number of Storage Rollback threads, the buffer size configured for reads and writes when rolling back an Oracle datafile can also affect performance. By default, a 128K read/write buffer is used.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397790"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Set Buffer Size for Storage Rollback</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption20"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdbaa2_t.htm">
<img src="images/oracle_hp_ch13vxdbaa2.gif" width="110" height="58" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397809"></a>This menu option lets you experiment with various settings to gain optimal performance for your system. You do not need to change the default buffer size if the Storage Rollback performance on your system is satisfactory. Set the buffer size in bytes---the minimum buffer size is 1K (1024 bytes), and the maximum buffer size is 1 MB (1,048,576 bytes).</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397811"></a>Showing the Backup Control File List</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397813"></a>This operation displays the list of control files that VxDBA has backed up each time you create a Storage Checkpoint using VxDBA.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397814"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Show Backup Control File List</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption21"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdbaa4_t.htm">
<img src="images/oracle_hp_ch13vxdbaa4.gif" width="110" height="53" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397832"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397833"></a>Following the location of the backup control file, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Show Backup Control File List</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays the following information:</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397834"></a><b> DB UP?</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397835"></a>Shows the status of the Oracle instance (<font face="Courier New, Courier, sansserif, sans serif" size="2">Y</font> for <font face="Courier New, Courier, sansserif, sans serif" size="2">ONLINE</font> or <font face="Courier New, Courier, sansserif, sans serif" size="2">N</font> for <font face="Courier New, Courier, sansserif, sans serif" size="2">OFFLINE</font>) when the Storage Checkpoint was taken. When a Storage Checkpoint is created while the Oracle instance is up, the control files, initialization file, and the log information are backed up at the same time. However, if a Storage Checkpoint is created while the Oracle instance is down, the log information will not be available. If this backed up information is removed from the Storage Checkpoint directory, the status of the <font face="Courier New, Courier, sansserif, sans serif" size="2">INIT&amp;CNTL?</font> field becomes <font face="Courier New, Courier, sansserif, sans serif" size="2">N</font> (for null).</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397836"></a><b> CKPT?</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397837"></a>Shows whether the same Storage Checkpoint still exists across all file systems used by the database (see the discussion of partial Storage Checkpoints in <a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html#397166">Displaying Storage Checkpoints</a> for more information). When one or more of the file systems used by the database does not contain the named Storage Checkpoint, the status of <font face="Courier New, Courier, sansserif, sans serif" size="2">CKPT?</font> becomes <font face="Courier New, Courier, sansserif, sans serif" size="2">n</font> (for null).</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="397847"></a><b> INIT&amp; CNTL.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397848"></a>Shows whether the Oracle instance initialization file and the backup control file still exist in the Storage Checkpoint directory. If this backed up information is removed from the Storage Checkpoint directory, the status of the <font face="Courier New, Courier, sansserif, sans serif" size="2">INIT&amp;&nbsp;CNTL?</font> field becomes <font face="Courier New, Courier, sansserif, sans serif" size="2">N</font> (for null).</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="397849"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If you need to recover the database from structural changes, these backup control files may be required to effect the recovery. Storage Rollback does not automatically determine whether this is the case, as usage depends on the Oracle recovery that the administrator intends to perform. If it is determined that a backup control file is required for recovery, it can be copied from the directory location shown in the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Backup Control File</b></font> field of the above display. 
</font>
<hr noshade size="2" width="100%" color="#000000">



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="397851"></a>Managing Space Usage and the VxDBA Monitoring Agent</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397852"></a>Use the<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Monitoring Agent Administration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu to:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397853"></a>Manage and monitor VxFS file system, Oracle tablespace, and datafile space usage</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397854"></a>Configure the Monitoring Agent options and statistics collection</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397855"></a>Start and stop the Monitoring Agent </font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397857"></a>This operation displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption22"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdbaa6_t.htm">
<img src="images/oracle_hp_ch13vxdbaa6.gif" width="110" height="56" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->






<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397877"></a>Managing File System Space</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397879"></a>The VxDBA Monitoring Agent monitors the file system space, and when the space usage reaches a configured threshold value, a predefined action script grows the file system automatically. The agent can be enabled or disabled to start at boot-time. Each file system monitored has three settings that the Monitoring Agent needs to know about:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397881"></a><em>Warning Threshold</em> is a percent value (% of file system utilized) that determines when the agent begins warning the administrator of space shortage</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397882"></a><em>Grow Threshold</em> is a percent value (% of file system utilized) that determines when the agent is to attempt to grow the file system (when space usage is at a critical level)</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397883"></a><em>Amount</em> is either a percentage or a value in megabytes by which to grow file systems when the Grow Threshold is reached or exceeded</font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397884"></a>The VxDBA Monitoring Agent operations are driven from the following files:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397890"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/opt/VRTSdbed/lib/dbed_mon_config.base</font></font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397891"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/dbed_mon_config.$ORACLE_SID</font></font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397892"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/dbed_mon_fslist.$ORACLE_SID</font></font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397893"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/dbed_mon_oralist.$ORACLE_SID</font></font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397894"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/include</font></font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397895"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">/opt/VRTSdbed/lib/dbed_mon_config.base</font> file contains the site-level configuration settings for monitoring all file systems and databases recognized. This configuration file specifies how often to check for file system and database configuration changes, how often to check the file space usage, where space usage information gets logged, and the thresholds for warning and automatically growing the file system. By default, the monitoring agent log file is located under the <font face="Courier New, Courier, sansserif, sans serif" size="2">/var/log/dbed_mon</font> directory.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397897"></a>During file system and database configuration, the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_mon_config.base</font> file gets copied into each database-specific directory as the file <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/ORACLE_SID&nbsp;<br>dbed_mon_config.$ORACLE_SID</font>. For example, if you are monitoring a database named <font face="Courier New, Courier, sansserif, sans serif" size="2">PROD</font>, the database-specific file would be <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/PROD/dbed_mon_config.PROD</font>. This is the first file opened when the agent is started and contains the default settings for monitoring file systems at the database level. The VxDBA Monitoring Agent cannot start without this file. Modify this configuration file if you want to change the preconfigured settings carried over from the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_mon_config.base</font> file to maintain a different set of settings at the database level.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397899"></a>The following two files: </font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397900"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/ORACLE_SID/dbed_mon_fslist.$ORACLE_SID</font></font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397902"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/dbed_mon_oralist.$ORACLE_SID</font></font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397904"></a>are created by the VxDBA utility and are used for restarting the VxDBA Monitoring Agent. These files specify the status of the database. The files also specify the space monitoring and alarm information for each file system, tablespace, and datafile. You can edit these files manually to change settings, and then use VxDBA to restart the Monitoring Agent. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397905"></a>The VxDBA Monitoring Agent uses the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/</font>$ORACLE_SID<font face="Courier New, Courier, sansserif, sans serif" size="2">/include</font> file to check that all files are up-to-date and are being monitored. This file is created by the VxDBA utility and should not be edited.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397906"></a>Occasionally, Monitoring Agents ignore Storage Checkpoints. This happens when a Storage Checkpoint is not owned by the current Oracle instance. These Storage Checkpoints will not be used to calculate thresholds and potential removal candidates. Storage Checkpoints that are not considered part of the current Oracle database instance's data set are logged as such in the file <font face="Courier New, Courier, sansserif, sans serif" size="2">/var/log/dbed_mon/dbed_mon.prune_ckpt_log.$ORACLE_SID&nbsp;</font>when the Monitoring Agent is looking for potential removal candidates. A Storage Checkpoint must have an entry in the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/checkpoint_dir</font> directory before it is considered owned by the database. This is done automatically by the provided VxDBA and <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckpt</font> <font face="Courier New, Courier, sansserif, sans serif" size="2">create</font> utilities and ensures that, if multiple databases share the same file system(s), the policy for one database does not affect another.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397908"></a>Use the<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>File System Space Administration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu to monitor the space usage of the file system and each Storage Checkpoint. You can also use the menu to enable or disable the VxDBA Monitoring Agent. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397909"></a>This operation displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption23"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba8_t.htm">
<img src="images/oracle_hp_ch13vxdba8.gif" width="110" height="65" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397929"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397930"></a>Select from the following File System Space Alarm Administration operations:</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397931"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display File System Space Usage</b></font></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397932"></a>Use this menu option to display file system space usage information and the estimated space used for Storage Checkpoints created by VxDBA.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397933"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397934"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display File System Space Alarm Settings</b></font></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397935"></a>Use this menu option to display the space alarm information on the file systems used by the Oracle instance. The menu operation provides the boot-time status and current status of the VxDBA Monitoring Agent, as well as the list of file systems with their associated space alarm settings and status (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">ENABLED</font> or <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">DISABLED</font>).</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397936"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Enable/Disable/Modify Space Alarm Settings</b></font></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397937"></a>Use this menu option to control the Monitoring Agent activity and modify the current space alarm settings on the file systems used by the Oracle instance.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397938"></a>Displaying File System Space Usage</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397940"></a>This operation displays the space usage of the file system and the Storage Checkpoints used by the Oracle instance. For example, you can use this operation to monitor the daily database change history and use this data for capacity planning to forecast the additional disk space needed for Storage Checkpoints.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397941"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display File System Usage</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption24"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba10_t.htm">
<img src="images/oracle_hp_ch13vxdba10.gif" width="110" height="92" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397965"></a>In this example, the space used by <font face="Courier New, Courier, sansserif, sans serif" size="2">Checkpoint_</font>901426272 is less than 1 MB, which means the Storage Checkpoint does not contain many data blocks. This means that the database has not modified many distinct data blocks since this Storage Checkpoint was created. Another Storage Checkpoint may have been created after this one, with all subsequent changes going to the new Storage Checkpoint.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="397966"></a>Displaying File System Space Alarm Settings</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397968"></a>This operation displays the information about the space alarm settings defined for the file systems used by the Oracle instance. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397970"></a>The space alarm relies on the VxDBA Monitoring Agent. The agent daemon processes must be running first. If the agent daemons are not running, a message is displayed asking you to start the agent daemons.</font>
</p>

<a name="no_figure_caption25"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba12_t.htm">
<img src="images/oracle_hp_ch13vxdba12.gif" width="110" height="96" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398008"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398009"></a>After you start the VxDBA Monitoring agent,<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display File System Space Alarm Settings</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays the list of file systems and the space alarm status:</font>
</p>

<a name="no_figure_caption26"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba14_t.htm">
<img src="images/oracle_hp_ch13vxdba14.gif" width="110" height="103" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398050"></a></font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="398052"></a>Enabling, Disabling, or Modifying Space Alarm Settings</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398055"></a>When the file system runs out of space, VxFS automatically removes Storage Checkpoints to free up space. This could happen when Oracle is processing update transactions such that original data blocks are saved in the Storage Checkpoints. Enabling the space alarm allows VxDBA to monitor space usage and grow the file systems automatically, so that Storage Checkpoints are not unnecessarily removed.</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="398058"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Only users with superuser (<font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>) privileges can perform this operation.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398060"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Enable/Disable/Modify Space Alarm Settings</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>operation first checks to see if you are logged in as <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>. If you are not logged in as <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>, VxDBA prompts you for the <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font> password: </font>
</p>

<a name="no_figure_caption27"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba16_t.htm">
<img src="images/oracle_hp_ch13vxdba16.gif" width="110" height="43" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398075"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398076"></a>After you enter the <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font> password, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Enable/Disable/Modify Space Alarm Settings</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption28"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba18_t.htm">
<img src="images/oracle_hp_ch13vxdba18.gif" width="110" height="70" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398099"></a></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="398100"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">When you run VxDBA operations as <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>, VxDBA cannot connect to and obtain information directly from the database, so the submenu <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Database Status</b></font> header reports a permission error, and the number of tablespaces and datafiles are enclosed in parentheses. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398102"></a>Select from the following file system space alarm operations:</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398103"></a><b> Enable or Disable Boot-Time Start of Monitoring Agent.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398104"></a>Use this menu option to change the boot-time start activity of the VxDBA Monitoring Agent. You are provided with the current setting (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">ENABLED</font> or <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">DISABLED</font>), and then prompted for changes.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398106"></a><b> While this is not recommended, you can disable the boot-time start activity of the VxDBA Monitoring Agent that monitors the space usage of the file systems used by the Oracle instance.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398107"></a></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="398108"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If the space alarm is disabled and a file system that contains Storage Checkpoints runs out of space, VxFS removes Storage Checkpoints to free up the space.
</font>
<hr noshade size="2" width="100%" color="#000000">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398112"></a><b> Set Monitoring/Expansion Policy for All File Systems.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398113"></a>Use this menu option to configure the monitoring and expansion policy for all file systems. You are prompted for the Warning Threshold for space usage, the Grow Threshold for space usage, and the Amount as a percentage or a value in megabytes by which to grow the file system. These three policy values are then used for all file systems unless a per file system policy is set.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398116"></a><b> Set Monitoring/Expansion Policy Per File System</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398117"></a>Use this menu option to configure the monitoring and expansion policy for a particular file system. After displaying the current policy per file system, you are asked if you want to change the policies and are then prompted for the new values for the Warning Threshold for space usage, the Grow Threshold for space usage, and the Amount as a percentage or a value in megabytes by which to grow the file system. If you want to disable monitoring of a particular file system, set the Grow Threshold and the amount to Grow By values to zero. By default, the expansion of file systems is disabled and must be enabled by the user.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398119"></a><b> Re-Read Configuration File for Monitoring Agent</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398120"></a>Use this menu option to re-read the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SI</font><font face="Courier New, Courier, sansserif, sans serif" size="2">D</font><font face="Courier New, Courier, sansserif, sans serif" size="2">/dbed_mon_fslist.$ORACLE_SID</font> file. Select this operation if you manually edit this file.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398122"></a><b> Start/Stop Monitoring Agent</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398123"></a>Use this menu option to start or stop the monitoring agent. After displaying the current status of the Monitoring Agent (running or not running), you can either start or stop the Monitoring Agent.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="398124"></a>Managing Oracle Tablespace and Datafile Space</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398125"></a>Use the<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Oracle Tablespace/DatafileSpace Administration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu to monitor the space usage of Oracle tablespaces and datafiles, and to display or modify the VxDBA Monitoring Agent's Oracle space alarm settings. You can also use the menu to enable or disable the VxDBA Monitoring Agent.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398126"></a>This operation displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption29"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba20_t.htm">
<img src="images/oracle_hp_ch13vxdba20.gif" width="110" height="70" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398145"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398146"></a>Select from the following File System Space Alarm Administration operations:</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398147"></a><b> Display Oracle Tablespace/Datafile Space Usage.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398148"></a>Use this menu option to display datafile space usage information. Total size of Oracle objects, free space available, and Oracle blocks are displayed. Oracle objects and free space available are given in MB.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398149"></a><b> Display Oracle Tablespace/Datafile Space Alarm Settings</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398150"></a>Use this menu operation to display the space alarm information on the Oracle tablespaces. The menu display provides the boot-time and current status of the VxDBA Monitoring Agent and the list of Oracle tablespaces with their associated space alarm settings and status (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">ENABLED</font> or <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">DISABLED</font>).</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398151"></a><b> Enable/Disable/Modify Space Alarm Settings</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398152"></a>Use this menu option to change the boot-time start activity of the VxDBA Monitoring Agent. You are provided with the current setting (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">ENABLED</font> or <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">DISABLED</font>), and then prompted for changes.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="398153"></a>Displaying Oracle Tablespace/Datafile Space Usage</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398155"></a>This operation displays the space usage of Oracle tablespaces, datafiles, and the Storage Checkpoints used by the Oracle instance. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398156"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display Oracle Tablespace/Datafile Space Usage</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption30"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba22_t.htm">
<img src="images/oracle_hp_ch13vxdba22.gif" width="110" height="127" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->






<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="398207"></a>Displaying Oracle Tablespace/Datafile Space Alarm Settings</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398209"></a>This operation displays the information about the space alarm settings defined for the Oracle tablespaces and datafiles.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398211"></a>The space alarm relies on the VxDBA Monitoring Agent. The agent daemon processes must be running first. If the agent daemons are not running, a message is displayed asking you to start the agent daemons.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398212"></a>The expansion of Oracle Tablespaces is not currently supported. The display for settings on the grow threshold and the grow amount always shows N/A.</font>
</p>

<a name="no_figure_caption31"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba24_t.htm">
<img src="images/oracle_hp_ch13vxdba24.gif" width="110" height="100" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398251"></a>Once you start the VxDBA Monitoring agent,<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display Oracle Tablespace/Datafile /</b></font> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Space Alarm Settings</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays the list of tablespaces and datafiles and the space alarm status:</font>
</p>

<a name="no_figure_caption32"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba26_t.htm">
<img src="images/oracle_hp_ch13vxdba26.gif" width="110" height="126" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->






<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="398305"></a>Enabling, Disabling, or Modifying Oracle Space Alarm Settings</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398307"></a>Enabling the Oracle space alarm allows VxDBA to monitor tablespace and datafile   space usage. The warning is sent to the log file </font>
</p>

<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398308"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/var/log/dbed_mon/dbed_mon.logfile.$ORACLE_SID&nbsp;</font></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="398310"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Only users with superuser (<font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>) privileges can perform this operation.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398312"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Enable/Disable/Modify Oracle </b></font> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Space Alarm Settings</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>operation first checks to see if you are logged in as <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>. If you are not logged in as <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>, VxDBA prompts you for the <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font> password: </font>
</p>

<a name="no_figure_caption33"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba28_t.htm">
<img src="images/oracle_hp_ch13vxdba28.gif" width="110" height="45" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398326"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398327"></a>After you enter the <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font> password, <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Enable/Disable/Modify Space Alarm Settings</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption34"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba30_t.htm">
<img src="images/oracle_hp_ch13vxdba30.gif" width="110" height="73" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<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="398349"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">When you run VxDBA operations as <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>, VxDBA cannot connect to and obtain information directly from the database, so the submenu <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Database Status</b></font> header reports a permission error, and the number of tablespaces and datafiles are enclosed in parentheses. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398350"></a>Select from the following Oracle space alarm operations:</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398351"></a><b> Enable or Disable Boot-Time Start of Monitoring Agent.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398352"></a>Use this menu option to change the boot-time start activity of the monitoring agent. The message provides you with the current setting and prompts you for changes.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398353"></a><b> Set Monitoring/Expansion Policy for All Oracle Tablespaces</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398354"></a>Use this menu option to configure the monitoring policy for all Oracle tablespaces. The menu prompts you for the Warning Threshold for space usage. </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="398355"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The expansion of Oracle Tablespaces is not currently supported. No option to modify settings for the grow threshold or grow amount is available.
</font>
<hr noshade size="2" width="100%" color="#000000">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398358"></a><b> Set Monitoring Policy Per Oracle Tablespaces</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398359"></a>Use this menu option to configure the monitoring policy for a particular Oracle tablespace. After displaying the current policy per Oracle tablespace, the program asks if you want to change the policies and then prompts you for the new values for the Warning Threshold.</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="398360"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The expansion of Oracle Tablespaces is not currently supported. No option to modify settings for the grow threshold or grow amount is available.
</font>
<hr noshade size="2" width="100%" color="#000000">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398361"></a><b> Re-Read Configuration File for Monitoring Agent</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398362"></a>Use this menu option to re-read the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/dbed_mon_oralist.$ORACLE_SID&nbsp;</font> file. Select this operation if you manually edited this file.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="398364"></a><b> Start/Stop Monitoring Agent</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398365"></a>Use this menu option to start or stop the monitoring agent. </font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="398368"></a>Configuring Monitoring Agent Options</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398369"></a>Use this menu operation to modify current default settings for the Monitoring Agent. The agent configuration is saved under the following:</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398370"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID/dbed_mon_config.$ORACLE_SID</font></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="398371"></a>When the configuration file is modified, restart the Monitoring Agent for the changes to take effect. This operation displays a screen similar to the following:</font>
</p>

<a name="no_figure_caption35"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba32_t.htm">
<img src="images/oracle_hp_ch13vxdba32.gif" width="111" height="73" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<a name="no_figure_caption36"> </a>  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba34_t.htm">
<img src="images/oracle_hp_ch13vxdba34.gif" width="110" height="97" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<a name="no_figure_caption37"> </a>	  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="oracle_hp_ch13vxdba36_t.htm">
<img src="images/oracle_hp_ch13vxdba36.gif" width="110" height="118" border="0" ></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->




<!-- 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_ch13vxdba_sf_dbag131_397037.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_ch13vxdba_sf_dbag130_396536.html" title="Previous - Using VxDBA to Perform Administrative Operations">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch13vxdba_sf_dbag132_398516.html" title="Next - Configuring Statistics Collection">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>
