Veritas InfoScale™ 8.0.2 Solutions Guide - AIX

To make a backup of an online Sybase database on the same host

1. If the volumes to be backed up contain database tables in file systems, suspend updates to the volumes. 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.

   #!/bin/ksh
   #
   # script: backup_start.sh
   #
   # Sample script to quiesce example Sybase ASE database.
   #
   # Note: The "for external dump" clause was introduced in Sybase
   # ASE 12.5 to allow a snapshot database to be rolled forward.
   # See the Sybase ASE 12.5 documentation for more information.
   
   isql -Usa -Ppassword -SFMR <<!
   quiesce database tag hold database1[, database2]... [for external dump]
   go
   quit
   !

2. Refresh the contents of the snapshot volumes from the original volume using the following command:

   # vxsnap -g database_dg refresh snapvol source=database_vol \
     [snapvol2 source=database_vol2]...

   For example, to refresh the snapshots snapvol1, snapvol2 and snapvol3:

   # vxsnap -g database_dg refresh snapvol1 source=database_vol1 \
     snapvol2 source=database_vol2 snapvol3 source=database_vol3

3. If you have temporarily suspended updates to volumes, release all the tablespaces or databases from quiesce mode.

   As the Sybase database administrator, release the database from quiesce mode using a script such as that shown in the example.

   #!/bin/ksh
   #
   # script: backup_end.sh
   #
   # Sample script to release example Sybase ASE database from 
   # quiesce mode.
   
   isql -Usa -Ppassword -SFMR <<!
   quiesce database tag release
   go
   quit
   !

4. Back up the snapshot volume. If you need to remount the file system in the volume to back it up, first run fsck on the volume. The following are sample commands for checking and mounting a file system:

   # fsck -V vxfs /dev/vx/rdsk/database_dg/snapvol
   # mount -V vxfs /dev/vx/dsk/database_dg/snapvol
   					mount_point

   Back up the file system at this point using a command such as bpbackup in Veritas NetBackup. After the backup is complete, use the following command to unmount the file system.

   # umount mount_point

5. Repeat steps in this procedure each time that you need to back up the volume.