VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 3, Using VERITAS Quick I/O

Prerelease 8 September 2005, 8:54am Creating Database Files as Quick I/O Files Using qiomkfile

Usage Notes

◆ The qiomkfile command creates two files: a regular file with preallocated, contiguous

space, and a file that is a symbolic link pointing to the Quick I/O name extension.

◆ See the qiomkfile(1M) manual page for more information.

▼ To create a database file as a Quick I/O file using qiomkfile

1. Create a database file using the qiomkfile command:

$ /opt/VRTS/bin/qiomkfile -h headersize -s file_size \

/mount_point/filename

2. Create tablespaces on this file using SQL*Plus statements, for example:

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> create tablespace ts1 datafile ’/mount_point/filename’ \

size 100M reuse;

SQL> exit;

Example

◆ To create a 100MB database file named dbfile on the VxFS file system /db01 using a

relative path name:

$ /opt/VRTS/bin/qiomkfile -h 32k -s 100m /db01/dbfile

$ ls -al

-rw-r--r-- 1 oracle dba 104890368 Oct 2 13:42 .dbfile

lrwxrwxrwx 1 oracle dba 19 Oct 2 13:42 dbfile -> \

.dbfile::cdev:vxfs:

In this example, qiomkfile creates a regular file named /db01/.dbfile, which has the real

space allocated. Then, qiomkfile creates a symbolic link named /db01/dbfile. This

symbolic link is a relative (soft) link to the Quick I/O interface for /db01/.dbfile, that is, to

the .dbfile::cdev:vxfs: file. The symbolic link allows .dbfile to be accessed by any

database or application using its Quick I/O interface.