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

Then...If...

the Quick I/O file is not recreated and a

warning message is displayed.

a Quick I/O file is smaller than the size listed

in the mkqio.dat file

Disabling Quick I/O

If you need to disable the Quick I/O feature, you first need to convert any Quick

I/O files back to regular VxFS files. Then, remount the VxFS file system using a

special mount option.

Before disabling Quick I/O, make sure the following condition has been met:

The file system you are planning to remount must be located in the

/etc/fstab file.

Prerequisite

To disable Quick I/O

If the database is running, shut it down.

To change Quick I/O files back to regular VxFS files, run the following

command from the directory containing the mkqio.dat list:

$ /opt/VRTSdbed/bin/qio_convertdbfiles -u

The list of Quick I/O files in the mkqio.dat file is displayed. For example:

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

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

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

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

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

The qio_convertdbfiles command with the undo option (-u) renames the

files from .filename to filename and removes the symbolic link to .filename

that was created along with the Quick I/O files.

To remount the file system with Quick I/O disabled, use the mount -o noqio

command as follows:

# /opt/VRTS/bin/mount -F vxfs -o remount,noqio /mount_point

107Improving database performance with Veritas Quick I/O

Disabling Quick I/O