How to restore backup data on other vertica DB ?

ashu123ashu123 Registered User
edited May 5 in Vertica Forum

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)

[[email protected] ~]$ /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

  • ashu123ashu123 Registered User

    hello jim
    Need help from you !!

  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

    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?

  • ashu123ashu123 Registered User

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

    [[email protected] ~]$ /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 Administrator, Moderator, Employee, Registered User, VerticaExpert

    Are you running the command as dbadmin?

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

  • ashu123ashu123 Registered 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