Query mechanism problem during SAP HANA recovery

[wangxuan-220]

Hi experts，

When restoring the SAP HANA database using backint, I found a problem. For example, I did one or two full backup at 10:00 and 12:00. When the full backup at 12:00 was completed, a catalog named log_backup_0_0_0_0 was backed up. Now I initiate a recovery to 10:30. Using this catalog, the order of data it inquires starts from the full backup at 12:00, and then looks forward to 10:00. If there are many full backup, this search should affect the efficiency. Moreover, I can query through hdbbackupdiag tool that the data that the recovery time point 10:30 depends on is the full backup at 10:00. Why not just look for the full backup corresponding to 10:00?

[wangxuan-220]

One more thing to add is that when I removed “CHECK ACCESS USING BACKINT” from the recovery command, after the recovery was initiated, the SAP HANA database no longer queried the past complete data volumes one by one, but directly restored the corresponding correct data.