Creating Storage Checkpoints using dbed


Creating Storage Checkpoints using dbed_ckptcreate
Prev	Appendix B. Storage Foundation for Databases (SFDB) tools command line interface	Next

Creating Storage Checkpoints using dbed_ckptcreate

You can use the 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.

Before creating a Storage Checkpoint, the following conditions must be met:

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	The dbed_ckptcreate command stores Storage Checkpoint information in the SFDB repository. 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 -o online

Storage Checkpoint Checkpoint_971672042 created.

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

Use the dbed_ckptcreate command as follows:

$ /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product -o online -n

Storage Checkpoint Checkpoint_971672043 created.

To create Storage Checkpoints while the database is offline

Use the dbed_ckptcreate command as follows:

$ /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product -o offline

Storage Checkpoint Checkpoint_971672044 created.

The default option is offline.

To create instant Storage Checkpoints

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

$ /opt/VRTS/bin/dbed_ckptcreate -S PROD \
-H /oracle/product -o instant

Storage Checkpoint Checkpoint_971672045 created.

Prev	Up	Next
Updating the repository using dbed_update	Home	Scheduling Storage Checkpoints using dbed_ckptcreate and cron