VERITAS FlashSnap Point-In-Time-Copy Solutions Administrator's Guide

Chapter 5, Decision Support

Creating a Replica Database on the Same Host

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 59 for more information.

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

Note On Linux, use the -t option, and on AIX, use the -V option, instead of the -F option

for both commands.

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

◆ For a Sybase ASE database, if you specified the for external dump clause when you

quiesced the database, use the following isql command as the database administrator to

dump the transaction log for the database:

dump transaction to dump_device with standby_access

Then copy the dumped transaction log to the appropriate replica database directory.

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 Replica Oracle Database” on page 78.

◆ For a Sybase ASE database, use a script such as that shown in “Script to Start Replica

Sybase ASE Database” on page 80.

If you are using the warm standby method, specify the -q option to the dataserver

command. Use the following isql commands to load the dump of the transaction log and

put the database online:

load transaction from dump_device with standby_access

online database database_name for standby_access