HANA Data backup

[former_member646800]

Hi All,

I have some questions regarding Data backup,

• If we trigger the data backup, will it take backup from Persistence level or memory level or both ?

• If from memory or both, then how it works ?

Please clarify about this concept experts.

Kind Regards,

Puneeth H A

[deepak-kalra]

Hi Puneeth H A,

I will be explaining couple of terms to answer your question

Savepoint: At savepoint SAP Hana database moves all data changes from memory to the data volumes and redo log entries are also written to the log volumes for all changes to hana persistent data. By default, savepoints are created every five minutes, including during a backup.

Data Volume: It contains the data from the last completed savepoint.
i.e. /usr/sap/<SID>/SYS/global/hdb/data

Log Volume: It contains all changes on the data volume since the last completed savepoint.
i.e. usr/sap/<SID>/SYS/global/hdb/log

When Hana backup is triggered it back's up data area or log area according to type of backup selected.
Types of Hana Backup:
1) Full Backup - A data backup includes all the data that is required to recover the database to a consistent state.

2) Delta backups -
incremental backups - The data only changed since the last full data backup or the last delta backup.
differential backups - The data changed since the last full data backup.

3) Redo log backups - SAP HANA log segments in the log area are backed up automatically.

Please also look at SAP note 1642148 - FAQ: SAP HANA Database Backup & Recovery

Note: https://launchpad.support.sap.com/#/notes/1642148

I hope it helps

Regards
Deepak

[former_member646800]

Thanks for the reply Deepak.

Could you please elaborate, once we triggered the backup,in back-end how backup operations works.

Puneeth H A

[deepak-kalra]

Hi puni_12
Please go through SAP HANA Administration Guide and I am sure it will help you.
You can also follow SAP HANA Academy & follow denys.kempen

SAP HANA Service (CF): Administration, Backup and Recovery
Link: https://www.youtube.com/watch?v=Mieej8AqFkw&list=PLkzo92owKnVyhAGmDP4OsoPIj15-FEHtH

SAP HANA Administration Guide
Link: https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.03/en-US/c4663eabbb571014923a90c70c...

Regards
Deepak