HANA Backup catalog is the store which keeps the information of all the Backups triggered in the database. It enables the system do to:
- List of Full/Delta/Log Backups completed/failed
- Choose which Data and Log backup to use to recover the database
To view the content of HANA Catalog you can query the table
System Table M_BACKUP_CATALOG
you can use the content of table M_BACKUP_CATALOG to check the status of your last backup, backup_id, start time, end time, etc..
System table M_BACKUP_CATALOG_FILES
You can use table M_BACKUP_CATALOG_FILES column REDO_LOG_POSITION will tell you the point from which redo logs required for recovery after restore of data backup.
DESTINATION_PATH, DESTINATION_TYPE_NAME will say in which location backup is available along with Backup type
