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

■ Online
■ Offline
■ Instant
Note: Instant Storage Checkpoint is not supported for Oracle RAC.
To create a Storage Checkpoint with the online option, the database should be
online and you must enable ARCHIVELOG mode for the database.
Note: Refer to your Oracle documentation for information about enabling the
archive log.
For the offline option, the database should be offline.
During the creation of the Storage Checkpoint, the tablespaces are placed in
backup mode. Because it only takes a few seconds to take a Storage Checkpoint,
the extra redo logs generated while the tablespaces are in online-backup mode
are very small. You can roll back the entire database or individual tablespaces or
datafiles to an online or offline Storage Checkpoint. After the rollback is complete,
you may roll the database forward to restore the database if you have used an
online Storage Checkpoint.
For the instant option, the database should be online and it can be running in
either ARCHIVELOG or NOARCHIVELOG mode. You can only roll back the entire
database to an instant Storage Checkpoint. Rolling back individual tablespaces
or datafiles to an instant Storage Checkpoint is not possible. After the rollback is
complete, you need to perform database recovery. Rolling the database forward
is not supported; that is, you cannot apply archived redo logs.
Note: To allow the easiest recovery, always keep ARCHIVELOG mode enabled,
regardless of whether the database is online or offline when you create Storage
Checkpoints.
Verifying a Storage Checkpoint
After creating a Storage Checkpoint and before using it to back up or restore a
database, you can verify that the Storage Checkpoint is free of errors.
See the dbed_ckptcreate(1M) and dbed_ckptmount(1M) manual
pages for more information.
Usage notes
201Using Database Storage Checkpoints and Storage Rollback
Backing up and recovering the database using Storage Checkpoints