VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
491
The qio_convertdbfiles command converts regular files or symbolic links that point to
regular files on VxFS file systems to Quick I/O. The qio_convertdbfiles command converts
only those files listed in the mkqio.dat file to Quick I/O. The mkqio.dat file is created by
running qio_getdbfiles. It can also be created manually.
Prerequisites
To use this command for Oracle, the ORACLE_SID environment variable must be set.
You must be logged in as the Database Administrator to use this command.
Usage Notes
The -T option forces the behavior for a specific database type. The database options that are
supported are ora, syb, and db2. Use this option in environments with more than one type of
database.
The qio_convertdbfiles command expects all files to be owned by the database
administrator.
The -a 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.
The -f option reports on current fragmentation levels for files listed in mkqio.dat.
Fragmentation is reported at four levels: not fragmented, slightly fragmented, fragmented, and
highly fragmented.
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 qiomkfile command
(these files are guaranteed not to be fragmented) and then convert the data from the old files
(using a command such as dd).
The -h option displays a help message.
The -i option creates extra links for all database files and log files in the /dev directory to
support the SAP brbackup command.
The -u option changes Quick I/O files back to regular files.
Ensure that the database is shut down before running qio_convertdbfiles.
See the qio_convertdbfiles(1M) manual page for more information.