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

Online Database Backup

Online backup of a database can be implemented by configuring either the primary host or a

dedicated separate host to perform the backup operation on snapshot mirrors of the primary host’s

database.

Two backup methods are described in the following sections:

◆ Making a Backup of an Online Database on the Same Host

◆ Making an Off-Host Backup of an Online Database

Note All commands require superuser (root) or equivalent privileges, except where it is

explicitly stated that a command must be run by the database administrator.

For more information about using snapshots to back up DB2, Oracle and Sybase databases, see the

corresponding Database Administrator’s Guide that accompanies the VERITAS Storage

Foundation for DB2, Oracle or Sybase software.

The following sections include sample scripts:

◆ “Script to Initiate Online Off-Host Oracle Database Backup” on page 67

◆ “Script to Put Oracle Database into Hot Backup Mode” on page 69

◆ “Script to Quiesce Sybase ASE Database” on page 70

◆ “Script to Suspend I/O for a DB2 Database” on page 71

◆ “Script to End Oracle Database Hot Backup Mode” on page 72

◆ “Script to Release Sybase ASE Database from Quiesce Mode” on page 73

◆ “Script to Resume I/O for a DB2 Database” on page 74

◆ “Script to Perform Off-Host Backup” on page 75