log backup for sap hana

[gkman]

Hi everyone,

I have managed to configure full backups for sap hana, using the admin guide and these two guides:
https://www.veritas.com/support/en_US/article.TECH209343
https://www.veritas.com/support/en_US/article.000021640

now I am trying to configure log backups and can't find how to do this.
thanks in advanced for the help

edit:
also, restores are only possible via sap hana studio?

[Marianne]

Disclaimer:
I know nothing about SAP HANA - only what has been shared in this forum.

According to this discussion, log backups can only be configured from SAP HANA:
https://vox.veritas.com/t5/NetBackup/backint-processes-are-stacking-on-client-in-SAP-HANA-D/m-p/8150...

Best to work with your dba... 

[NBU35 · Accepted solution]

Hi gkman

I hope your netbackup version is above 7.6.1. 

in your SAP backup policy create following type of schedules.

1) Automatic Full Backup

2) Automatic incr/**bleep** incr backup (as per your choice)

3) default application backup (created automatically with any automatic schedule, will be used by incr/cim incr/full backups).

4) one more default application backup schedule and rename it to anything like "log_backup"

set retentions of both application backups schedules as per your requirements.

Now go to /usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle and uncomment parameter "policy" and  infront of tyep name of your SAP backup policy name in file initSAP.utl

now copy file /usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/initSAP.utl to/usr/openv/netbackup/ext/db_ext/sap/scripts and rename it to initLOG.utl and in this file uncomment parameter "schedule" and type its value to "log_backup" such as follows:

schedule log_backup

and save this file.

now go to SAP HANA console, and update global.ini as follows:

log_backup_parameter_file = /usr/openv/netbackup/ext/db_ext/sap/scripts/initLOG.utl
data_backup_parameter_file = /usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/initSAP.utl

Also from HANA console setup frequency of log backups.

As per my knowledge Restore are only possible from HANA ADMIN CONSOLE.

Please let me know in case of any concern.