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

Chapter
5
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” 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 create an off-host replica Oracle database” on page 68
■ “Script to complete, recover and start a replica Oracle database” on page 70