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

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 its replica 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:
■ See “Creating a replica database on the same host” on page 178.
■ See “Creating an off-host replica database” on page 184.
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:
■ 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.
15
Chapter