<!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:31">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_ch3qio.fm">
     
<title>Converting Oracle Files to Quick I/O Files</title>

</HEAD>

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

<a name="225166"></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_ch3qio_sf_dbag40_225006.html" title="Previous - Accessing Regular VxFS Files as Quick I/O Files">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch3qio_sf_dbag42_225836.html" title="Next - Understanding Sparse 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>
	
<h1><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="+1" color="#000000"><a name="225166"></a>Converting Oracle Files to Quick I/O Files</font>
</h1>
 
  
  
  

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225168"></a>Special commands, available in the <font face="Courier New, Courier, sansserif, sans serif" size="2">/opt/VRTSdbed/bin</font> directory, are provided to assist you in converting an existing database to use Quick I/O. You can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command to extract a list of file names from the database system tables and the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command to convert this list of database files to use Quick I/O.</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="225176"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">It is recommended that you create a Storage Checkpoint before converting to or from Quick I/O. For information on creating Storage Checkpoints, see <a href="oracle_hp_ch8storageckpts_sf_dbag77_140160.html#140160">Using Storage Checkpoints and Storage Rollback for Backup and Restore</a>.
</font>
<hr noshade size="2" width="100%" color="#000000">
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="225192"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225193"></a>Log in as the Database Administrator (typically, the user ID <font face="Courier New, Courier, sansserif, sans serif" size="2">oracle</font>) to run the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> and <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> commands.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225195"></a>You must predefine the Oracle environment variable <em>$ORACLE_SID</em>.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225196"></a>The repository must exist before you can convert to Quick I/O files. Run the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_update</font> command to update or create the repository.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225197"></a>Files you want to convert must be regular files on VxFS file systems or links that point to regular VxFS files.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="225201"></a><b>Options</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225216"></a>For the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command:
<Table width="100%" border="0" cellpadding="1" cellspacing="0" >
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225204"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-a</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225206"></a>Lets you include all datafiles, including those that are potentially sparse.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225207"></a>(Use this option only for debugging purposes, as sparse files are not candidates for use with Quick I/O.)</font>
</p>

</td></tr><tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225212"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-T</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225215"></a>Lets you specify the type of database as <font face="Courier New, Courier, sansserif, sans serif" size="2">ora</font>. Specify this option only in environments where the type of database is ambiguous (for example, when multiple types of database environment variables, such as <font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font>, <em>SYBASE</em>, <em>DSQUERY</em>, and <font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$DB2INSTANCE</em></font>, are present on a server). </font>
</p>

</td></tr>
</Table>


<Table width="100%" border="0" cellpadding="1" cellspacing="0">
<tr><td>
</Table></font>
</p>

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

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225254"></a>For the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command:
<Table width="100%" border="0" cellpadding="1" cellspacing="0" >
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225220"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-a</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225224"></a>Changes regular files to Quick I/O files using absolute path names. Use this option when symbolic links need to point to absolute path names (for example, at a site that uses SAP).</font>
</p>

</td></tr><tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225228"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-f</font></font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225230"></a>Reports on the current fragmentation levels for database files listed in the mkqio.dat file. Fragmentation is reported as not fragmented, slightly fragmented, fragmented, highly fragmented. </font>
</p>

</td></tr><tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225233"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-h</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225235"></a>Displays a help message.</font>
</p>

</td></tr><tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225237"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-i</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225240"></a>Creates the extra links for all datafiles and log files in the <font face="Courier New, Courier, sansserif, sans serif" size="2">/dev</font> directory to support SAP's <font face="Courier New, Courier, sansserif, sans serif" size="2">brbackup</font>. </font>
</p>

</td></tr><tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225242"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-T</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225245"></a>Lets you specify the type of database as <font face="Courier New, Courier, sansserif, sans serif" size="2">ora</font>. Specify this option only in environments where the type of database is ambiguous (for example, when multiple types of database environment variables, such as <font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font>, <em>SYBASE</em>, <em>DSQUERY</em>, and <font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$DB2INSTANCE</em></font> are present on a server). </font>
</p>

</td></tr><tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225247"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-u</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225251"></a>Changes Quick I/O files back to regular files. Use this option to undo changes made by a previous run of the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> script.</font>
</p>

</td></tr>
</Table>


