Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

vxdg deport $snapdg
# Copy the archive logs that were generated while the database was
# in hot backup mode (as reported by the Oracle Server Manager) to the
# archive log location for the replica database on the OHP node
# (in this example, /rep/archlog).
rcp ${arch_loc}/* $dbnode:${rep_mnt_point}${arch_loc}
# The snapshots of the database can be now imported on the OHP node
# and used to complete, recover and start the replica database.
# Note: Replace “rsh” with “remsh” on HP-UX systems.
rsh $dbnode -c “startdb.sh $vollist”
Script to complete, recover and start a replica Oracle
database
Use this script to complete, recover and start a replica Oracle database.
#!/bin/ksh
#
# script: startdb.sh <list_of_database_volumes>
#
# Sample script to complete, recover and start replica Oracle database.
#
# It is assumed that you have already performed the following
# steps:
# 1. Create the local volumes, file systems, and mount points for the
# redo and archived logs, and then mount them.
# 2. Based on the text control file for the production database,
# write a SQL script that creates a control file for the replica
# database.
# 3. Create an initialization file for the replica database and place
# this in the replica database’s $ORACLE_HOME/dbs directory.
# 4. Copy the Oracle password file for the production database to the
# replica database’s $ORACLE_HOME/dbs directory.
export ORACLE_SID=REP1
export ORACLE_HOME=/rep/oracle/816
521Files and scripts for sample scenarios
Script to complete, recover and start a replica Oracle database