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, vbr.py displays the following message:



  • Restoring from a Specific Snapshot

The snapshot has to exist before doing this.,

Syntax:

Example:

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:

vbr.py –task restore –config-file

Example:

 
Similar Article  How to fix HP Vertica Installation FAILED with errors
 

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

clickhere

No Comments
Leave a Comment

%d bloggers like this: