ALL_RESTORE_POINTS

Provides information about all restore points.

Provides information about existing restore points.

Column Name Data Type Description
RP_ID INTEGER The unique identifier for the restore point.
RP_OID INTEGER The current identifier of the restore point. This can change if the cluster is restarted.
ARCHIVE_OID INTEGER The identifier for the archive.
STATE VARCHAR

Can be one of the following states:

  • SAVING

  • COMPLETE

  • REMOVING

SAVE_TIME VARCHAR The time at which the restore point was saved.
CATALOG_VERSION VARCHAR The catalog version that was saved.
VERTICA_VERSION VARCHAR The version of Vertica for the restore point.