SAP Note 1705945 - Determining required restoration files

Component : SAP HANA Backup & Recovery -

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

Summary :
To efficiently restore an SAP HANA database, all necessary data and log backup files must be accessible in the filesystem at commencement. If backups are not directly accessible, they must be relocated to a suitable filesystem. The tool, hdbbackupdiag, is pivotal in listing essential backup files for restoration. Prerequisites include SAP HANA database version 1.00.30 or higher and, operationally, the user must log on as adm. hdbbackupdiag aids in identifying and utilizing both data and log backups depending on availability of the BackupCatalog.xml, facilitating database restoration to its latest feasible state.

Key words :
log_backup_<volume id>_<partition id>_ <firstredologposition>_<lastredologposition>, /usr/sap/to2/hdb02/backup/data/thursday_databackup_0_1backup time, /usr/sap/to2/hdb02/backup/data/thursday_databackup_1_1backup time, /usr/sap/to2/hdb02/backup/data/thursday_databackup_2_1backup time, /usr/sap/to2/hdb02/backup/data -, sap hana database creates log backups automatically, solution overviewdata backupsa file backup consists, <prefix>_databackup_<volume id>_<index>, /sys/global/hdb/metadata, /sys/global/hdb/metadata -

Related Notes :

1817703Archiving file system-based backups
1749467Copying SAP HANA From a Multiple- to a Single-Host System
1642148FAQ: SAP HANA Database Backup & Recovery