Veritas FlashSnap Point-In-Time Copy Solutions 5.0 AdministratorÆs Guide, HP-UX 11i v3, First Edition, May 2008

Appendix

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 51.

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