VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 3, Using VERITAS Quick I/O

Prerelease 8 September 2005, 8:54am Converting Oracle Files to Quick I/O Files

Converting Oracle Files to Quick I/O Files

Special commands, available in the /opt/VRTSdbed/bin directory, are provided to assist you

in converting an existing database to use Quick I/O. You can use the qio_getdbfiles

command to extract a list of file names from the database system tables and the

qio_convertdbfiles command to convert this list of database files to use Quick I/O.

Note It is recommended that you create a Storage Checkpoint before converting to or from Quick

I/O. For information on creating Storage Checkpoints, see “Using Storage Checkpoints and

Storage Rollback for Backup and Restore” on page 163.

Prerequisites

◆ Log in as the Database Administrator (typically, the user ID oracle) to run the

qio_getdbfiles and qio_convertdbfiles commands.

◆ You must predefine the Oracle environment variable $ORACLE_SID.

◆ The repository must exist before you can convert to Quick I/O files. Run the dbed_update

command to update or create the repository.

◆ Files you want to convert must be regular files on VxFS file systems or links that point to

regular VxFS files.

Options

For the qio_getdbfiles command:

For the qio_convertdbfiles command:

-a Lets you include all datafiles, including those that are potentially sparse.

(Use this option only for debugging purposes, as sparse files are not candidates for use

with Quick I/O.)

-T Lets you specify the type of database as ora. Specify this option only in environments

where the type of database is ambiguous (for example, when multiple types of database

environment variables, such as $ORACLE_SID, SYBASE, DSQUERY, and

$DB2INSTANCE, are present on a server).

-a Changes regular files to Quick I/O files using absolute path names. Use this option when

symbolic links need to point to absolute path names (for example, at a site that uses

SAP).

-f Reports on the current fragmentation levels for database files listed in the mkqio.dat file.

Fragmentation is reported as not fragmented, slightly fragmented, fragmented, highly

fragmented.