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.
