How to restore backup data on other vertica DB ?

Forum|Forum|8 years ago
May 5, 2018
5 replies
9 views

+1

ashu123
Participating Frequently

hello!
I have 2 different vertica DB's, I was taken backup of 1 vertica DB and I want to restore this backup data on other vertica DB. Database name, the node name is same on 2 DB's, only ip address is different and also changed ip address in backup file(fullbak.ini)

[user_testing@TPDB ~]$ /opt/vertica/bin/vbr -t restore --config-file /home/user_testing/fullbak.ini 
Starting full restore of database testing.
Participating nodes: v_testing_node0001.
Restoring from restore point: fullbak_20180504_051003

Error: Error getting cluster information from admintools.
Restore FAILED.

+1

ashu123
Author
Participating Frequently
Forum|Forum|8 years ago
May 5, 2018

hello jim
Need help from you !!

Like

+2

Jim_Knicely
Participating Frequently
Forum|Forum|8 years ago
May 7, 2018

Vbr needs to gather cluster details via admintools. It needs to be ran as a dbadmin. Vbr has to connect to both the source and destination. Is that working properly?

Like

+1

ashu123
Author
Participating Frequently
Forum|Forum|8 years ago
May 7, 2018

By mistakenly deleted .gt file, I have backup data, when I'm trying to restore that backup data into db getting this error

[user_testing@TPDB ~]$ /opt/vertica/bin/vbr -t restore --config-file /home/user_testing/backup_snapshot.ini 
Starting full restore of database testing.
Participating nodes: v_testing_node0001.
Restoring from restore point: backup_snapshot_20180507_094136

Error: Error getting cluster information from admintools.
Restore FAILED.