VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Creating Database Files as Quick I/O Files Using qiomkfile Prerelease 8 September 2005, 8:54am
88 VERITAS Storage Foundation for Oracle Administrator’s Guide
Creating Database Files as Quick I/O Files Using qiomkfile
The best way to preallocate space for database files and to make them accessible using the Quick
I/O interface is to use the qiomkfile command. You can use the qiomkfile command to
create Quick I/O files for either temporary or permanent tablespaces.
Prerequisites
◆ You can create Quick I/O files only on VxFS file systems.
◆ If you are creating database files on an existing file system, run fsadm (or similar utility) to
report and eliminate fragmentation.
◆ You must have read/write permissions on the directory in which you intend to create Oracle
Quick I/O files.
qiomkfile Options
Caution Exercise caution when using absolute path names. Extra steps may be required during
database backup and restore procedures to preserve symbolic links. If you restore files
to directories different from the original paths, you must change the symbolic links that
use absolute path names to point to the new path names before the database is restarted.
-a Creates a symbolic link with an absolute path name for a specified file. Use the -a
option when absolute path names are required. However, the default is to create a
symbolic link with a relative path name.
-e Extends a file by a specified amount to allow Oracle tablespace resizing. See “Extending
a Quick I/O File” on page 104 for more information.
-h Specifies the Oracle datafile header size. This option specifies a header that will be
allocated in addition to the size specified because Oracle requires one additional database
block for all its datafiles. If this option is used, the resulting file can be used as an Oracle
datafile. When creating an Oracle datafile, the header size should be equal to the Oracle
block size (as determined by the DB_BLOCK_SIZE parameter). If the header size is
missing when the -h option is used, a 32K header will be allocated.
-r Increases the file to a specified size to allow Oracle tablespace resizing. See “Extending a
Quick I/O File” on page 104 for more information.
-s Specifies the space to preallocate for a file in bytes, kilobytes, megabytes, gigabytes, or
sectors (1024 bytes) by adding a k, K, m, M, g, G, s, or S suffix. The default is
bytes—you do not need to attach a suffix to specify the value in bytes. The size of the
file that is preallocated is the total size of the file (including the header) rounded to the
nearest multiple of the file system block size.