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

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

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

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 75.

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

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

71Decision support

Creating an off-host replica database