Veritas FlashSnap Point-In-Time Copy Solutions 5.0.1 Administrators Guide, HP-UX 11i v3, First Edition, November 2009

Online database backup

This chapter includes the following topics:

■ About online database backup

■ Making a backup of an online database on the same host

■ Making an off-host backup of an online database

About 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 backup of an Oracle database

■ Script to put an Oracle database into hot backup mode

■ Script to quiesce a Sybase ASE database

Chapter