vbr - cannot init for the second database

chaofeng_li

hi everyone ,
i am new to vertica . when i init a backup directory ( for the 2nd database in the cluster ) , i got an error bellow :
[dbadmin@vertica_bak ~]$ vbr -t init -c ./full_backup_vdb2.ini Error: Configured database name 'vdb2' not found in cluster. Available: vdb Init FAILED.

but i am sure there a vbd2 in the cluster , below shows that :
[dbadmin@vertica1 ~]$ admintools -t list_allnodes Node | Host | State | Version | DB -----------------+----------------+-------+------------------+------ v_vdb2_node0001 | 192.168.56.201 | UP | vertica-10.0.0.0 | vdb2 v_vdb2_node0002 | 192.168.56.202 | UP | vertica-10.0.0.0 | vdb2 v_vdb2_node0003 | 192.168.56.203 | UP | vertica-10.0.0.0 | vdb2 v_vdb_node0001 | 192.168.56.202 | DOWN | vertica-10.0.0.0 | vdb

I can not understand why this issue occur , can anyone help me ?
thank you very much .

Nimmi_gupta

Can you share the .ini file (full_backup_vdb2.ini) ? Make sure you have configured the right DB in .ini.
If possible also share admintools.conf from /opt/vertica/config

chaofeng_li

@Nimmi_gupta said:
Can you share the .ini file (full_backup_vdb2.ini) ? Make sure you have configured the right DB in .ini.
If possible also share admintools.conf from /opt/vertica/config

Hi , before i share the ini file , i have some question . maybe i didn't understand the key of backup clearly .
1、should i take the backup on database server or backup server ? I copy one database VM server as backup server , and then i issue backup action on backup server , so i think this is the point why my backup goes wrong .

2、because i copied a database VM server as backup server , so i can run admintools on backup server . and i can see the database created before . but cann't see the database created later . this action is wrong , right ? should i run nothing on backup server ?

3、as i running admintools on backup server , i create a new database while the database cluster has one another running database . of course it 's failed . but , the running database on the correct cluster is removed after i running create database on backup server , but the physical file was reside on the disk . it's a dangerous operation . so , the database is removed from cluster , but the physical file was there , is there a way restore the physical file to database just like cold backup/recover ?

thank you very much .

Nimmi_gupta

I would recommend to review the backup document and below is the link.
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/TypesOfBackups.htm?tocpath=Administrator's Guide|Backing Up and Restoring the Database|Creating Backups|_____1

chaofeng_li

@Nimmi_gupta said:
I would recommend to review the backup document and below is the link.
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/TypesOfBackups.htm?tocpath=Administrator's Guide|Backing Up and Restoring the Database|Creating Backups|_____1

yes , tks . i have readed the document serval times except hard-link local backup . and will going on review it .
thankyou .