Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

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:

■ See “Making a backup of an online database on the same host” on page 156.

■ See “Making an off-host backup of an online database” on page 160.

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:

■ See “Script to initiate online off-host backup of an Oracle database” on page 513.

■ See “Script to put an Oracle database into hot backup mode” on page 515.

■ See “Script to quiesce a Sybase ASE database” on page 516.

Chapter