log backup for sap hana
- 8 years ago
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.