log backup for sap hana
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?
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.utlAlso 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.