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

34 Online database backup
Making a backup of an online database on the same host
Note: This step sets up the snapshot volumes ready for the backup cycle,
and starts tracking changes to the original volumes. When you are ready to
make a backup, proceed to step 2.
2 Suspend updates to the volumes. Oracle supports online backup by
temporarily suspending updates to the datafiles of the tablespaces, provided
that the database is running in archive mode and the tablespaces are online.
As the Oracle database administrator, put each tablespace into hot backup
mode using a script such as that shown in “Script to put an Oracle database
into hot backup mode” on page 65.
3 Refresh the contents of the snapshot volumes from the original volume
using the following command:
# vxsnap -g volumedg refresh snapvol source= vol \
[
snapvol2 source= vol2 ]...
For example, to refresh the snapshots svol1, svol2 and svol3:
# vxsnap -g dbasedg refresh svol1 source=vol1 \
svol2 source=vol2 svol3 source=vol3
4 Release all the tablespaces or databases from suspend, hot backup or
quiesce mode. As the Oracle database administrator, release all the
tablespaces from hot backup mode using a script such as that shown in
“Script to end Oracle database hot backup mode” on page 66.
5 Back up the snapshot volume. If you need to remount the file system in the
volume to back it up, first run
fsck on the volume. The following are sample
commands for checking and mounting a file system:
# fsck -F vxfs /dev/vx/rdsk/ snapvoldg / snapvol
# mount -F vxfs /dev/vx/dsk/ snapvoldg / snapvol mount_point
Back up the file system at this point using a command such as bpbackup in
Symantec NetBackup. After the backup is complete, use the following
command to unmount the file system.
# unmount mount_point
Repeat steps 2 through 5 each time that you need to back up the volume.
In some instances, such as recovering the contents of a corrupted volume, it may
be useful to resynchronize a volume from its snapshot volume (which is used as
a hot standby):
# vxsnap -g diskgroup restore volume source= snapvol \
destroy=yes|no
The destroy attribute specifies whether the plexes of the snapshot volume are
to be reattached to the original volume. For example, to resynchronize the
volume dbase_vol from its snapshot volume snap2_dbase_vol without
removing the snapshot volume:
# vxsnap -g dbasedg restore dbase_vol \
source=snap2_dbase_vol destroy=no