Forum Discussion

NBU35's avatar
NBU35
Level 6
9 years ago

SAP HANA DB Backups

Hi 

We are in phase of setting up SAP Hana SPS10 backups from Netbackup.
Clients are on RHEL 6.5, NBU 7.6.0.3

I have read somewhere only NBU versions >= 7.6.1.2 SUpports FUll, INcr, Differential Incr backups of Hana DB.

Does any NBU version prior to 7.6.0.3 has this capability?

As per NBU SAP guide for version 7.6 "For this release, data backup and restore are initiated from the SAP HANA studio and not from NetBackup Administration Console. You can run backups using the SQL commands. You can also use Cron to schedule the backups."

DOes it Mean no SAP HANA backup can be schduled from NetBackup Admin console ? 

How can we define no. Of streams of backup (just like channels in Oracle) ?

7.6
Backing Up
Backup and Recovery
Configuring
Installing
Integration
NetBackup
Not Applicable
Tip-How to
Troubleshooting
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    9 years ago

    There is a script you can download that will allow you to initiate the backups from NetBackup. You can get it here https://www.veritas.com/support/en_US/article.TECH209343

    Streams are defined in the UTL file DRIVES parameters.

    I'm not sure about previous support for INCR.

  • Systems_Team's avatar
    Systems_Team
    9 years ago

    Hi NBU35,

    I would be wondering if you are running in an unsupported configuration, as the Database SCL says support for SAP HANA SPS 10 on Red Hat Enterprise Linux 6 Update 5 (x86-64) only started at NetBackup version 7.6.1.2, and you are on 7.6.0.3.

    In the NetBackup for SAP Administrator's Guide for 7.6 it has the following on page 35 (Installing NetBackup for SAP HANA -> Planning the installation) regarding linking:

    Check that libelf.so.0 is symbolically linked to the libelf.so.0.8.12 file.
    These files are located in /usr/lib64/.

    That is different to the linking information you provided above, so not sure what guide that was from.

    Regards,

    Steve

7 Replies

Sort By
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    9 years ago

    There is a script you can download that will allow you to initiate the backups from NetBackup. You can get it here https://www.veritas.com/support/en_US/article.TECH209343

    Streams are defined in the UTL file DRIVES parameters.

    I'm not sure about previous support for INCR.

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    9 years ago

    You can specify the UTL file in the log sections of the global.ini. Sorry I can't recall the exact terms but its all in the guide. I followed it and its suprisingly easy to get the basics going. It includes creating the link.

     

    Do that first an initiate the backups from HANA studio, once that works, move on to the script. Just do what is says in the note, we had to play around with the ports as we had two instances of HANA running on one server.

     

    I think the script can cater for Incrementals if that's what you mean with DELTA.

     

     

  • Systems_Team's avatar
    Systems_Team
    Level 6
    9 years ago

    Hi NBU35,

    I would be wondering if you are running in an unsupported configuration, as the Database SCL says support for SAP HANA SPS 10 on Red Hat Enterprise Linux 6 Update 5 (x86-64) only started at NetBackup version 7.6.1.2, and you are on 7.6.0.3.

    In the NetBackup for SAP Administrator's Guide for 7.6 it has the following on page 35 (Installing NetBackup for SAP HANA -> Planning the installation) regarding linking:

    Check that libelf.so.0 is symbolically linked to the libelf.so.0.8.12 file.
    These files are located in /usr/lib64/.

    That is different to the linking information you provided above, so not sure what guide that was from.

    Regards,

    Steve

  • EnriquePereira's avatar
    EnriquePereira
    Level 5
    9 years ago

    Hi,

     

    I need to help a customer with SAP HANA backups. At this moment I am helping with the design and I am wondering about the deduplication rates as I have seen that SAP compress the stream before sending to NBU. Do anyone have real deduplication rates on SAP HANA backup implementations? 

     

    Thanks in advance,

     

    Enrique

  • NBU35's avatar
    NBU35
    Level 6
    9 years ago

    Thanks Riaan.

    If I am right then as per TN support for delta Backups started from 7.6.1.2.

    As per script in  https://www.veritas.co.m/support/en_US/article.TECH209343 we can schedule backups from Netbackup by creating link between hdbbackint and hdbbackint_cript of netbackup and modifiying initsap.utl file.

    This script is only clearfying full and delta backups, how to configure log backup using backint, which are by default /usr/sap/../backup/logs/ directory.

    To perform backps using this script, do we need a separate user like backup admin user?

    Thanks for informing about DRIVES parameter in .utl file, I believe it works in co-ordination with parameter "paralell_Data_backup_streams" in global.ini file.

     

    Please suggest.

  • NBU35's avatar
    NBU35
    Level 6
    9 years ago

    As per Guide:

    Create a link from SAP HANA’s hdbbackint to hdbbackint_script script instead of NetBackup’s hdbbackint binary, as follows:


    ln -s /usr/openv/netbackup/bin/hdbbackint_script /usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint

    we have NBU 7.6.0.3 on our SAP client, I checked we don't have any binary there with name "hdbbackint" or "hdbbackint_script".

    How shall I proceed.

     

     

  • NBU35's avatar
    NBU35
    Level 6
    9 years ago

    Yes, There is an option to set up another policy for log backups.

    can u please help me out with sample script for logs backups.