How to restore backup data on other vertica DB ?

edited May 2018 in General Discussion

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.

Comments

  • hello jim
    Need help from you !!

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    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?

  • 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_KnicelyJim_Knicely - Select Field - Administrator

    Are you running the command as dbadmin?

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

  • yes running the command as dbadmin. Its single node server

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file