How to recover a Vertica node from a failed start

How to recover a node from a failed start


In this post we will go over the procedure you need to follow to be able to recover a Vertica database node after a failed start.

During a full database restore, the node must be DOWN. If you start the restore process and the node is UP, displays the following message:

  • Restoring from a Specific Snapshot

The snapshot has to exist before doing this.,



Note: the archive must corresponds with the type of backup done.

You will restore a snapshot created on 2012/09/06 at 15:26:40 sec.
The archive option need to receive the date_timestamp parameter that is appended to the snapshots archive.

Restoring From the Most Recent Snapshot
Syntax: –task restore –config-file


Similar Article  What is Data Manipulation Language in MySql

I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click


No Comments
Leave a Comment

%d bloggers like this: