DX NetOps Manager

Tech Tip: How do I restore my vertica database 

10-04-2014 05:35 PM

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

Statistics
0 Favorited
3 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

10-05-2014 09:10 AM

This tech tip doesn't hint on just recovering without a backup, which is standard practice.

Related Entries and Links

No Related Resource entered.