Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

When you are ready to make a backup, proceed to step 2.
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 the example.
See “Script to suspend I/O for a DB2 database” on page 516.
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 the example.
See “Script to put an Oracle database into hot backup mode” on page 515.
■ 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 the example.
See “Script to quiesce a Sybase ASE database” on page 516.
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 have temporarily suspended updates to volumes in 2:
■ As the DB2 database administrator, use a script such as that shown in the
example.
See “Script to resume I/O for a DB2 database” on page 518.
■ As the Oracle database administrator, release all the tablespaces from hot
backup mode using a script such as that shown in the example.
See “Script to end Oracle database hot backup mode” on page 517.
■ As the Sybase database administrator, release the database from quiesce
mode using a script such as that shown in the example.
159Online database backup
Making a backup of an online database on the same host