Data Repository vertica database won't start
search cancel

Data Repository vertica database won't start


Article ID: 105675


Updated On:


CA Infrastructure Management CA Performance Management - Usage and Administration


Vertica data base is down.
When I tried to start the database, got following errors:
*** Starting database: dr *** Starting nodes: v_dr_node0001 ( Starting Vertica on all nodes. Please wait, databases with large catalog may take a while to initialize. failed. Result: status=1 host= content={u'command_list': [u'/opt/vertica/bin/vertica', u'-D', u'/opt/CA/catalog/dr/v_dr_node0001_catalog', u'-C', u'dr', u'-n', u'v_dr_node0001', u'-h', u'', u'-p', u'5433', u'-P', u'4803', u'-Y', u'ipv4'], u'db_log_path': u'/opt/CA/catalog/dr/dbLog', u'start_stdout': None, u'special_environment': None, u'return_code': 1, u'start_stderr': None} Check /opt/CA/catalog/dr/dbLog for more information.


CAPM 3.5 on Linux
Vertica 8.1.0-4
single node vertica install.


the database catalog is corrupt.


Restore db from backup:
/opt/vertica/bin/ --task restore --config-file /home/dradmin/backup_snapshot.ini --archive 20180620_070005

Additional Information

You need to just specify date_timestamp suffix of the directory name for the archive parameter. Please see the documentation link below