Veritas FlashSnap Point-In-Time Copy Solutions 5.0.1 Administrators Guide, HP-UX 11i v3, First Edition, November 2009

■ 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 87.

Use the following command to make a full-sized snapshot, snapvol, of the

tablespace volume by breaking off the plexes that you added in step 1 from

the original volume:

# vxsnap -g volumedg make \

source=volume/newvol=snapvol/nmirror=N \

[alloc=storage_attributes]

The nmirror attribute specifies the number of mirrors, N, in the snapshot

volume.

If a database spans more than one volume, specify all the volumes and their

snapshot volumes as separate tuples on the same line, for example:

# vxsnap -g dbasedg make source=vol1/newvol=svol1 \

source=vol2/newvol=svol2 source=vol3/newvol=svol3 \

alloc=ctlr:c3,ctlr:c4

This step sets up the snapshot volumes ready for the backup cycle, and starts

tracking changes to the original volumes.

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 the

example.

See “Script to resume I/O for a DB2 database” on page 89.

■ 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 88.

■ As the Sybase database administrator, release the database from quiesce

mode using a script such as that shown in the example.

See “Script to release a Sybase ASE database from quiesce mode”

on page 89.

On the primary host, use the following command to split the disks containing

the snapshot volumes into a separate disk group, snapvoldg, from the original

disk group, volumedg:

# vxdg split volumedg snapvoldg snapvol ...

49Online database backup

Making an off-host backup of an online database