Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

snapshot is no longer needed, the database administrator can import the original
snapshot back to the primary host and resynchronize the snapshot to the original
database volumes. Database FlashSnap commands are executed from the command
line interface.
Database FlashSnap advantages
Database FlashSnap provides the following advantages:
■ The database snapshot can be used on the same host as the production database
or on a secondary host sharing the same storage.
■ In many companies, there is a clear separation between the roles of system
administrators and database administrators. Creating database snapshots
typically requires superuser (root) privileges, the privileges that database
administrators do not usually have. Because superuser privileges are not
required, Database FlashSnap overcomes these obstacles by enabling database
administrators to easily create consistent snapshots of the database.
Database Storage Checkpoints for recovery
A Database Storage Checkpoint creates an exact image of a database instantly
and provides a consistent image of the database from the point in time the
Database Storage Checkpoint was created. The Database Storage Checkpoint
image is managed and available through the command line interface (CLI).
Because each Database Storage Checkpoint is a consistent, point-in-time image
of a file system, Storage Rollback is the restore facility for these on-disk backups.
Storage Rollback rolls back the changed blocks that are contained in a Database
Storage Checkpoint into the primary file system for faster database restoration.
The combination of data redundancy (disk mirroring) and Database Storage
Checkpoints is recommended for highly critical data to protect them from both
physical media failure and logical errors.
Advantages and limitations of Database Storage Checkpoints
Database Storage Checkpoints and rollback provides the following advantages:
■ Initially, a Database Storage Checkpoint contains no data—it contains only the
inode list and the block map of the primary fileset. The block map points to
the actual data on the primary file system.
■ Because only the inode list and block map are needed and no data is copied,
creating a Database Storage Checkpoint takes only a few seconds and very
little space.
About point-in-time copies
Database snapshot and backup options
124