Skip to main content

Restore data (backup vertica 7.1.2) to new instance (restore vertica 7.2.1)

  • February 19, 2016
  • 2 replies
  • 17 views
bermud

Can't restore data from backup 

1 RHEL 7 vertica 7.1.2 

2. UBUNTU 15.10 vertica 7.2.1

 

 /opt/vertica/bin/vbr.py -t restore  -c dbmain.ini

Starting full restore of database dbmain.

Participating nodes: v_dbmain_node0001.

Error: No restore points in backup location for snapshot dbmain.

Restore FAILED.

 

how to restore data from backup?

    2 replies

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • February 21, 2016

     Is the source and target db the same ? 

    IP is the same ?

    NodeName is the same ? 

    DB name is the same ?

    Directory paths are the same ? 

     

    Check this page for more details:

    http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/RestoringFullDatabaseBackups.htm 

     

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • February 21, 2016

    Hi,

     

     Vertica supports restore actions only to the same exact version of Vertica that created the backup. Please visit the following URL for more information

     

    http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/BackingUpAndRestoringTheDatabase.htm%3FTocPath%3DAdministrator's%2520Guide%7CBacking%2520Up%2520and%2520Restoring%2520the%2520Database%7C_____0

     

     

     

    Thank you,

     Sruthi

     

     

     

     

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement