VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
493
$ ls -alL d* .d*
-rw-r--r-- 1 oracle dba 104857600 May 2 13:42 .dbfile
crw-r--r-- 1 oracle dba 45,1 May 3 12:18 dbfile
$ ls -al d* .d*
-rw-r--r-- 1 oracle dba 104857600 May 2 14:42 .dbfile
lrwxrwxrwx 1 oracle dba 19 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.
To undo a previous run of qio_convertdbfiles and change Quick I/O files back to regular
VxFS files:
$ /opt/VRTSdbed/bin/qio_convertdbfiles -u
.dbfile::cdev:vxfs: --> dbfile
Recreating Quick I/O Files Using qio_recreate
You can use the qio_recreate command to automatically recreate Quick I/O files when the
database is recovered.
Prerequisites
◆ You must be logged in as the Database Administrator to use this command.
Usage Notes
◆ The qio_recreate command expects to find a file named mkqio.dat in the directory
where the command is run. The mkqio.dat file contains a list of the Quick I/O files used by the
database and their sizes. If the mkqio.dat file is not in the directory, you will be prompted to
create it using qio_getdbfiles. For more information, see “Identifying VxFS Files to
Convert to Quick I/O Using qio_getdbfiles” on page 491.
◆ The qio_recreate command supports conventional Quick I/O files only (that is, Quick I/O
files in the following form: file --> .file::cdev:vxfs:). In creating a Quick I/O file,
the qio_convertdbfiles command renames the regular VxFS file, file, to .file with
the Quick I/O extension (:cdev::vxfs:) and creates a symbolic link to it. By default, the
symbolic link uses a relative path name.
◆ There are no options for the qio_recreate command and no output is returned when the
command runs successfully.