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:

  To create Storage Checkpoints without updating the VxDBA repository while the database is online

Use the dbed_ckptcreate command as follows:

  To create Storage Checkpoints while the database is offline

1. Use the dbed_ckptcreate command as follows:
   $ /opt/VRTS/bin/dbed_ckptcreate -S PROD \
   -H /oracle/product/9i -o offline
   Creating offline Storage Checkpoint of database PROD.
   Storage Checkpoint Checkpoint_971672044 created.

   ---

     Note    The default option is online.

   ---

  To create an instant Storage Checkpoints

Ensure that the database is online and use the dbed_ckptcreate command as follows:

  To assign a Storage Checkpoint allocation policy to a Storage Checkpoint

Use the dbed_ckptcreate command as follows: