Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

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 ......... 81
Accessing regular VxFS files as Quick I/O files ................................... 83
Converting Oracle files to Quick I/O files .......................................... 84
About sparse files ......................................................................... 89
Handling Oracle temporary tablespaces and Quick I/O ........................ 90
Displaying Quick I/O status and file attributes ................................... 92
Extending a Quick I/O file .............................................................. 94
Using Oracle's AUTOEXTEND with Quick I/O files ............................. 95
Recreating Quick I/O files after restoring a database ........................... 97
Disabling Quick I/O ...................................................................... 98
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
Determining candidates for Cached Quick I/O .................................. 107
9Contents