qio_getdbfiles - identify VxFS files to Quick I/O files

qio_getdbfiles [ -T database_type ] [ -a ]

Storage Foundation. To determine whether this product is installed on the system, enter:

lslpp -L VRTSdbed

You can use the qio_getdbfiles command to identify database files and then convert them to use Quick I/O with qio_convertdbfiles. These two commands are for use with VxFS file systems only and call the database-specific version of the conversion utility.

The qio_getdbfiles command is available in the /opt/VRTSdbed/bin directory.

To use this command for Oracle, the ORACLE_SID environment variable must be set.

While the database instance is up and running, run the qio_getdbfiles command to get a list of files used by the database. This command stores the file names and sizes in bytes in a file called mkqio.dat. The files listed in mkqio.dat are converted to Quick I/O by the qio_convertdbfiles command. If the database you want to gather this information about is not up and running, you can manually create the mkqio.dat file. The format of this file is a list of paired file paths and file sizes. For example:

/database/dbfile.001 1024000 /database/dbfile.002 2048000

After running the qio_getdbfiles command, shut down the database and run the qio_convertdbfiles command to convert the list of file names in the mkqio.dat file to Quick I/O files. For more information, see the qio_convertdbfiles(1M) man page.

The following options are supported by qio_getdbfiles:

-T database_type
	This option forces behavior for a specific database vendor. The database option that is currently supported is ora only. Use this option in environments where the database to perform operations on is ambiguous. qio_getdbfiles and qio_convertdbfiles resolve ambiguity by examining the environment and searching for variable settings that are a prerequisite for using one or more database vendors’ products.
-a	Includes all datafiles. By default, any database files that the qio_getdbfiles command identifies as potential sparse files are excluded. This option should be used for debugging only, since sparse database files are not candidates for use with the Quick I/O driver.
-h	Shows command usage.

You must be logged in as the Database Administrator to run qio_getdbfiles. The qio_getdbfiles command queries the database to gather a list of datafiles to be converted, which requires direct access to the database.

This example shows the procedure for converting the files in a database to Quick I/O files.

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

$ ls -alL d* .d* -rw-r--r-- 1 admin dbgrp 104857600 May 2 13:42 .dbfile crw-r--r-- 1 admin dbgrp 45, 1 May 3 12:18 dbfile

$ ls -al d* .d* -rw-r--r-- 1 admin dbgrp 104857600 May 2 13:42 .dbfile lrwxrwxrwx 1 admin dbgrp 17 May 3 12:18 dbfile -> .dbfile::cdev:vxfs:

The qio_convertdbfiles command renames the file dbfile to .dbfile and creates a symbolic link to .dbfile with the Quick I/O extension. By default, the symbolic link uses a relative path name.

Start up the database.

Note: If the server is up and running, you will receive an error message stating that you need to shut it down before you can run the qio_convertdbfiles command.

qio_convertdbfiles(1M), qio_recreate(1M)

oracle_edition(7)

Storage Foundation: Storage and Availability Management for Oracle Databases Guide