Recover Again to A Previous Time

[former_member182967]

Hello experts,

I have a question about the following situation regarding to HANA restore and recover:

Assume that we do backup at 10:00pm every day, we restore(recover) the HANA DB to 2014-10-30 09:00am and finish successfully. However, we see that the time is later that what we want (that is to say, the best restore time is 2014-10-30 08:00).

Can we still restore (recover) again to 2014-10-30 08:00?

Thanks & Best Regards,

Tong Ning

[lbreddemann · Accepted solution]

OK, so you take a data backup at 9 o'clock but you want to recover a state that was present at 8 o'clock?

Not sure what DBMS on this planet would support this, but for SAP HANA you've to take a backup that was created *before* the point in time that you want to restore (database wise).

So, in order to recover to the state of the DB from 8 o'clock, you need a backup that was taken before 8 o'clock, let's say at 7 o'clock.

You restore this backup and then apply the log backups that had been created between 7 and 8 o'clock.

As this is all well documented, I highly suggest to give that stuff another read.

[former_member182967 · Accepted solution]

Hello Lars,

Yeah, I think I asked a stupid question...

Thanks & Best Regards,

Tong Ning