Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

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

Shut down the database.

Run the qio_convertdbfiles command from the directory containing the

mkqio.dat file:

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

Run the qio_convertdbfiles command (with no options specified) to rename

the file filename to .filename and creates a symbolic link to .filename with

the Quick I/O extension. By default, the symbolic link uses a relative path

name.

The qio_convertdbfiles 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 mkqio.dat file before running the

qio_convertdbfiles command again.

Start up the database.

You can now access these database files using the Quick I/O interface.

97Improving database performance with Veritas Quick I/O

Converting Oracle files to Quick I/O files