How do I restore my vertica database

Products

• CA Infrastructure Performance
• CA Performance Management

Issue/Introduction

In the event of a Vertica crash, how do I restore my Vertica database to a good backup?

Environment

All supported Performance Management releases

Resolution

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 itis 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