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

■ A Database Storage Checkpoint keeps track of block change information and
thereby enables incremental database backup at the block level.
■ A Database Storage Checkpoint helps recover data from incorrectly modified
files.
■ A Database Storage Checkpoint can be mounted, allowing regular file system
operations to be performed. Mountable Database Storage Checkpoints can be
used for a wide range of application solutions that include backup,
investigations into data integrity, staging upgrades or database modifications,
and data replication solutions.
The limitations of Database Storage Checkpoints are as follows:
■ Database Storage Checkpoints can only be used to restore from logical errors
(for example, a human error).
■ Because all the data blocks are on the same physical device, Database Storage
Checkpoints cannot be used to restore files due to a media failure. A media
failure requires a database restore from a tape backup or a copy of the database
files that are kept on a separate medium.
About Veritas Database FlashSnap
Database FlashSnap lets you capture an online image of an actively changing
database at a given instant, known as a snapshot. You can then perform backups
and off-host processing tasks on these snapshots while still maintaining
continuous availability of your critical data. Database FlashSnap offers you a
flexible way to efficiently manage multiple point-in-time copies of your data, and
reduce resource contention on your business-critical servers.
A database snapshot can be used on the same host as the production database or
on a secondary host sharing the same storage.
A database snapshot can be used for the following off-host processing applications:
■ Data backup
■ Data warehousing
■ Decision-support queries
When the 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.
Reverse resynchronization is:
■ Supported for single instance Oracle environments
125About point-in-time copies
About Veritas Database FlashSnap