<Table width="100%" border="0" cellpadding="1" cellspacing="0">
<tr><td>
</Table></font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="225255"></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="225258"></a>Converting existing database files to be Quick I/O files may not be the best choice if the files are fragmented. Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">-f</font> option to determine the fragmentation levels and either:</font>
</li>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225260"></a>Exclude files that are highly fragmented and do not have sufficient contiguous extents for Quick I/O use.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225264"></a>or</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225265"></a>Create new files with the <font face="Courier New, Courier, sansserif, sans serif" size="2">qiomkfile</font> command, rather than converting the files using the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command. The new files will be contiguous. You must then move data from the old files to the new files using the <font face="Courier New, Courier, sansserif, sans serif" size="2">dd</font>(1M) command or a database import facility, and then define the new files to the database. </font>
</li>
</ul>
</p>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225268"></a>By default, <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> skips any tablespaces marked <font face="Courier New, Courier, sansserif, sans serif" size="2">TEMPORARY</font>. Tablespaces marked <font face="Courier New, Courier, sansserif, sans serif" size="2">TEMPORARY</font> can be <em>sparse</em>, which means that not all blocks in the file are allocated. Quick I/O files cannot be sparse, as Quick I/O provides a raw-type interface to storage. If a sparse file is converted to a Quick I/O file, the Oracle instance can fail if Oracle attempts to write into one of these unallocated blocks. See <a href="oracle_hp_ch3qio_sf_dbag43_225855.html#225855">Handling Oracle Temporary Tablespaces and Quick I/O</a> for more information.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225290"></a>For information on creating Quick I/O files for temporary tablespaces, see <a href="oracle_hp_ch3qio_sf_dbag38_224182.html#224182">Creating Database Files as Quick I/O Files Using qiomkfile</a>.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225299"></a>Instead of using the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command, you can manually create the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file containing the Oracle database filenames that you want to convert to Quick I/O files. </font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225303"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command exits and prints an error message if any of the database files are not on a VxFS file system. If this happens, you must remove any non-VxFS files from the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file before running the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command.</font>
</blockquote>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225311"></a></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="225312"></a>&nbsp;&nbsp;<b>To extract a list of Oracle files to convert</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225314"></a>With the database instance up and running, run the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command from a directory for which you have write permission:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225315"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cd&nbsp;/</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>extract</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>_</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>directory</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225317"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_getdbfiles&nbsp;-T&nbsp;ora</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225318"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command extracts the list file names from the database system tables and stores the file names and their size in bytes in a file called <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> under the current directory.</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="225320"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Alternatively, you can manually create the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file containing the Oracle database file names that you want to convert to use Quick I/O. You can also manually edit the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file generated by <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font>, and remove files that you do not want to convert to Quick I/O files.<br><br>To run the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_getdbfiles</font> command, you must have permission to access the database and permission to write to the <font face="Courier New, Courier, sansserif, sans serif" size="2">/extract_directory</font>.
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225327"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> list file should look similar to the following:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225328"></a>&nbsp;&nbsp;&nbsp;/db01/file1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;210356
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225329"></a>&nbsp;&nbsp;&nbsp;/db01/file2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;157996
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225330"></a>&nbsp;&nbsp;&nbsp;/db01/file3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;38096
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225331"></a>&nbsp;&nbsp;&nbsp;/db01/file4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;394932
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225332"></a>&nbsp;&nbsp;&nbsp;/db01/file5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;911784
</font>
</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="225337"></a>&nbsp;&nbsp;<b>To convert the Oracle database 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="225339"></a>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="225340"></a><b>Caution  &nbsp;&nbsp;</b></font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"> Running the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command while the database is up and running can cause severe problems with your database, including loss of data, and corruption.</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="225342"></a>Run the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command from the writable directory where the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> list resides:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225343"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cd&nbsp;/</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>extract</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>_</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>directory</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225345"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_convertdbfiles</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225348"></a>The list of files in the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file is displayed. For example:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225349"></a>&nbsp;&nbsp;&nbsp;file1&nbsp;--&gt;&nbsp;.file1::cdev:vxfs:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225350"></a>&nbsp;&nbsp;&nbsp;file2&nbsp;--&gt;&nbsp;.file2::cdev:vxfs:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225351"></a>&nbsp;&nbsp;&nbsp;file3&nbsp;--&gt;&nbsp;.file3::cdev:vxfs:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225352"></a>&nbsp;&nbsp;&nbsp;file4&nbsp;--&gt;&nbsp;.file4::cdev:vxfs:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225353"></a>&nbsp;&nbsp;&nbsp;file5&nbsp;--&gt;&nbsp;.file5::cdev:vxfs:
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225355"></a>Run the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command (with no options specified) to rename the file <em>filename</em> to <font face="Courier New, Courier, sansserif, sans serif" size="2">.</font><em>filename</em> and creates a symbolic link to <font face="Courier New, Courier, sansserif, sans serif" size="2">.</font><em>filename</em> 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="225359"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> script exits and prints an error message if any of the database files are not on a VxFS file system. If this happens, you must remove any non-VxFS files from the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file before running the <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command again.</font>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225367"></a>Start up the database.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225370"></a>You can now access these database files using the Quick I/O interface.</font>
</p>
</ol>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225372"></a></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="225375"></a>&nbsp;&nbsp;<b>To undo the previous run of qio_convertdbfiles and change Quick I/O files back to regular VxFS files</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225380"></a>If the database is running, shut it down
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225381"></a>Run the following command from the writable directory where the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> list resides:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225382"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cd&nbsp;/</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>extract</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>_</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>directory</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225384"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTSdbed/bin/qio_convertdbfiles&nbsp;-u</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225386"></a>The list of Quick I/O files in the <font face="Courier New, Courier, sansserif, sans serif" size="2">mkqio.dat</font> file is displayed. For example:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225387"></a>&nbsp;&nbsp;&nbsp;.file1::cdev:vxfs:&nbsp;--&gt;&nbsp;file1
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225388"></a>&nbsp;&nbsp;&nbsp;.file2::cdev:vxfs:&nbsp;--&gt;&nbsp;file2
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225389"></a>&nbsp;&nbsp;&nbsp;.file3::cdev:vxfs:&nbsp;--&gt;&nbsp;file3
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225390"></a>&nbsp;&nbsp;&nbsp;.file4::cdev:vxfs:&nbsp;--&gt;&nbsp;file4
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="225391"></a>&nbsp;&nbsp;&nbsp;.file5::cdev:vxfs:&nbsp;--&gt;&nbsp;file5
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225392"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">qio_convertdbfiles</font> command with the undo option (<font face="Courier New, Courier, sansserif, sans serif" size="2">-u</font>) specified renames the files from <em>.filename</em> to <em>filename</em> and undoes the symbolic link to <font face="Courier New, Courier, sansserif, sans serif" size="2">.</font><em>filename</em> that was created along with the Quick I/O files.</font>
</p>
</ol>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="225393"></a></font>
</p>


<!-- 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_ch3qio_sf_dbag41_225166.html" title="Converting Oracle Files to Quick I/O Files">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_ch3qio_sf_dbag40_225006.html" title="Previous - Accessing Regular VxFS Files as Quick I/O Files">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch3qio_sf_dbag42_225836.html" title="Next - Understanding Sparse 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>
