Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

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.

Note: 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:

/data11r1/VRTS11r1/redo01.log 52428800

/data11r1/VRTS11r1/redo02.log 52428800

/data11r1/VRTS11r1/redo03.log 52428800

/data11r1/VRTS11r1/sysaux01.dbf 632553472

/data11r1/VRTS11r1/system01.dbf 754974720

/data11r1/VRTS11r1/undotbs01.dbf 47185920

/data11r1/VRTS11r1/users01.dbf 5242880

/data11r1/nqio1.dbf 104857600

Using Veritas Quick I/O

Converting Oracle files to Quick I/O files