ARCHIVE_RESTORE_POINTS

Eon Mode only

Lists information about In-DB restore points.

Column Name Column Type Description
ID INT Unique object ID of the restore point.
SAVE_TIME DATETIME Time at which the restore point was saved.
INDEX INT Index of the restore point in the archive, where 1 specifies the most recent restore point.
ARCHIVE VARCHAR Name of the archive that contains the restore point.
STATE VARCHAR

Status of the restore points, one of the following:

  • SAVING
  • COMPLETE
  • REMOVING
VERTICA_VERSION VARCHAR Version of Vertica that saved the restore point.
OBJECT_INCLUSION_RULES VARCHAR Object inclusion rules for the restore point. Empty for full-database restore points that do not use object inclusion rules.
DATA_INCLUSION_RULES VARCHAR Data inclusion rules for the restore point. Empty if no data inclusion rules are set.

Examples

List details for all restore points in your database:

=> SELECT * FROM ARCHIVE_RESTORE_POINTS;
                  id                  |         save_time          | index |   archive   |  state   | vertica_version | object_inclusion_rules | data_inclusion_rules
--------------------------------------+----------------------------+-------+-------------+----------+-----------------+------------------------+---------------------
 2616f6cd-e98c-472c-8d5c-a7f459dff82b | 2026-08-30 10:19:58.565311 |     1 | object_bak  | COMPLETE | v26.4.0         | INCLUDE SCHEMA store   |
 116066cc-29cb-4ce5-9a27-170538ba95cf | 2026-08-10 11:02:48.059941 |     2 | full_backup | COMPLETE | v26.4.0         |                        |
(2 rows)