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

Making a Backup of an Online Database on the Same Host
30 VERITAS FlashSnap Point-In-Time Copy Solutions Administrator’s Guide
2. If the volumes to be backed up contain database tables in file systems, suspend updates to the
volumes:
◆ DB2 provides the write suspend command to temporarily suspend I/O activity for a
database. As the DB2 database administrator, use a script such as that shown in “Script to
Suspend I/O for a DB2 Database” on page 71. Note that to allow recovery from any
backups taken from snapshots, the database must be in LOGRETAIN RECOVERY mode.
◆ 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 Oracle Database into Hot Backup
Mode” on page 69.
◆ Sybase ASE from version 12.0 onward provides the Quiesce feature to allow temporary
suspension of writes to a database. As the Sybase database administrator, put the database
in quiesce mode by using a script such as that shown in “Script to Quiesce Sybase ASE
Database” on page 70.
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. If you temporarily suspended updates to volumes in step 1, release all the tablespaces or
databases from suspend, hot backup or quiesce mode:
◆ As the DB2 database administrator, use a script such as that shown in “Script to Resume
I/O for a DB2 Database” on page 74.
◆ 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 72.
◆ As the Sybase database administrator, release the database from quiesce mode using a
script such as that shown in “Script to Release Sybase ASE Database from Quiesce Mode”
on page 73.
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