<!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:36:41">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_appAcli.fm">
     
<title>Identifying VxFS Files to Convert to Quick I/O Using qio_getdbfiles</title>

</HEAD>

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

<a name="168094"></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_appAcli_sf_dbag162_168036.html" title="Previous - Mapping Tablespaces to Disks Using dbed_analyzer">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_appBqiobckup_sf_dbag164_77168.html" title="Next - Appendix:  Using Third-Party Software to Back Up Files">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="168094"></a> Identifying VxFS Files to Convert to Quick I/O Using qio_getdbfiles</font>
</h2>

        
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168096"></a>You can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles </font>command to identify VxFS files before converting them to Quick I/O files. Only VxFS files may be converted to Quick I/O.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168097"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command queries the database and gathers a list of datafiles to be converted to Quick I/O. The command requires direct access to the database.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="168098"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168099"></a>To use this command for Oracle, the <font face="Courier New, Courier, sansserif, sans serif" size="2">ORACLE_SID</font> environment variable must be set. </font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168100"></a>You must be logged in as the Database Administrator.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="168101"></a><b>Usage Notes</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168102"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">-T</font> option forces the behavior for a specific database type. Use this option in environments with more than one type of database. </font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168104"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font>(1M) manual page for more information.</font>
</li>
</ul>
</p>
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="168106"></a>&nbsp;&nbsp;<b>To identify the VxFS files to convert to Quick I/O</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="176544"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command as follows:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="176545"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_getdbfiles&nbsp;[-T&nbsp;ora|syb|db2]</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="176546"></a>where <font face="Courier New, Courier, sansserif, sans serif" size="2">-T </font>forces behavior for a specific database type. Use this option in environments with more than one type of database.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168110"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command stores the filenames and file sizes in bytes in a file called <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font>.</font>
</p>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168111"></a>View the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168112"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cat&nbsp;mkqio.dat</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168113"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file contains the database filenames that can be converted to Quick I/O files. The format of the file is a list of paired file paths and file sizes. For example:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168114"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/database/dbfiles.001&nbsp;1024000</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168115"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/database/dbfiles.002&nbsp;2048000</font>
</font>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="168117"></a>Converting VxFS Files to Quick I/O Using qio_convertdbfiles</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168118"></a>After running <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font>, you can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command to convert database files to use Quick I/O. This command is for use with VxFS file systems only. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168119"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command converts regular files or symbolic links that point to regular files on VxFS file systems to Quick I/O. The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command converts only those files listed in the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file to Quick I/O. The <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file is created by running <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font>. It can also be created manually.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="168120"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168121"></a>To use this command for Oracle, the <font face="Courier New, Courier, sansserif, sans serif" size="2">ORACLE_SID</font> environment variable must be set. </font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168122"></a>You must be logged in as the Database Administrator to use this command.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="168123"></a><b>Usage Notes</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168124"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">-T</font> option forces the behavior for a specific database type. The database options that are supported are <font face="Courier New, Courier, sansserif, sans serif" size="2">ora</font>, <font face="Courier New, Courier, sansserif, sans serif" size="2">syb</font>, and <font face="Courier New, Courier, sansserif, sans serif" size="2">db2</font>. Use this option in environments with more than one type of database. </font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168125"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command expects all files to be owned by the database administrator. </font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168126"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">-a</font> option changes regular files to Quick I/O files using absolute pathnames. Use this option when symbolic links need to point to absolute pathnames. By default, relative pathnames are used.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168127"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">-f</font> option reports on current fragmentation levels for files listed in <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat.</font> Fragmentation is reported at four levels: not fragmented, slightly fragmented, fragmented, and highly fragmented.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168128"></a>Converting existing database files to Quick I/O is not recommended if the files are fragmented. In this case, it is recommended that you create new files with the <font face="Courier New, Courier, sansserif, sans serif" size="2">qiomkfile</font> command (these files are guaranteed not to be fragmented) and then convert the data from the old files (using a command such as <font face="Courier New, Courier, sansserif, sans serif" size="2">dd</font>).</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168129"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">-h</font> option displays a help message.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168130"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">-i</font> option creates extra links for all database files and log files in the /dev directory to support the SAP <font face="Courier New, Courier, sansserif, sans serif" size="2">brbackup</font> command.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168131"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">-u</font> option changes Quick I/O files back to regular files.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168132"></a>Ensure that the database is shut down before running <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font>.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168133"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font>(1M) manual page for more information.</font>
</li>
</ul>
</p>
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="168135"></a>&nbsp;&nbsp;<b>To convert VxFS files to Quick I/O files</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168136"></a>After running the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command, shut down the database:
</font>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/caution.gif" alt="Caution " height="16" width="16">&nbsp;<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="168137"></a><b>Caution  &nbsp;&nbsp;</b></font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"> Running <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> with any option except <font face="Courier New, Courier, sansserif, sans serif" size="2">-f</font> while the database is up and running can cause severe problems for your database, including data loss and corruption. Make sure the database is shut down before running the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command.</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168138"></a>Run the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command to convert the list of files in <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> to Quick I/O files:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168139"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_convertdbfiles</b></font>
</font>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="168140"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You must remove any non-VxFS files from <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> before running <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font>. The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command will display an error message if any of the database files in <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> are not on a VxFS file system. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168141"></a>Restart the database to access these database files using the Quick I/O interface.
</font>
</ol>
</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="168143"></a>&nbsp;&nbsp;<b>To undo a previous run of qio_convertdbfiles</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168144"></a>To undo a previous run of <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> and change Quick I/O files back to regular VxFS files:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168145"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_convertdbfiles&nbsp;-u</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168146"></a>.dbfile::cdev:vxfs:&nbsp;--&gt;&nbsp;dbfile
</font>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="168147"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If the database is up and running, an error message will be displayed stating that you need to shut it down before you can run <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font>.
</font>
<hr noshade size="2" width="100%" color="#000000">
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="168148"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168149"></a>In this example a regular VxFS file named <font face="Courier New, Courier, sansserif, sans serif" size="2">dbfile</font> is converted to Quick I/O and then converted back to a regular VxFS file:</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168150"></a>Get information about the file:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168151"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_getdbfiles</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168152"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cat&nbsp;mkqio.dat</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168153"></a>dbfile&nbsp;104800000
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168154"></a>Shut down the database and convert the file to Quick I/O:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168155"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_convertdbfiles</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168156"></a>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168157"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ls&nbsp;-alL&nbsp;d*&nbsp;.d*</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168158"></a>-rw-r--r--&nbsp;1&nbsp;oracle&nbsp;dba&nbsp;104857600&nbsp;May&nbsp;2&nbsp;13:42&nbsp;.dbfile
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168159"></a>crw-r--r--&nbsp;1&nbsp;oracle&nbsp;dba&nbsp;45,1&nbsp;May&nbsp;3&nbsp;12:18&nbsp;dbfile
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168160"></a>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168161"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ls&nbsp;-al&nbsp;d*&nbsp;.d*</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168162"></a>-rw-r--r--&nbsp;1&nbsp;oracle&nbsp;dba&nbsp;104857600&nbsp;May&nbsp;2&nbsp;14:42&nbsp;.dbfile
</font>
<a name="168163"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">lrwxrwxrwx 1 oracle dba 19 May 3 12:18 dbfile -&gt; .dbfile::cdev:vxfs:</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168164"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command renames the file <font face="Courier New, Courier, sansserif, sans serif" size="2">dbfile</font> to <font face="Courier New, Courier, sansserif, sans serif" size="2">.dbfile</font> and creates a symbolic link to <font face="Courier New, Courier, sansserif, sans serif" size="2">.dbfile</font> with the Quick I/O extension. By default, the symbolic link uses a relative path name.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168165"></a>Start up the database.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168166"></a>To undo a previous run of <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> and change Quick I/O files back to regular VxFS files:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168167"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_convertdbfiles&nbsp;-u</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168168"></a>.dbfile::cdev:vxfs:&nbsp;--&gt;&nbsp;dbfile
</font>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="168244"></a>Recreating Quick I/O Files Using qio_recreate</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168245"></a>You can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate </font>command to automatically recreate Quick I/O files when the database is recovered.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="168246"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168248"></a>You must be logged in as the Database Administrator to use this command.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="168249"></a><b>Usage Notes</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168250"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> command expects to find a file named <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> in the directory where the command is run. The mkqio.dat file contains a list of the Quick I/O files used by the database and their sizes. If the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file is not in the directory, you will be prompted to create it using <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font>. For more information, see <a href="oracle_hp_appAcli_sf_dbag163_168094.html#168094">Identifying VxFS Files to Convert to Quick I/O Using qio_getdbfiles</a>.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168260"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> command supports conventional Quick I/O files only (that is, Quick I/O files in the following form: <font face="Courier New, Courier, sansserif, sans serif" size="2">file</font> --&gt; <font face="Courier New, Courier, sansserif, sans serif" size="2">.file::cdev:vxfs:</font>). In creating a Quick I/O file, the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command renames the regular VxFS file, file, to <font face="Courier New, Courier, sansserif, sans serif" size="2">.file</font> with the Quick I/O extension (<font face="Courier New, Courier, sansserif, sans serif" size="2">:cdev::vxfs:</font>) and creates a symbolic link to it. By default, the symbolic link uses a relative path name.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168261"></a>There are no options for the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> command and no output is returned when the command runs successfully.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168262"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> command follows these rules in recreating Quick I/O files when a database is recovered:</font>
</li>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168263"></a>If a Quick I/O file (<font face="Courier New, Courier, sansserif, sans serif" size="2">.file::cdev:vxfs:</font>) is missing, then <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> recreates it.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168264"></a>If both a symbolic link (<font face="Courier New, Courier, sansserif, sans serif" size="2">file</font>) and its associated Quick I/O file (<font face="Courier New, Courier, sansserif, sans serif" size="2">.file::cdev:vxfs:</font>) are missing, <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> recreates both the symbolic link and the Quick I/O file.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168265"></a>If a symbolic link (<font face="Courier New, Courier, sansserif, sans serif" size="2">file</font>) from a regular VxFS file to its associated Quick I/O file (<font face="Courier New, Courier, sansserif, sans serif" size="2">.file::cdev:vxfs:</font>) is missing, then <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> recreates the symbolic link.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168266"></a>If a Quick I/O file (<font face="Courier New, Courier, sansserif, sans serif" size="2">.file::cdev:vxfs:</font>) is missing and the regular VxFS file that is symbolically linked to it is not the same one that originally created it, then <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> issues a warning message and does not recreate the Quick I/O file.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168267"></a>If a Quick I/O file (<font face="Courier New, Courier, sansserif, sans serif" size="2">.file::cdev:&nbsp;vxfs:</font>) is smaller than the size listed in <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font>, <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> issues a warning message.</font>
</li>
</ul>
</p>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168268"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font>(1M) manual page for more information.</font>
</li>
</ul>
</p>
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="168270"></a>&nbsp;&nbsp;<b>To automatically recreate Quick I/O files when the database is recovered</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="168271"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_recreate</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="168272"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_recreate</b></font>
</font>

<!-- 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_appAcli_sf_dbag163_168094.html" title="Identifying VxFS Files to Convert to Quick I/O Using qio_getdbfiles">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_appAcli_sf_dbag162_168036.html" title="Previous - Mapping Tablespaces to Disks Using dbed_analyzer">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_appBqiobckup_sf_dbag164_77168.html" title="Next - Appendix:  Using Third-Party Software to Back Up Files">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>
