How to restore backup data on other vertica DB ?

ashu123

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.

ashu123

hello jim
Need help from you !!

Jim_Knicely

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?

ashu123

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.

Jim_Knicely

Are you running the command as dbadmin?

Please ensure that each server can passwordless ssh to each other as the dbadmin user.

ashu123

yes running the command as dbadmin. Its single node server