VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
431
Creating Storage Checkpoints Using dbed_ckptcreate
You can use the VERITAS Storage Foundation for Oracle dbed_ckptcreate command to
create a Storage Checkpoint from the command line. Storage Checkpoints can be either online,
offline, or instant. By default, Storage Checkpoints are offline. If online is specified, the database
is put into hot-backup mode when the Storage Checkpoint is created. If offline is specified, the
database is expected to be down. If instant is specified, the database must be online and a
Storage Checkpoint will be taken for a “crash recovery”-type Storage Rollback.
Prerequisites
◆ You must be logged on as the database administrator (typically, the user ID oracle).
◆ For best recoverability, always keep ARCHIVELOG mode enabled when you create Storage
Checkpoints.
Usage Notes
◆ dbed_ckptcreate stores Storage Checkpoint information under the following directory:
/etc/vx/vxdba/$ORACLE_SID/checkpoint_dir
◆ See the dbed_ckptcreate(1M) manual page for more information.
▼ To create Storage Checkpoints while the database is online
Use the dbed_ckptcreate command as follows:
$ /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product/9i -o online
Creating online Storage Checkpoint of database PROD.
Storage Checkpoint Checkpoint_971672042 created.
▼ To create Storage Checkpoints without updating the VxDBA repository while the database is
online
Use the dbed_ckptcreate command as follows:
$ /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product/9i -o online -n
Creating online Storage Checkpoint of database PROD.
Storage Checkpoint Checkpoint_971672043 created.