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

Note: This step sets up the snapshot volumes, and starts tracking changes to

the original volumes.

When you are ready to create the replica database, proceed to step 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 the example. Note that to allow recovery from any

backups taken from snapshots, the database must be in LOGRETAIN

RECOVERY mode.

See “Script to suspend I/O for a DB2 database” on page 88.

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

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

Decision support

Creating a replica database on the same host