SAP HANA DB restore fails with backup file not found error

 

Hi All,

During the SAP HANA Tenant database restore getting below error.

HANA DB restore from a data backup fails with the following error in backup.log 

2020-08-07  T00:40:59-05:00 P082693 15fd2cb49f5 ERROR RECOVERY RECOVER DATA finished with error: [448] recovery could not be completed, volume 0, reached log position 0, [2000004] Cannot open file ""<root>/COMPLETE_DATA_BACKUP_databackup_databackup_0_1" ((closed, mode= R, access= rw-r-----, flags= DIRECT|MUST_EXIST| MULTI_WRITERS| UNALIGNED_SIZE),  factory= (root="/hana/data/<sid>/backup/" (access= rw-r-----, flags= AUTOCREATE_PATH|DISKFULL_ERROR, usage=DATA_BACKUP, fs= xfs, config=(async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64))",rc=2: No such file or directory

Solution:

As in this case, the prefix/<databackup-name> was COMPLETE_DATA_BACKUP; the data backup name COMPLETE_DATA_BACKUP should be specified in recovery and not COMPLETE_DATA_BACKUP_databackup. Recovery was completed successfully with the following command.

RECOVER DATA USING FILE ('/hana/data/<sid>/backup/COMPLETE_DATA_BACKUP') CLEAR LOG