<!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>Using VxDBA to Perform Administrative Operations</title>

</HEAD>

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

<a name="396536"></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_dbag129_396363.html" title="Previous - Starting VxDBA">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html" title="Next - Managing Storage Checkpoints">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
   </td>
 </tr>

 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_dbag_splashpage_docCD_sf_dbag1_103036.vxhd" title="Storage Foundation for Databases Guides title page ">Storage Foundation for Databases Guides</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>
 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="oracle_hp_dbag_titlepage_docCD_sf_dbag2_73700.vxhd" title="Storage Foundation 4.1 for Oracle Administrator's Guide title page ">Storage Foundation 4.1 for Oracle Administrator's Guide</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>


</table>
</div>

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

<!-- Start Main Topic Content -->
        <a name="startcontent"></a>
	
<h1><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="+1" color="#000000"><a name="396536"></a>Using VxDBA to Perform Administrative Operations</font>
</h1>
 
  
  
  

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396537"></a>The rest of this chapter details the administrative operations available through the VxDBA utility.</font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="396539"></a>Managing Your Database</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396541"></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>Database Administration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu to perform basic database operations.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396542"></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_ch13vxdbaa3_t.htm">
<img src="images/oracle_hp_ch13vxdbaa3.gif" width="110" height="67" 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="396566"></a>Select from the following operations:</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396567"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Startup Database Instance</b></font>&#8211;Use this menu option to start up the database.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396568"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Shutdown Database Instance</b></font>&#8211;Use this menu option to shut down the database.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396569"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Display/Update Tablespace Information</b></font>&#8211;Use this menu option to update the tablespaces of an Oracle instance and their associated datafiles.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="396572"></a>Starting Up a Database Instance</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396575"></a>The VERITAS Storage Foundation <em>for Oracle</em> software package includes adaptable scripts that are run automatically when starting the database using the VxDBA utility. You can modify these scripts to run other tools and applications or to start and stop other services before and/or after database startup. For example, you could modify the scripts to ensure the database TCP listener is also correctly started. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396577"></a>The following scripts are included in the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/</font><font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_SID</font> directory:</font>
</p>

<p>
<ul type="disc"><p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396579"></a>startup.pre</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396581"></a>startup.post</font>
</li>
</ul>
</p>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396583"></a>These scripts are copied from the system-wide default files, located in <font face="Courier New, Courier, sansserif, sans serif" size="2">/opt/VRTSdbed/lib</font> directory:</font>
</p>

<p>
<ul type="disc"><p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396585"></a>startup.pre.base</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396587"></a>startup.post.base</font>
</li>
</ul>
</p>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396589"></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>Startup Database Instance</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to bring the Oracle instance online. You must define the <font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_SID</font> and <font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_HOME</font> environment variables before attempting to start up the database instance.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396591"></a>This operation 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_ch13vxdbaa5_t.htm">
<img src="images/oracle_hp_ch13vxdbaa5.gif" width="110" height="68" 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="396630"></a>Shutting Down a Database Instance</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396633"></a>The VERITAS Storage Foundation <em>for Oracle</em> software package includes adaptable scripts that are automatically run when stopping the database using the VxDBA utility. You can modify these scripts to run other tools and applications or to start and stop other services before and/or after database shutdown. For example, you could modify the scripts to ensure the database TCP listener is also correctly stopped. The following scripts are included in the <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/ORACLE_SID</font> directory:</font>
</p>

<p>
<ul type="disc"><p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396636"></a>shutdown.pre</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396638"></a>shutdown.post</font>
</li>
</ul>
</p>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396640"></a>These scripts are copied from the system-wide default files, located in the <font face="Courier New, Courier, sansserif, sans serif" size="2">/opt/VRTSdbed/lib</font> directory:</font>
</p>

<p>
<ul type="disc"><p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396642"></a>shutdown.pre.base</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396644"></a>shutdown.post.base</font>
</li>
</ul>
</p>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396646"></a>To perform some administrative tasks (for example, Storage Rollback), the database must be offline. Use the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Shutdown Database Instance</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to bring the database instance down. </font>
</p>

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

