Sunday, February 26, 2012

BackUp Procedure HANA SPS3

In HANA SPS3, only online backup is supported. Also it supports only files as backup media, backup to pipes/tapes is not supported. Another important thing is that the backup and recovery process cannot be used for system copies.

So In short we can say that HANA SPS3 supports the following
-> The log backup, and
-> The point-in-time recovery
 To use the point in time recovery, we have to set the HANA database to the "normal" log mode. This results in an ever-increasing requirement for disk space, the SAP HANA database administrator must monitor and administer these. Therefore, this function is not automatically activated when you perform the upgrade.

Backups and recoveries can only be executed by users who have the system privileges
BACKUP_ADMIN and
CATALOG_READ

 By Default the location of the backup files is as same as the value of the parameters "basepath_logbackup" and basepath_databackup

Goto Administrator



Click the configuration tab








global.ini -> persistence 



We have to set the path of the backup in the above parameters. As per SAP recommends path for data and log backups on an external storage medium which have enough free storage space.

 

 We can check the size of the backup from the table "M_DATA_VOLUME_PAGE_STATISTICS"





 We can check the size of the data files with the below mentioned SQL query.



Once all set in the .ini file we can take the backup of the required system.



Note that we have to take the .ini files backup manually.