SAP Knowledge Base Article - Preview

3204140 - Recovery fails using backup id of differential or incremental backup

Symptom

You are doing the recovery using the backup id of differential data backup or incremental data backup like below:

RECOVER DATABASE FOR HK1 UNTIL TIMESTAMP '2022-05-18 01:40:00' 
CLEAR LOG
USING CATALOG PATH ('/usr/sap/HRE/HDB00/backup/log/DB_HK1/') USING LOG PATH ('/hana/backup/log/HRE/DB_HK1/')
USING DATA PATH ('/hana/backup/data/HRE/DB_HK1/') USING BACKUP_ID 1652837792262 CHECK ACCESS USING FILE

And if failed with following error:

RECOVERY RECOVER DATA finished with error: [449] recovery strategy could not be determined, [111014] The backup with backup id '1652837792262' cannot be used for recovery

Images/data in this KBA from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

All HANA revisions

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

backup_id, point in time, PIT, hdbbackupdiag, check access, recovery strategy could not be determined, cannot be used for recovery , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.