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

Decision support
This chapter includes the following topics:
■ About decision support
■ Creating a replica database on the same host
■ Creating an off-host replica database
About decision support
You can use snapshots of a primary database to create a replica of the database
at a given moment in time. You can then implement decision support analysis
and report generation operations that take their data from the database copy
rather than from the primary database. The FastResync functionality of Veritas
Volume Manager (VxVM) allows you to quickly refresh the database copy with
up-to-date information from the primary database. Reducing the time taken to
update decision support data also lets you generate analysis reports more
frequently.
Two methods are described for setting up a replica database for decision support:
■ Creating a replica database on the same host
■ Creating an off-host replica 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.
The following sections include sample scripts:
■ Script to put an Oracle database into hot backup mode
■ Script to quiesce a Sybase ASE database
5
Chapter