Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

developers, system testers, and quality assurance groups with a realistic basis
for testing the robustness, integrity, and performance of new applications.
■ Logical Error Recovery
Logical errors caused by an administrator or an application program can
compromise the integrity of a database. You can recover a database by restoring
the database files from a volume snapshot or by recovering logical objects
(such as tables, for example) from a clone database created from volume
snapshots using Database FlashSnap. These solutions are faster than fully
restoring database files from tape or other backup media.
Database FlashSnap
The system administrator needs to configure storage according to the requirements
specified in the snapplan.
Database FlashSnap allows you to check the storage setup against requirements
set forth in the snapplan. Depending on the results, the database administrator
may need to modify the snapplan or the system administrator may need to adjust
the storage configuration. Properly configuring storage is the only aspect of using
Database FlashSnap that requires the system administrator's participation.
Note: In Oracle RAC configurations, Database Flashsnap commands can be run
on the Veritas Cluster Volume Manager master or slave node, and only online
snapshots are supported.
To use Database FlashSnap, a database administrator must first define their
snapshot requirements. For example, they need to determine whether off-host
processing is required and, if it is, which host should be used for it. In addition,
it is also important to consider how much database downtime can be tolerated.
Database snapshot requirements are defined in a file called a snapplan. The
snapplan specifies snapshot options that will be used when creating a snapshot
image (such as whether the snapshot mode will be online, offline, or instant).
After creating the snapplan, the database administrator must validate it to ensure
that it is correct. During validation the snapplan is copied to the repository before
using it to create a snapshot. Depending on the validation results, the database
administrator may need to modify the snapplan or the system administrator may
need to adjust the storage configuration.
After storage is configured as specified in the snapplan and the snapplan has been
validated, the database administrator can create snapshots of the database and
create database clones based on the snapshots. Database clones can also be created
Using Database FlashSnap for backup and off-host processing
About Veritas Database FlashSnap
226