SAP Note 1812057 - Reconstruction of the backup catalog using hdbbackupdiag

Component : SAP HANA Backup & Recovery -

Solution : https://service.sap.com/sap/support/notes/1812057 (SAP Service marketplace login required)

Summary :
If the SAP HANA database recovery fails, indicating an undetermined recovery strategy and missing catalog backup as per "backup.log" errors, it's likely due to the non-availability or defectiveness of the backup catalog. Users with SAP HANA Revision 54 or higher can address this using "hdbbackupdiag" to regenerate the backup catalog. The program should be run with options to specify the directories of data and log backups, which then allows for regeneration of the backup catalog comprehensively, enabling subsequent database recovery. Directories must be absolute paths, and the system recursively processes them to create an updated backup catalog.

Key words :
customer component han-db-bac sap hana backup & recovery priority recommendations / additional info category faq validity, file-based backup catalog naming 1817703   archiving file system-based backups 1816483   restore, hdbbackupdiag --generate --datadir $dir_instance/backup/data --logdirs $dir_instance/backup/log -, hdbbackupdiag --generate --datadir $dir_instance/backup/data --logdirs $dir_instance/backup/log, missing 1817703   archiving file system-based backups 1749467   copying sap hana, file-based backup catalog naming 1910535   recovery, standard directory $dir_instance/backup/log, revision 45 1749467   copying sap hana, sap hana database fails, --generate           --datadir <directory

Related Notes :

1910535Recovery of SAP HANA database not possible
1852242Confusion about file-based backup catalog naming
1817703Archiving file system-based backups
1816483Restore when log backups are missing
1812980Changes to the backup catalog as of Revision 45
1749467Copying SAP HANA From a Multiple- to a Single-Host System