Skip to Content

Recover HANA DB with no backup and lost log area

Oct 18, 2016 at 10:48 AM


avatar image
Former Member

It is posible to recover a HANA Db only from data files. The Log Area was lost and they have no recent backup.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Oct 18, 2016 at 11:29 AM

What does the documentation research that you undoubtedly have done before posting tell you?

NO! It's not possible.

The database cannot be recovered.

You might get lucky though, by being able to restart the database to the last successfully written savepoint. If this is a production system and the data cannot be recovered in any other way, the development support might be able to get the database open again.
Please understand that I wrote "might" not "will". There's no good backup to use, which means the single most important bit of DB administration has been neglected. That indeed is the problem to tackle, once you got the data back.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you for your answare. This was also my ideea, how can I start the datatabase to the last successfull savepoint. The long story short - the server was bring from abroad , one of the disks from the log area was lost and the backup was made on a network share and can not be accessed anymore