Additional Commands for Managing Checkpoints
Here are other commands for managing checkpoints and their associated files.
1. Delete the oldest checkpoint by using the alterdb ‑delete_oldest_ckp flag:
alterdb dbname -delete_oldest_ckp
The oldest checkpoint, including related journal and dump files, is deleted.
Warning! The –delete_oldest_ckp will delete the oldest checkpoint, even if you have only two. While you may think you have four, the number of entries in the configuration file is the determining factor. For this reason we recommend the ‑keep flag instead of -delete_oldest_ckp.
2. Delete invalid checkpoints by using the alterdb ‑delete_invalid_ckp flag. Use this in cases where ckpdb failed:
alterdb dbname -delete_invalid_ckp
Invalid checkpoints and associated journal and dump files are deleted. This command does not delete journal files unless they are for the oldest referenced and invalid checkpoint, so as to preserve the continuous journal sequence.
3. Delete all previous checkpoints by using the ckpd ‑d flag. Such a command may be useful on occasion:
ckpdb -d dbname
A checkpoint is taken and all previous checkpoint, journal, dump files, and configuration entries are deleted.