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

Examples

List details for all restore points in your database:

=> SELECT * FROM ARCHIVE_RESTORE_POINTS;
                  id                  |         save_time          | index |     archive     |  state 
--------------------------------------+----------------------------+-------+-----------------+----------
 2616f6cd-e98c-472c-8d5c-a7f459dff82b | 2023-11-30 10:19:58.565311 |     1 | vertica-restore | COMPLETE
 116066cc-29cb-4ce5-9a27-170538ba95cf | 2023-11-10 11:02:48.059941 |     2 | vertica-restore | COMPLETE
(2 rows)