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 Oracle Database into Hot Backup Mode
• Script to Quiesce Sybase ASE Database
• Script to Suspend I/O for a DB2 Database
• Script to End Oracle Database Hot Backup Mode
• Script to Release Sybase ASE Database from Quiesce Mode
• Script to Resume I/O for a DB2 Database
• Script to Create an Off-Host Replica Oracle Database
• Script to Complete, Recover and Start Replica Oracle Database
• Script to Start Replica Sybase ASE Database