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
• Script to Put Oracle Database into Hot Backup Mode
• Script to Quiesce Sybase ASE Database
• Script to Suspend I/O for a DB2 Database
• Script to End Oracle Database Hot Backup Mode
• Script to Release Sybase ASE Database from Quiesce Mode
• Script to Resume I/O for a DB2 Database
• Script to Perform Off-Host Backup