Veritas FlashSnap Point-In-Time Copy Solutions 5.0 AdministratorÆs Guide, HP-UX 11i v3, First Edition, May 2008

Chapter
3
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 Oracle databases, see
the corresponding Database Administrator’s Guide that accompanies the
Veritas Storage Foundation for Oracle software.
The following sections include sample scripts:
■ “Script to initiate online off-host backup of an Oracle database” on page 63
■ “Script to put an Oracle database into hot backup mode” on page 65
■ “Script to end Oracle database hot backup mode” on page 66
■ “Script to end Oracle database hot backup mode” on page 66
■ “Script to end Oracle database hot backup mode” on page 66
■ “Script to perform off-host backup” on page 67
■ “Script to perform off-host backup” on page 67
■ “Script to perform off-host backup” on page 67