When to Back up the Database
In addition to any guidelines established by your enterprise, OpenText recommends that you back up your database in the following circumstances:
Before:
- You upgrade Vertica to another release.
- You drop a partition.
- You add, remove, or replace nodes in your database cluster.
After:
- You load a large volume of data.
- You add, remove, or replace nodes in your database cluster.
- You recover a cluster from a crash.
If:
The epoch in the latest backup is earlier than the current ancient history mark.
Note: Always create a new full backup after adding, removing, or replacing nodes. When you restore a full database backup, you must restore to a cluster that is identical to the one on which you created the backup.
Ideally, schedule ongoing backups to back up your data. You can run the Vertica vbr
from a cron
job or other task scheduler.
Related Terms
- Ancient history mark (AHM).