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

you have performed a full database recovery. The qio_recreate command uses
the mkqio.dat file, which contains a list of the Quick I/O files used by the database
and the file sizes.
For information on recovering your database, refer to the documentation that
came with your database software.
Before recreating Quick I/O with the qio_recreate command, make sure the
following conditions have been met:
■ Recover your database before attempting to recreate the Quick I/O
files.
■ You may be logged in as either the database administrator or root
to run the qio_recreate command.
■ In the directory from which you run the qio_recreate command,
you must have an existing mkqio.dat file.
■ The ORACLE_SID environment variable must be set.
See “Converting Oracle files to Quick I/O files” on page 92.
Oracle
Prerequisites
■ The qio_recreate command supports only conventional Quick
I/O files.
■ Refer to the qio_recreate(1M) manual page for more
information.
Usage notes
To recreate Quick I/O files after recovering a database
◆
As Oracle DBA, use the qio_recreate command as follows:
$ /opt/VRTSdbed/bin/qio_recreate -T ora
You will not see any output if the command is successful.
When you run the qio_recreate command, the following actions occur:
Then...If...
the Quick I/O file is recreated.a Quick I/O file is missing
the symbolic link is recreated.a symbolic link from a regular VxFS file to a
Quick I/O file is missing
both the link and the Quick I/O file are
recreated.
a symbolic link and its associated Quick I/O
file are missing
the Quick I/O file is not recreated and a
warning message is displayed.
a Quick I/O file is missing and the regular
VxFS file that it is symbolically linked to is
not the original VxFS file
Improving database performance with Veritas Quick I/O
Recreating Quick I/O files after restoring a database
106