Highlighted

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) ?

2 Solutions

Accepted Solutions
Highlighted
Accepted Solution!

Re: SAP HANA DB Backups

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.

View solution in original post

Highlighted
Accepted Solution!

Re: SAP HANA DB Backups

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

View solution in original post

7 Replies
Highlighted
Accepted Solution!

Re: SAP HANA DB Backups

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.

View solution in original post

Re: SAP HANA DB Backups

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.

Highlighted

Re: SAP HANA DB Backups

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.

 

 

Highlighted

Re: SAP HANA DB Backups

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.

 

 

Highlighted

Re: SAP HANA DB Backups

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.

Highlighted
Accepted Solution!

Re: SAP HANA DB Backups

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

View solution in original post

Highlighted

Re: SAP HANA DB Backups

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