Veritas FlashSnap Point-In-Time Copy Solutions 5.0 AdministratorÆs Guide, HP-UX 11i v3, First Edition, May 2008

50 Decision support
Creating a replica database on the same host
3 If the volumes to be backed up contain database tables in file systems,
suspend updates to the volumes. 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 an Oracle database
into hot backup mode” on page 65.
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
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 66.
6 For each snapshot volume containing tablespaces, check the file system that
it contains, and mount the volume using the following commands:
# fsck -F vxfs /dev/vx/rdsk/diskgroup/snapvol
# mount -F vxfs /dev/vx/dsk/diskgroup/snapvol mount_point
For example, to check the file system in the snapshot volume
snap1_dbase_vol, and mount it on /rep_dbase_vol:
# fsck -F vxfs /dev/vx/rdsk/dbasedg/snap1_dbase_vol
# mount -F vxfs /dev/vx/dsk/dbasedg/snap1_dbase_vol \
/rep_dbase_vol
7 Copy any required log files from the primary database to the replica
database. For an Oracle database, copy the archived log files that were
generated while the database was in hot backup mode to the new database’s
archived log directory (for example, /rep_archlog).
8 As the database administrator, start the new database. For an Oracle
database, use a script such as that shown in “Script to complete, recover and
start a replica Oracle database” on page 70.
When you want to resynchronize a snapshot with the primary database, shut
down the replica database, unmount the snapshot volume, and go back to step 3
to refresh the contents of the snapshot from the original volume.