VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Examples of Using the Command Line Interface Prerelease 8 September 2005, 8:55am
492 VERITAS Storage Foundation for Oracle Administrator’s Guide
▼ To convert VxFS files to Quick I/O files
1. After running the qio_getdbfiles command, shut down the database:
Caution Running qio_convertdbfiles with any option except -f while the database is up
and running can cause severe problems for your database, including data loss and
corruption. Make sure the database is shut down before running the
qio_convertdbfiles command.
2. Run the qio_convertdbfiles command to convert the list of files in mkqio.dat to
Quick I/O files:
$ /opt/VRTSdbed/bin/qio_convertdbfiles
Note You must remove any non-VxFS files from mkqio.dat before running
qio_convertdbfiles. The qio_convertdbfiles command will display an error
message if any of the database files in mkqio.dat are not on a VxFS file system.
3. Restart the database to access these database files using the Quick I/O interface.
▼ To undo a previous run of qio_convertdbfiles
To undo a previous run of qio_convertdbfiles and change Quick I/O files back to regular
VxFS files:
$ /opt/VRTSdbed/bin/qio_convertdbfiles -u
.dbfile::cdev:vxfs: --> dbfile
Note If the database is up and running, an error message will be displayed stating that you need to
shut it down before you can run qio_convertdbfiles.
Example
In this example a regular VxFS file named dbfile is converted to Quick I/O and then converted
back to a regular VxFS file:
Get information about the file:
$ /opt/VRTSdbed/bin/qio_getdbfiles
$ cat mkqio.dat
dbfile 104800000
Shut down the database and convert the file to Quick I/O:
$ /opt/VRTSdbed/bin/qio_convertdbfiles