Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Chapter 3 Managing the SFDB repository ......................................... 67
About the SFDB repository ............................................................. 67
Runtime management tasks for the SFDB repository .......................... 68
Starting, stopping, and checking the SFDB repository with
sfua_db_config ................................................................ 68
Backing up and restoring the SFDB repository with
sfua_rept_adm ................................................................. 68
Monitoring free space for the SFDB repository ............................ 72
Adding a new system to an HA configuration .................................... 72
Reconfiguring virtual IP address for repository configuration .............. 73
Accessing an off-host repository in a non-VCS environment ................ 74
Chapter 4 Using Veritas Quick I/O ...................................................... 75
About Quick I/O ........................................................................... 75
How Quick I/O works .............................................................. 76
How Quick I/O improves database performance ........................... 76
About Quick I/O requirements .................................................. 77
How to set up Quick I/O ........................................................... 78
Creating database files as Quick I/O files using qiomkfile ..................... 79
Preallocating space for Quick I/O files using the setext
command ............................................................................. 82
Accessing regular VxFS files as Quick I/O files ................................... 83
Converting Oracle files to Quick I/O files .......................................... 84
About sparse files ......................................................................... 90
Handling Oracle temporary tablespaces and Quick I/O ........................ 91
Displaying Quick I/O status and file attributes ................................... 93
Extending a Quick I/O file .............................................................. 94
Using Oracle's AUTOEXTEND with Quick I/O files ............................. 96
Recreating Quick I/O files after restoring a database ........................... 98
Disabling Quick I/O ...................................................................... 99
Chapter 5 Using Veritas Cached Quick I/O ..................................... 101
About Cached Quick I/O ............................................................... 101
How Cached Quick I/O works .................................................. 101
How Cached Quick I/O improves database performance ............... 102
How to set up Cached Quick I/O ............................................... 103
Enabling Cached Quick I/O on a file system ..................................... 103
Enabling and disabling the qio_cache_enable flag ....................... 104
Making Cached Quick I/O settings persistent across reboots and
mounts ......................................................................... 105
Using vxtunefs to obtain tuning information ............................. 106
9Contents