Skip to main content
Question

vbr - cannot init for the second database

  • June 10, 2020
  • 4 replies
  • 15 views
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 .

    4 replies

    Nimmi_gupta
    Forum|alt.badge.img
    • Nimmi_gupta
    • Participating Frequently
    • June 10, 2020

    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
    • chaofeng_li
    • Author
    • New Participant
    • June 10, 2020

    @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
    Forum|alt.badge.img
    • Nimmi_gupta
    • Participating Frequently
    • June 10, 2020

    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
    • chaofeng_li
    • Author
    • New Participant
    • June 10, 2020

    @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 .

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement