To which time would it be recovered when HANA is recovered without point-in-time recovery?

[Former Member]

I'm running my HANA db with this configurations.

LOG_MODE = OVERWRITE

(daily backup command:) BACKUP DATA FOR MYH USING FILE ('dailybu')

Currently I am thinking to restore one of my backups with this command.

RECOVER DATA USING FILE ('dailybu') CLEAR LOG

But I'm not sure the time to which my HANA db would be

recovered.

Would it be start time of the backup?Or end time?

Or could be somewhere in the middle?

Kindly clarify my question.

I have already searched many documentations but couldn't find a clear

explanation.

Thanks,

N.Mochizuki

[davidebruno · Accepted solution]

The database will be recovered to the time of the start of the backup (when Hana start the savepoint)

If your system have the log_mode = overwrite you can't recover the system with point-in-time option

[Former Member · Accepted solution]

Thank you Davide.

I have checked backup.log and verified that there are  SAVE DATA entries right before backup start and after backup end.

But a simple question came up.

How would it affect to the backups if savepoints occur during a backup run?

Would the status of the backup start time be kept ?

According to HANA Administration Guide, regular savepoints ( every 5 minutes by default) occur during backups.

Regards,

N. Mochizuki

[davidebruno · Accepted solution]

If I remember well, the recovery returns the system to the savepoint started at the begin of the data dabackup

[Former Member · Accepted solution]

Davide,

Thank you for the info.

Based on your 'memory', I searched again Administration Guide and SQL and System View reference.

I run this command during an active backup run

SELECT TIMESTAMP,FOR_BACKUP FROM M_SNAPSHOTS

(result)

"2015-12-01 20:17:15.087982000","TRUE"

1 row selected (overall time 1470 usec; server time 902 usec)

This record was existing until backup end.

Probably it indicates internal snapshot at the start of backup is kept to keep consistency of data backup.

My question is completely cleared.

Thank you once agian!

N. Mochizuki