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

Appendix A, Files and Scripts for Sample Scenarios

Script to Initiate Online Off-Host Oracle Database Backup

#!/bin/ksh

# script: backup_online.sh <dbnode>

# Sample script for online, off-host backup.

# Note: This is not a production level script, its intention is to help

# you understand the procedure and commands for implementing

# an off-host point-in-time copy solution.

export ORACLE_SID=dbase

export ORACLE_HOME=/oracle/816

export PATH=$ORACLE_HOME/bin:$PATH

dbnode=$1

dbasedg=dbasedg

snapvoldg=snapdbdg

vollist=”dbase_vol”

snapvollist=”snap_dbase_vol”

volsnaplist=”snap_dbase_vol source=dbase_vol”

exit_cnt=0

arch_loc=/archlog

# Put the Oracle database in hot-backup mode;

# see the backup_start.sh script for information.

su oracle -c backup_start.sh

# Refresh the snapshots of the volumes.

# Note: If the volume is not mounted, you can safely ignore the

# following message that is output by the snapshot operation:

# ERROR: Volume dbase_vol: No entry in /etc/mnttab for volume

vxsnap -g $dbasedg refresh $volsnaplist

# Take the database out of hot-backup mode;

# see the backup_end.sh script for information.

su oracle -c backup_end.sh

# Back up the archive logs that were generated while the database

# was in hot backup mode (as reported by the Oracle Server Manager).

# Wait for synchronization of the snapshot volumes to complete.

for i in `echo $snapvollist`

vxsnap -g $dbasedg syncwait $i

done