VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Examples of Using the Command Line Interface Prerelease 8 September 2005, 8:55am
490 VERITAS Storage Foundation for Oracle Administrator’s Guide
Identifying VxFS Files to Convert to Quick I/O Using qio_getdbfiles
You can use the qio_getdbfiles command to identify VxFS files before converting them to
Quick I/O files. Only VxFS files may be converted to Quick I/O.
The qio_getdbfiles 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.
Prerequisites
◆ To use this command for Oracle, the ORACLE_SID environment variable must be set.
◆ You must be logged in as the Database Administrator.
Usage Notes
◆ The -T option forces the behavior for a specific database type. Use this option in environments
with more than one type of database.
◆ See the qio_getdbfiles(1M) manual page for more information.
▼ To identify the VxFS files to convert to Quick I/O
1. Use the qio_getdbfiles command as follows:
$ /opt/VRTSdbed/bin/qio_getdbfiles [-T ora|syb|db2]
where -T forces behavior for a specific database type. Use this option in environments with
more than one type of database.
The qio_getdbfiles command stores the filenames and file sizes in bytes in a file called
mkqio.dat.
2. View the mkqio.dat file:
$ cat mkqio.dat
The mkqio.dat 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:
/database/dbfiles.001 1024000
/database/dbfiles.002 2048000
Converting VxFS Files to Quick I/O Using qio_convertdbfiles
After running qio_getdbfiles, you can use the qio_convertdbfiles command to
convert database files to use Quick I/O. This command is for use with VxFS file systems only.