Veritas FlashSnap Point-In-Time Copy Solutions 5.0.1 Administrators Guide, HP-UX 11i v3, First Edition, November 2009

# 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).

# Move the snapshot volumes into a separate disk group.

vxdg split $dbasedg $snapdg $snapvollist

# Deport the snapshot disk group.

vxdg deport $snapdg

# The snapshots of the database can be imported and backed up

# on the OHP node and then deported.

# Note: Replace “rsh” with “remsh” on HP-UX systems.

rsh $dbnode -c “do_backup.sh $snapvollist”

# Import the snapshot disk group -- if the database disk group is

# cluster-shareable, you must also specify the -s option.

vxdg import $snapdg

# Join the snapshot disk group to the original volume disk group.

vxdg join $snapdg $dbasedg

# Restart the snapshot volumes.

for i in ‘echo $snapvollist‘

vxrecover -g $dbasedg -m $i

vxvol -g $dbasedg start $i

done

# Reattach the snapshot volumes ready for the next backup cycle.

vxsnap -g $dbasedg reattach $volsnaplist

Files and scripts for sample scenarios

Script to initiate online off-host backup of an Oracle database