VERITAS FlashSnap Point-In-Time-Copy Solutions Administrator's Guide

Preparing a Replica Oracle Database

This appendix describes how to set up a replica off-host Oracle database to be used for decision

support as described in “Creating an Off-Host Replica Database” on page 53.

To prepare a replica Oracle database on a host other than the primary host:

1. If not already present, install the Oracle software onto the host’s local disks. The location of the

Oracle home directory ($ORACLE_HOME) is used for the database instance that is created

from the snapshot volumes.

Note In the examples shown here, the home directory is /rep/oracle in the local disk

group, localdg. If required, you could instead choose to use the same file paths and

database name as on the primary host.

2. In the local disk group, localdg, use the following command to create the volumes that are

to be used for the redo logs and archived logs of the replicated database:

# vxassist -g diskgroup make volume size

For example, to create a 1-gigabyte redo log volume rep_dbase_logs and a 2-gigabyte

archived log volume rep_dbase_arch:

# vxassist -g localdg make rep_dbase_logs 1g

# vxassist -g localdg make rep_dbase_arch 2g

3. Make the file systems for the redo logs and archive logs in the volumes created in the previous

step using the following command:

# mkfs -F vxfs /dev/vx/rdsk/diskgroup/volume

In this example, the commands would be:

# mkfs -F vxfs /dev/vx/rdsk/localdg/rep_dbase_logs

# mkfs -F vxfs /dev/vx/rdsk/localdg/rep_dbase_arch