VERITAS FlashSnap Point-In-Time-Copy Solutions Administrator's Guide

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” on page 69

◆ “Script to Quiesce Sybase ASE Database” on page 70

◆ “Script to Suspend I/O for a DB2 Database” on page 71

◆ “Script to End Oracle Database Hot Backup Mode” on page 72

◆ “Script to Release Sybase ASE Database from Quiesce Mode” on page 73

◆ “Script to Resume I/O for a DB2 Database” on page 74

◆ “Script to Create an Off-Host Replica Oracle Database” on page 76

◆ “Script to Complete, Recover and Start Replica Oracle Database” on page 78

◆ “Script to Start Replica Sybase ASE Database” on page 80