SAP HANA replay online logs on other host

[Former Member]

Dear experts,

Is it possible to replay the online log volumes of one HANA instance on another host. So let's say I dide a complete Data Backup from HANA onst Host1 on monday and did following log backups until wednesday, 12:00 am. Then at Wednesday 3 p. m. the whole host crashes, but I manage to save the content of /hana/log/<DBSID>.

I rebuild a new host, play in the complete database backup from monday + all log backups until wednesday, 12:00 am. How can I roll forward to Wednesday 3 p. m.? Can i just copy the content of /hana/log/<DBSID> in there after applying all backups beforehand and then start HANA database?

Best regards

Andreas Loibl

[Former Member · Accepted solution]

dear experts,

according to my tests, this is not possible. This is in my opinion a serious flaw compared to Oracle, where not archived online logs can be replayed.

Best regards