Tech Tip: How do I restore my vertica database

Document created by Joe_R Employee on Oct 4, 2014Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

Issue:

 

In the event of a vertica crash, how can I restore my vertica database to a good backup

 

Answer:

Assuming backups have been previously configured per the documentation,  please follow these steps to restore the database …

 

  1. cd /opt/vertica/bin/

  2. As the dradmin (or equivalent user) run:  ./vbr.py --task restore --config-file  <filename>.ini

 

Note<filename>.ini represents the backup configuration file created when you configured your backups.  To locate this file, if you don’t know where it, is do the following …

 

  1. crontab -l to show the crontab entry from the configured backup script

             Example: crontab -l

00 02 * * * /export/dradmin/backups/backup_script.sh >/tmp/backup.log 2>&1

      2.    cat /export/dradmin/backups/backup_script.sh

             Example:  cat  /export/dradmin/backups/backup_script.sh

/opt/vertica/bin/vbr.py --task backup --config-file /export/dradmin/backups/backup.ini

 

As you can see the backup.ini file is in /export/dradmin/backups/ so the command that would need to be run to restore the vertica database would be:

 

./vbr.py --task restore --config-file /export/dradmin/backups/backup.ini

1 person found this helpful

Attachments

    Outcomes