<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_ch13vxdbaa7_t.htm">
<img src="images/oracle_hp_ch13vxdbaa7.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="396667"></a>Select from the following shutdown methods:</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396668"></a><b> Shutdown NORMAL</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396669"></a>Use this menu option to shut down the Oracle instance in normal situations. When this operation is selected, no new database connections are allowed. Oracle waits for all currently connected users to disconnect from the database, and then closes and dismounts the database before shutting down the instance. The next database startup does not require an instance recovery.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396672"></a><b> Shutdown TRANSACTIONAL</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396673"></a>Use this menu option to shut down the Oracle instance immediately upon completion of all transactions in progress. When this operation is selected, no client can start a new transaction on this instance, and a client is disconnected when the transaction in progress ends. The next database startup does not require an instance recovery.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396674"></a><b> Shutdown IMMEDIATE</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396675"></a>Use this menu option to shut down the Oracle instance immediately. Use this operation in situations where the database or some application is running irregularly or a power shutdown is about to occur. When this operation is selected, all current client SQL statements are terminated immediately, any uncommitted transactions are rolled back, and all connected users are disconnected. Oracle closes and dismounts the database before shutting down the instance. The next database startup does not require an instance recovery.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396676"></a><b> Shutdown ABORT</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396677"></a>Use this menu option to shut down the Oracle instance instantaneously by aborting the database's instance. Use this operation with extreme caution and only when normal shutdown or immediate shutdown does not work, you experience problems when starting the instance, or you need to shut down the instance instantaneously. When this operation is selected, all connected users are disconnected, current client SQL statements are terminated immediately, uncommitted transactions are not rolled back, and the instance is terminated without closing the files. The next database startup requires instance recovery. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396678"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Shutdown NORMAL</b></font> operation 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_ch13vxdba9_t.htm">
<img src="images/oracle_hp_ch13vxdba9.gif" width="110" height="52" 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_caption4"> </a>

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

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396713"></a>After the Oracle instance is shut down, VxDBA displays 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>Database Administration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu.</font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="396715"></a>Displaying Database/VxDBA Information</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396716"></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>Display Database/VxDBA Information</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to display information about various aspects of your database environment.</font>
</p>

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

<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_ch13vxdba11_t.htm">
<img src="images/oracle_hp_ch13vxdba11.gif" width="110" height="62" 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="396734"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396735"></a>Select from the following operations:</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396736"></a><b> Display Database Information.</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396737"></a>Use this menu option to display the database instance and status information.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396738"></a><b> Display/Update Tablespace Information</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396739"></a>Use this menu option to display and update the tablespaces of Oracle instance and their associated datafiles.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396740"></a><b> Display Datafile/File System Information</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396742"></a>Use this menu option to display the list of database files and the file systems used by the Oracle instance.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396743"></a><b> Display VxDBA/Database Configuration Files</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396744"></a>Use this menu option to display and view the contents of various VxDBA and Oracle configuration files.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396745"></a><b> Examine Volume/File System/Database Configuration</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396746"></a>Use this menu option to display general system configuration and database information, such as Quick I/O files, disk groups, control files, datafiles, and the layout and version of the file systems.</font>
</p>

<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="396747"></a><b> Save Volume/File System/Database Configuration</b>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396748"></a>Use this menu option to save important system hardware, operating system, kernel tunables, database layout and control files, volume and file system configuration, packaging, and license information.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="396749"></a>Displaying Database Information</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396751"></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>Display Database Information</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to display the Oracle instance name (<font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_SID</font>), the Oracle home directory path (<font face="Courier New, Courier, sansserif, sans serif" size="2">$ORACLE_HOME</font>), and the status of the Oracle instance.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396754"></a>This operation 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_ch13vxdba13_t.htm">
<img src="images/oracle_hp_ch13vxdba13.gif" width="110" 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="396775"></a></font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396776"></a>If the display screen has been idle for a while, the status of the Oracle instance may have changed. Use the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Refresh Status</b></font> option to refresh the display with the up-to-date status of the Oracle instance.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="396781"></a>Displaying and Updating Tablespace Information</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396783"></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>Display/Update Tablespace Information</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to display the list of tablespaces of an Oracle instance and their associated datafiles. This menu option is also available on the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Database Administration</b></font> menu.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396784"></a>This operation 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_ch13vxdba15_t.htm">
<img src="images/oracle_hp_ch13vxdba15.gif" width="110" height="52" 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="396820"></a>VxDBA maintains a repository that stores the pertinent information needed to display configuration information. This repository is located at <font face="Courier New, Courier, sansserif, sans serif" size="2">/etc/vx/vxdba/$ORACLE_SID</font>. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396821"></a>When the database configuration changes, the information stored in the repository may not be up-to-date. When VxDBA detects that the repository is no longer consistent with Oracle's system catalog, VxDBA asks you if you want to update its repository with the latest configuration information.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="396823"></a>Displaying Datafile and File System Information</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396825"></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>Display Datafile/File System Information</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to display the list of database files and the file systems used by the Oracle instance. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396826"></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_ch13vxdba17_t.htm">
<img src="images/oracle_hp_ch13vxdba17.gif" width="110" height="66" 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_caption9"> </a>

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

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396872"></a>The datafile and file system information is also stored in VxDBA's repository. When the configuration changes, VxDBA updates its repository with the latest configuration information.</font>
</p>




