Question Re: HANA delta restore without recovery catalog in Technology Q&A

HANA delta restore without recovery catalog

wlourens2 — Thu, 25 Apr 2019 11:45:01 GMT

I copied HANA the HANA full and differential backups to another HANA server, and now need to restore it.

Please advise on steps I can use to include the differential backup in the restore, I don't find that option in HANA studio?

From recovery steps:

If I choose "Recover using the backup catalog - the restore can't complete and ends in issue no backup catalog available.
If I choose "Recover without the backup catalog" the restore completes - but the "use Delta backups" option is greyed out.

Please see recovery steps screenshots:

Thanks and Regards,

Re: HANA delta restore without recovery catalog

dennispadia — Thu, 25 Apr 2019 17:12:35 GMT

Hello Willem,

The reason is you have not provided the catalog file of the source system. You can follow steps as described in below link

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.00/en-US/c5043893bb5710148a88fce363a5ad87.html

Below are two important steps:

Move or delete available data backups and log backups from the target database in order to make them inaccessible during the recovery

Make the data backups and the log backup files (including backup catalog files) from the source database available in the appropriate directory in the target database.

Regards,

Dennis Padia.

Re: HANA delta restore without recovery catalog

wlourens2 — Fri, 26 Apr 2019 09:53:56 GMT

Hi Dennis

On our Development system we don't need point-in-time recovery, only recovery until the previous night's backup, thus HANA is in log mode overwrite.

I was hoping to save space by implementing one weekly full HANA backup with daily differential backups, and keeping copies of these backups on another server as a restore strategy in case of Development server loss.

I copied the catalog backup files over to the new server. ** I now tested the restore with the latest Full and Differential HANA backup, and it completed successfully with all three phases. **

Seems like if there are no log files in the catalog, the HANA restore will include the differential database backup in the restore.

Thanks and Regards,