Vertica database restore failing

Document ID : KB000008547
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When attempting a restore of the vertica database the following error is seen:

Loading snapshot catalog from backup.

Error: SQL command "select load_snapshot_prep('new_schema_db_backup', 'CREATE_OR_REPLACE', '', '####');" failed: ERROR 6651:  Backup node [####] is not found in this cluster

Restore FAILED.

Environment:
CAPM 3.x
Resolution:

This is an indication that the "NodeMapping" section is missing from the backup configuration ini file that was created when you setup your backup.  You could add the following to the ini file:

 

[NodeMapping]

v_drdata_node0001 = v_drdata_node0001

v_drdata_node0002 = v_drdata_node0002

v_drdata_node0003 = v_drdata_node0003

 

... then run the restore again

 

See the "Additional Information" section for more information about the NodeMapping section

 

 

Additional Information:

See the following URL for additional information on the NodeMapping section of the backup configuration file:

https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/ConfigFileReference/[NodeMapping].htm