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

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.

-s

Warning: 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.

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

Create a database file using the qiomkfile command:

# /opt/VRTS/bin/qiomkfile -h headersize -s file_size

/mount_point/filename

Change the owner and group permissions on the file:

# chown oracle:dba .filename

# chmod 660 .filename

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.dbf'

size 100M reuse;

exit;

An example to show how 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

89Improving database performance with Veritas Quick I/O

Creating database files as Quick I/O files using qiomkfile