VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 3, Using VERITAS Quick I/O

Prerelease 8 September 2005, 8:54am Converting Oracle Files to Quick I/O Files

▼

To extract a list of Oracle files to convert

With the database instance up and running, run the qio_getdbfiles command from a directory

for which you have write permission:

$ cd /extract_directory

$ /opt/VRTSdbed/bin/qio_getdbfiles -T ora

The qio_getdbfiles 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 mkqio.dat under the current directory.

Note Alternatively, you can manually create the mkqio.dat file containing the Oracle database

file names that you want to convert to use Quick I/O. You can also manually edit the

mkqio.dat file generated by qio_getdbfiles, and remove files that you do not want

to convert to Quick I/O files.

To run the qio_getdbfiles command, you must have permission to access the database

and permission to write to the /extract_directory.

The mkqio.dat list file should look similar to the following:

/db01/file1 210356

/db01/file2 157996

/db01/file3 38096

/db01/file4 394932

/db01/file5 911784

▼ To convert the Oracle database files to Quick I/O files

1. Shut down the database.

Caution Running the qio_convertdbfiles command while the database is up and running

can cause severe problems with your database, including loss of data, and corruption.

2. Run the qio_convertdbfiles command from the writable directory where the

mkqio.dat list resides:

$ cd /extract_directory

$ /opt/VRTSdbed/bin/qio_convertdbfiles

The list of files in the mkqio.dat file is displayed. For example:

file1 --> .file1::cdev:vxfs:

file2 --> .file2::cdev:vxfs:

file3 --> .file3::cdev:vxfs:

file4 --> .file4::cdev:vxfs:

file5 --> .file5::cdev:vxfs: