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

Making an Off-Host Backup of an Online Database
34 VERITAS FlashSnap Point-In-Time Copy Solutions Administrator’s Guide
◆ 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. On the primary host, 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]... syncing=yes
The syncing=yes attribute starts a synchronization of the snapshot in the background.
For example, to refresh the snapshots svol1, svol2 and svol3:
# vxsnap -g dbasedg refresh svol1 source=vol1 svol2 source=vol2 \
svol3 source=vol3 syncing=yes
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. Use the following command to wait for the contents of the snapshot to be fully synchronous
with the contents of the original volume:
# vxsnap -g volumedg syncwait snapvol