VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Setting Up a New Database Prerelease 8 September 2005, 8:54am
50 VERITAS Storage Foundation for Oracle Administrator’s Guide
Setting Up a New Database
VERITAS Storage Foundation for Oracle contains a combination of performance, management,
and high availability features. This section provides an overview of the steps to follow if you are
using VERITAS Storage Foundation for Oracle to set up a new database.
▼ To set up a new database using VERITAS Storage Foundation for Oracle
1. Determine the number and sizes of file systems you need for the database you want to create.
For detailed information, see the VERITAS File System Administrator’s Guide.
2. Create volumes to meet your file system needs. You can use disk mirroring as a safeguard
against disk failures and striping for better performance. For more information see the
“Selecting a Volume Layout” on page 58 and “Creating a Volume” on page 60. For
information about performance tuning to improve database performance, see “Tuning for
Performance” on page 401.
If you plan to create volume snapshots for the database and use them on either the same host or
a secondary one, ensure that your volume layout is consistent with Database FlashSnap
requirements. For information about these requirements, see “Using Database FlashSnap for
Backup and Off-Host Processing” on page 197.
3. Create the VxFS file systems you need on the volumes. See “File System Creation Guidelines”
on page 66 and “Creating a VxFS File System” on page 67.
4. Install and configure your database. For best OLTP performance, use Quick I/O for Oracle8i
and Oracle Disk Manager (ODM) for Oracle9i and later. You must create Quick I/O files
before creating the tablespaces. For information on creating and using Quick I/O files, and
converting existing files to Quick I/O, see “Using VERITAS Quick I/O” on page 83.
If you would like the ability to view detailed storage stack topology information to ensure your
storage stack configuration is optimized for the database, configure and use Storage Mapping.
For more information, see “Understanding Storage Mapping” on page 138.
If you are already running your database on VxVM and VxFS but are not using Quick I/O or
ODM, you will need to follow these steps to convert you existing files to use Quick I/O and
ODM:
a. If you want to use Database FlashSnap for off-host processing after converting your
database files to use Quick I/O and ODM and your volume layout is inconsistent with
Database FlashSnap requirements, you will need to “relayout” your volume manager