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

Capture.PNG

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.

backint.PNG

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

To report this post you need to login first.

17 Comments

You must be Logged on to comment or reply to a post.

  1. Andy Silvey

    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.

    (1) 
  2. masto sitorus

    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,

    (0) 
    1. Pavan Gunda Post author

      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

      (0) 
  3. Zakir Khan

    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

    (0) 
    1. Polokego Mampane

      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?

      (0) 
    1. Pavan Gunda Post author

      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

      (0) 
      1. Mrutyumjai Kamana

        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

        (0) 
  4. thomas lallemand

    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

    (0) 
    1. Mrutyumjai Kamana

      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

      (0) 
  5. Manu MS

    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) 

    (0) 

Leave a Reply