Skip to Content

Hi all,

My name is Man-Ted Chan and I’m from the SAP HANA Product Support team. Today I’m just writing up an add-on to a previous blog and video:

Backup and recovery blog
Storage Snapshot video

This blog will be about a new feature in HANA SP10, delta backups.

What is a Delta Backup?

Starting with SPS 10 delta backups were introduced, this feature allows users to perform backup and recoveries quicker. Delta backups only capture the data changed since the last backup or delta backup, meaning less log backups are read for a recovery.

There are two options available when creating a delta backup:

Differential Backup – stores all data changed since the last full backup.

Incremental Backup – Stores the data changed since the last full or last delta backup. These backups are smaller than the differential backups.

How to Create a Delta Backup?

First choose a user that has the BACKUP ADMIN authorization, in this case we will be using the SYSTEM user.

Right click on the system you would like to create a backup for

/wp-content/uploads/2016/02/image1_890914.png

In the ‘Backup Type’ select the delta backup options

/wp-content/uploads/2016/02/image2_890921.png

/wp-content/uploads/2016/02/image3_890922.png

/wp-content/uploads/2016/02/image4_890923.png

/wp-content/uploads/2016/02/image5_890924.png

This error occurred because I did not create full data backup prior to making this delta backup, as mentioned before delta backups are just the difference between the current time to the last full backup. The nameserver trace will show the following:

 

[23117]{300068}[-1/-1] 2016-02-12 20:18:27.643831 i Backup           BackupMgr_DeltaBackupTracker.cpp(00845) :  [DBT] received BackupCatalog_DifferentialBackupStartEntry for 1455308307601

[23117]{300068}[-1/-1] 2016-02-12 20:18:27.644641 i Backup BackupMgr_DeltaBackupTracker.cpp(00113) : No data backups found.

 

After we create a full data backup in the nameserver trace we will see:

 

i Backup BackupMgr_DeltaBackupTracker.cpp(00845) :  [DBT] received BackupCatalog_DifferentialBackupStartEntry for 1455309927467

e Backup BackupMgr_DeltaBackupTracker.cpp(00957) : Requested volume 0 not found in backup tracker.

i Backup BackupMgr_DeltaBackupTracker.cpp(00685) :  [DBT] received BackupCatalog_DataDestinationStartEntry for 1455309927467

  1. backup.log will show:

BACKUP   SAVE DATA will write to the following files:

INFO    BACKUP   to file: /usr/sap/xx/HDB00/backup/data/DIFF_DATA_BACKUP_databackup_differential_0_1455309927467_0_1

INFO    BACKUP   to file: /usr/sap/xx/HDB00/backup/data/DIFF_DATA_BACKUP_databackup_differential_1455309613593_1455309927467_1_1
….
INFO    BACKUP   SAVE DATA finished successfully

As we can see the only way to tell it is a differential backup is by the filename

*PREFIX*_databackup_differential

Incremental backups are done the same

/wp-content/uploads/2016/02/image6_890925.png

And the logs are not much different as it just shows the file name is *PREFIX*_databackup_incremental (IE. INC_DATA_BACKUP_databackup_incremental_0_1455310512146_0_1)

Please note that in SPS 10 you cannot create a delta backup in the HANA Cockpit, but this feature is available in HANA SPS 11

HANA SPS 10 will show the delta backup options as disabled

/wp-content/uploads/2016/02/image7_890926.png

Viewing Backups

You can view the backups in the HANA Studio by opening the backup wizard

/wp-content/uploads/2016/02/image8_890930.png

To see our delta backups are not there, to see them we will need to check ‘Show Delta Backups’

/wp-content/uploads/2016/02/image9_890931.png

Please note in the HANA cockpit the delta backups are not visible and not option to view them (SPS 10>

/wp-content/uploads/2016/02/image10_890932.png

What About Recoveries?

Recoveries are performed the same as before

/wp-content/uploads/2016/02/image11_890933.png

/wp-content/uploads/2016/02/image12_890934.png

Please note that if you choose ‘Recover the database to a specific data backup or storage snapshot’ you won’t have the option to select a delta

Select the log area

/wp-content/uploads/2016/02/image13_890935.png

Select the data backup

/wp-content/uploads/2016/02/image14_890936.png

After this we can select the delta backup option

/wp-content/uploads/2016/02/image15_890937.png

Please note that if you selected ‘Recover the database to a specific data backup or storage snapshot’ this option will be grayed out.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Robert Weber

    Hi Man-Ted,

    Thanks a lot for sharing this concept.

    What about snapshot backups? Is SAP HANA backup somehow integrated into a snapshot technology, e.g. NetApp?

    Best regards,

    Robert

    (0) 
    1. Jens Gleichmann

      Hi Robert,

      of course! There is a tool called Snap Creator from Netapp which manages exactly this + the backup catalog (which most of the other tools don’t care about). There are also some other tools e.g. from EMC. NetApp was the first vendor who introduced and certified this.

      If you are interested in this topic I can send you some details.

      Regards,

      Jens

      (0) 

Leave a Reply