SAP HANA dynamic tiering SP 12: What to do if Backup Cannot Complete

Issue:

You are running SAP HANA dynamic tiering SP 12.

A 447 error like the following appears:

backup could not be completed

[110112] Extended storage backup error:

[SAP][ODBC Driver]There is already a backup

or selective restore in progress. \n

— (dblib/db_backupID.cxx 2213)

Solution:

Backup does not complete because a log backup for point-in-time recovery is underway. Point-in-time log backups are automatic (the error can occur without another user running a backup).

To solve the issue in SP 12, perform this workaround:

1. Query the backup catalog for the state of all log backups that are finished or in progress:

SELECT state_name FROM m_backup_catalog MB, m_backup_catalog_files MBF

WHERE

MB.backup_id = MBF.backup_id

AND

service_type_name = ‘esserver’

AND

entry_type_name = ‘log backup’

2. If a state name in the output displays as “prepared” or “running,” then a dynamic tiering log backup is in progress.

3. When you see the “finish” entry in the output, the log backup is complete and you can run the data backup.

You can query the views M_BACKUP_CATALOG and M_BACKUP_CATALOG_FILES for dynamic tiering data and log backups just as you do for SAP HANA database data and log backups.

For more information on SAP HANA dynamic tiering troubleshooting, see the SAP HANA Dynamic Tiering: Administration Guide.