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

Creating a Replica Database on the Same Host
50 VERITAS FlashSnap Point-In-Time Copy Solutions Administrator’s Guide
3. 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.
If you are using Sybase ASE 12.5, you can specify the for external dump clause to
the quiesce command. This warm standby method allows you to update a replica
database using transaction logs dumped from the primary database. See “Updating a
Warm Standby Sybase ASE 12.5 Database” on page 59 for more information.
4. 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
5. If you temporarily suspended updates to volumes in step 2, 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.