Configuration and perfroming backups using netbackup for SAP HANA
The NetBackup for SAP HANA Agent integrates the backint interface for SAP HANA along with the backup and the recovery management capabilities of NetBackup. The software works in single as well as multi-node environments. Below are the list of activites that you need to perfrom in the HANA Studio for netbackup configuration.
1. Create hdbbackint soft link from /usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint to /usr/openv/NetBackup/bin/hdbbackint_script for every database instance.
2. The parameter file (initSAP.utl) must be specified for data in the SAP HANA database instance configuration. To specify the parameter file, go to
Instance->Configuration-> global.ini > data_backup_parameter_file.
3. The parameter file (initSAP.utl) must be specified for logs in the SAP HANA database instance configuration. To specify backup using the parameter file,
go to Instance->Configuration->global.ini-> log_backup_parameter_file.
4. To specify backup using the backint file, go to Instance->Configuration->global.ini-> log_backup_using_backint->SYSTEM = true.
After setting up the above configuration . The HANA studio -> configuration ->global.ini file should look like the below
Performing backups and restores of SAP HANA using backint:
Use the SAP HANA studio to backup the SAP HANA data. The following steps help you to setup the backup. Setting up the backup using the SAP HANA studio
1 On the SAP HANA studio interface, select the HANA instance that you want to backup.
2 Right-click on the instance and select the Back Up option.
3 The Backup of System screen is displayed. Select the Backint option. Specify the Backup Destination and Backup Prefix as shown and click Next.
4 Confirm the settings under Review Backup Settings and click Finish.
5 Check the Activity Monitor of the NetBackup Administration Console to get the backup information. On a successful backup the results will be displayed
Usefull Notes:
OSS 1986958 – Common issues / Configuration recommendations for Symantec NetBackup for SAP HANA
OSS 1913568 – Support Process for Symantec NetBackup
P.S: Incase of backup failure you need to analyze the backint.log &backup.log files.
Regards,
Pavan Gunda
Nice post
Hi Pravin,
to add a little more useful information for people interested in this subject, there are some complimentary OSS Notes for NetBackup:
OSS 1986958 - Common issues / Configuration recommendations for Symantec NetBackup for SAP HANA
OSS 1913568 - Support Process for Symantec NetBackup
Best regards,
Andy.
Hi,
you have any document for automatic backup schedule?.
can we do it from OS or need Netbackup tool access to do this?.
Thanks
Ravindar
Hi Ranidar,
There are several notes about automatic backup schedule at OS level.
Regards,
Pavan Gunda
Hello Pavan,
I am using HP data protector to backup SAP HANA, but i got error like this
[447] backup could not be completed, [110512] Backint reported 'BACKINT did not return result for [/usr/sap/PHM/SYS/global/hdb/backint/COMPLETE_DATA_BACKUP_databackup_0_1]' in file '/var/tmp/hdbbackint_PHM.Kd3TMR'
How to fixed this?
Best,
what is the backup strategy ?
Si you log and data will use backing ?
if you log backup is not going via backing..then you need to maintain log_backup_using_backing parmater to false .
and paste the log file here hdbbackint_PHM.Kd3TMR .
I belive there are other jobs running at the same time..hence the above error
I have one query?
We have netbackup 7.7.2 and SAP HANA with multitenant database container.
For one instance we have to do following configurations on SAP HANA studio:
Create hdbbackint soft link from /usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint to /usr/openv/NetBackup/bin/hdbbackint_script for every database instance.
The parameter file (initSAP.utl) must be specified for data in the SAP HANA database instance configuration. To specify the parameter file, go to Instance->Configuration-> global.ini > data_backup_parameter_file.
The parameter file (initSAP.utl) must be specified for logs in the SAP HANA database instance configuration. To specify backup using the parameter file, go to Instance->Configuration->global.ini-> log_backup_parameter_file.
To specify backup using the backint file, go to Instance->Configuration->global.ini-> log_backup_using_backint->SYSTEM = true.
My problem is that how to configure backup for multitenant database container (For multiple Instance )
We have 3 instance.
Requesting you to help me in this.
Server Details:
Master Server.
Client/Master = Master
NetBackup Client Platform = PC-x64, WindowsXP
NetBackup Client Protocol Level = 7.7.2
Product = NetBackup
Version Name = 7.7
Version Number = 770000
NetBackup Installation Path = D:\Program Files\Veritas\NetBackup\bin
Client OS/Release = Windows2008 6
SAP HANA Client .
Client/Master = Client of IRBIDCQCSER001.irb.local
NetBackup Client Platform = Linux, SuSE3.0.76
NetBackup Client Protocol Level = 7.7.2
Product = NetBackup
Version Name = 7.7
Version Number = 770000
NetBackup Installation Path = /usr/openv/netbackup/bin
Client OS/Release = Linux 3.0.101-0.47.67-default
Hi
Have you specified all the instances inside the "node_names.txt" file inside the /usr/openv/netbackup/ext/db_ext/sap directory? How is your policy setup on Netbackup for this system?
Hello,
Do we need to schedule backup from Netbackup console or SAP DB13?
Regards
tutku
It can be done in either way. I m using netbackup in my case
We have log backups failing on netbackups after a couple of days of successful backups; due to heavy load on the netbackup server. How do we handle this?
Hi Mrutyumjai,
Yes, we have encountered the similar situation. I have changed the log backups to Disk and scheduled housekeeping activity for the same.
Regards,
Pavan Gunda
Hi Pavan,
Thank you for your reply. Looks like the issue got resolved after the netbackup team increased the number of jobs that the master server can process from a lower number to higher number. Log backups are getting completed without any issues, but are only taking a bit longer.
We really wanted to use netbackup or any other backint solution, so that we dont have to do house keeping on filesystem backups.
Thanks,
Mrutyumjai
Hi,
i'm trying to schedule backup via script netbackup.
backup are running well via backint, but only when i launch them thru Hana interface.
i can't find which command could be in script (is hdbsql or hdbbackint command should be used?)
thanx for help.
Thomas
Hi Thomas,
It would be the hdbsql command to take a backup.
hdbsql -i <instance_number> -n <hostname> -U <userstore_key> "backup data using backint ('$BACKUP_PREFIX')"
Thanks,
Mrutyumjai
Thanks,
i saw that before but didn't work.
it works now. it was a problem of port when i recorded the userstorekey.
thanks a lot!
Thomas
Hi Pavan,
I am facing issue with SAP HANA. which is failing with exit code 13 permission denied. Third party tool is Netbackup. All configuration are in place as per the pre-requisites.
Are we expecting backing API in below location. I am not able to find anything there.
/usr/sap/QA1/SYS/global/hdb/backing
also not found any thing in below location.
usr/sap/QA1/SYS/exe/ ---> found a symbolic link to location /hana/shared/QA1/exe/linuxx86_64/hdb
**********************Error Log****************************
finished with error: [447] backup could not be completed, [110507] Backint exited with exit code 1 instead of 0. console output: exec of /usr/sap/PD1/SYS/global/hdb/opt/hdbbackint failed, Permission denied (13) exec of /usr/sap/PD1/SYS/global/hdb/opt/hdbbackint failed, Permission denied (13)
Additional information about SAP HANA backup via backint:
https://blogs.sap.com/2019/12/20/sap-hana-backup-via-backint-interface.-step-by-step-guide-for-veritas-netbackup./