<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="396873"></a>Displaying VxDBA and Database Configuration Files</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396874"></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>Display VxDBA/Database Configuration Files</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to display and then view the contents of various VxDBA and Oracle configuration or script files. </font>
</p>

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

<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_ch13vxdba19_t.htm">
<img src="images/oracle_hp_ch13vxdba19.gif" width="110" height="68" 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="396894"></a>When you select an item from the list, VxDBA first displays the location of the file and then its contents. Use the space bar to page through the file contents. If VxDBA cannot find a configuration file, you will see a <font face="Courier New, Courier, sansserif, sans serif" size="2">(missing)</font> designation after the selection option description.</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="396895"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You cannot edit the configuration files from within VxDBA; you can only view their contents. 
</font>
<hr noshade size="2" width="100%" color="#000000">



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="396896"></a>Examining Database Environment Information</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396898"></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>Examine Volume/File System/Database Configuration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to display system configuration and database information that can assist you in determining if your database is configured properly on top of VERITAS products and the operating system.</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="396902"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">The database must be running in archivelog mode.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396903"></a>By default, only users with superuser (<font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>) privileges have permission to run <font face="Courier New, Courier, sansserif, sans serif" size="2">vxtunefs</font> and <font face="Courier New, Courier, sansserif, sans serif" size="2">vxdisk</font> commands. To allow database administrators to use these commands, you need to change these commands as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="396904"></a>&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>chown&nbsp;root:dba&nbsp;/opt/VRTSvxfs/sbin/vxtunefs</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="396905"></a>&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>chmod&nbsp;4550&nbsp;/opt/VRTSvxfs/sbin/vxtunefs</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="396906"></a>&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>chown&nbsp;root:dba&nbsp;/usr/sbin/vxdisk</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="396907"></a>&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>chmod&nbsp;4550&nbsp;/usr/sbin/vxdisk</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="396908"></a>This operation 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_ch13vxdba21_t.htm">
<img src="images/oracle_hp_ch13vxdba21.gif" width="110" height="75" 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="396967"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">HP-UX does not support Cached Quick I/O. The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Examine Volume/File System/Database Configuration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>output will always show <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_cache_enable&nbsp;=&nbsp;0</font> for HP-UX systems.
</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="396998"></a>Saving Database Environment Information</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397000"></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>Save Volume/File System/Database Configuration</b></font><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b> </b></font>menu option to save important information, such as:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397001"></a>System hardware</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397002"></a>Operating system</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397003"></a>Kernel tunables</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397004"></a>Database layout and control files</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397005"></a>Volume and file system configuration</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397006"></a>Packaging</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397007"></a>License information</font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397008"></a>This option creates a collection of files under a directory you specified. Copy these files to off-host, online storage to assist you in a disaster recovery situation.</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="397009"></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">
<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="397010"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Depending on the configuration and size of your system, this menu option can create sizable files. Make sure you have ample space on your system before selecting this option.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397011"></a>After prompting you for the root password, this operation displays a screen similar to the following:</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="397012"></a>This operation displays a screen similar to the following:</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_ch13vxdba23_t.htm">
<img src="images/oracle_hp_ch13vxdba23.gif" width="107" height="54" 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_dbag130_396536.html" title="Using VxDBA to Perform Administrative Operations">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_dbag129_396363.html" title="Previous - Starting VxDBA">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch13vxdba_sf_dbag131_397037.html" title="Next - Managing Storage Checkpoints">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>
