Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

■ When possible, use relative path names instead of absolute path

names when creating symbolic links to access regular files as Quick

I/O files. Using relative path names prevents copies of the symbolic

link from referring to the original file when the directory is copied.

This is important if you are backing up or moving database files

with a command that preserves the symbolic link.

However, some applications require absolute path names. If a file

is then relocated to another directory, you must change the

symbolic link to use the new absolute path. Alternatively, you can

put all the symbolic links in a directory separate from the data

directories. For example, you can create a directory named

/database and put all the symbolic links there, with the symbolic

links pointing to absolute path names.

Usage notes

To access an existing regular file as a Quick I/O file on a VxFS file system

Access the VxFS file system mount point containing the regular files:

$ cd /mount_point

Create the symbolic link:

$ mv filename .filename

$ ln -s .filename::cdev:vxfs: filename

This example shows how to access the VxFS file dbfile as a Quick I/O file:

$ cd /db01

$ mv dbfile .dbfile

$ ln -s .dbfile::cdev:vxfs: dbfile

This example shows how to confirm the symbolic link was created:

$ ls -lo .dbfile dbfile

lrwxr-xr-x 1 oracle 18 Jul 22 06:01 dbfile ->

.dbfile::cdev:vxfs:

lrwxr-xr-x 1 oracle 22 Jul 22 06:27 dbfile.dbf ->

.dbfile.dbf::cdev:vxfs:

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

Using Veritas Quick I/O

Converting Oracle files to Quick I/O files