Tasks for setting up new databases

If you are using Veritas Storage Foundation for Oracle to set up a new database, complete these tasks in the order listed below:

Determine the number and sizes of file systems you need for the database you want to create.

See the Veritas File System Administrator's Guide.

Create volumes to meet your file system needs. You can use disk mirroring as a safeguard against disk failures and striping for better performance.

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.

See Hosts and storage for Database FlashSnap .

Create the VxFS file systems you need on the volumes.

See Creating a VxFS file system .

Install and configure your database.

For best OLTP performance, use Oracle Disk Manager (ODM) or Quick I/O.

You must create Quick I/O files before creating the tablespaces.

See About Quick I/O.

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.

See About Storage Mapping .

If you want to use Database FlashSnap for off-host processing after converting your database files to use Quick I/O or ODM and your volume layout is inconsistent with Database FlashSnap requirements, you will need to "relayout" your volume manager configuration after your database files have been converted.

See the Veritas Volume Manager Administrator's Guide.

If you are using Quick I/O, convert all database files to Quick I/O files.

See Converting Oracle files to Quick I/O files.

If using ODM, link the ODM library.

If you are not currently running on VxVM and VxFS, make sure Veritas Storage Foundation for Oracle is installed and convert your existing database configuration.

See the Veritas Storage Foundation for Oracle Installation Guide.

For backup and recovery on the same host, you can use the Storage Checkpoint facility to create file system snapshots of the database. A Storage Checkpoint creates an exact image of a database instantly and provides a consistent image of the database from the point in time the Storage Checkpoint was created.

See About Storage Checkpoints and Storage Rollback.

For off-host processing or backup, you can use the Database FlashSnap feature to create a volume snapshot for the database. Database FlashSnap lets you capture an online image of an actively changing database at a given instant, known as a snapshot. You can perform backups and off-host processing tasks on snapshots while providing continuous availability of your critical data.

More Information

File system creation guidelines

Setting up Veritas Extension for Oracle Disk Manager