SAP B1 HANA Support?

Availability for the Always-On Enterprise

SAP B1 HANA Support?

Veeam Logoby evander » Mon Jan 25, 2016 8:48 am

Hi - Does Veeam support SAP Business One HANA?

Busy rolling out new install on a SLES virtual machine in Vsphere environment as per SAP's guidelines, problem though is how to back up the box?

Thanks
evander
Enthusiast
 
Posts: 62
Liked: 4 times
Joined: Thu Nov 17, 2011 7:55 am

Re: SAP B1 HANA Support?

Veeam Logoby PTide » Mon Jan 25, 2016 9:28 am

Hi,

Have you seen this document already? Also there is an option to run some pre-freeze/post-thaw scripts. Here is the copy of message that has been posted by our colleague Tom Sightler:

tsightler wrote:Here are some VERY crude scripts that create HANA snapshots via pre-freeze/post-thaw. I'm going to work on cleaning these up to automatically detect installed HANA instances and to use the HANA credential store instead of hard coded username/password. The snapshot process works quite well as it's fully possible to restore the data directory, either via FLR or, if data/logs are on separate volumes, with virtual disk restore (and of course full VM restore), and then use HANA Studio (or command line if you can figure it out) to perform point-in-time restores by applying the HANA automatic log backups. I probably need to document up the whole process. Perhaps I can work on that next week.

The testing was done with SuSE Enterprise for SAP Applicaitons 11 SP4, with SAP HANA SPS09 and a very basic install.

Pre-Freeze:
Code: Select all
#!/bin/bash
DATE=`date`
SQL="BACKUP DATA CREATE SNAPSHOT COMMENT '$DATE'"
/usr/sap/HDB/HDB00/exe/hdbsql -i 00 -u SYSTEM -p YourPassword -j $SQL
echo $DATE > /usr/sap/HDB00_snapshot.date

Post-Thaw:
Code: Select all
#!/bin/bash
DATE=`cat /usr/sap/HDB00_snapshot.date`
SQL="SELECT BACKUP_ID from M_BACKUP_CATALOG WHERE COMMENT = '$DATE'"
ID=`/usr/sap/HAN/HDB00/exe/hdbsql -i 00 -u SYSTEM -p YourPassword -a -j $SQL | head -n1`
SQL="BACKUP DATA CLOSE SNAPSHOT BACKUP_ID $ID SUCCESSFUL 'VeeamBackup'"
/usr/sap/HAN/HDB00/exe/hdbsql -i 00 -u SYSTEM -p YourPassword -a -j $SQL
rm /usr/sap/HDB00_snapshot.date


Thank you.
PTide
Veeam Software
 
Posts: 3077
Liked: 250 times
Joined: Tue May 19, 2015 1:46 pm

Re: SAP B1 HANA Support?

Veeam Logoby evander » Mon Jan 25, 2016 2:51 pm

Hi Ptide - thanks for the response. Can you link me to the thread where Tom speaks about those scripts, I cant find it.

Am I correct in saying:
If I don't use any scripts but let Veeam backup the server I will still have crash consistent backups? I know this is not ideal but just trying to get to worse case scenarios here. The backups run after hours and there is nobody accessing the SAP server during this period so activity on the database should be little to none ( I think). If backups run at this time is it fairly safe to assume if the server needs to be restored I would be able to get to a point in time where the database was last backed up by Veeam with no corruption?

I don't know SAP at all at this stage, still learning, but I assume their management tool will have some form of backup utility that can backup the database to the local drive, at a minimum. If I can run that daily before the Veeam backup runs would it be safe to say I would have a solid option to recover from that last SAP/Veeam instance?

And lastly, is there any plans to include fully supported SAP HANA backup functionality within Veeam and even maybe Veeam Explorer for SAP in the Veeam roadmap? I suspect there may well be a good market for it out there with SAP being as popular around the world as it is.

thanks
evander
Enthusiast
 
Posts: 62
Liked: 4 times
Joined: Thu Nov 17, 2011 7:55 am

Re: SAP B1 HANA Support?

Veeam Logoby PTide » Mon Jan 25, 2016 3:11 pm 1 person likes this post

Can you link me to the thread where Tom speaks about those scripts, I cant find it.
Sorry, it's on an internal forum. I've already copied all script-related info from that thread here, there is nothing more to add. If you want you can write a private message to Tom, maybe he will tell you more.

If I don't use any scripts but let Veeam backup the server I will still have crash consistent backups?
Correct.

The backups run after hours and there is nobody accessing the SAP server during this period so activity on the database should be little to none ( I think).
Then I suggest to to schedule an automated database service shutdown prior to doing a backup and automatic startup when the backup is done. On the other hand it also requires some scripts to be executed so it'd be better to use Tom's scripts.

If I can run that daily before the Veeam backup runs would it be safe to say I would have a solid option to recover from that last SAP/Veeam instance?
Yes. I'd also recommend you to keep your db backup copy somewhere away from your production server.

And lastly, is there any plans to include fully supported SAP HANA backup functionality within Veeam and even maybe Veeam Explorer for SAP in the Veeam roadmap? I suspect there may well be a good market for it out there with SAP being as popular around the world as it is.
Not yet. You can create a separate feature request thread for that so other users can vote for that feature.

Thank you.
PTide
Veeam Software
 
Posts: 3077
Liked: 250 times
Joined: Tue May 19, 2015 1:46 pm

Re: SAP B1 HANA Support?

Veeam Logoby tsightler » Mon Jan 25, 2016 3:23 pm 4 people like this post

I'm continuing to work on those scripts to improve them as those original examples were just the first attempt and they have no error checking, are obviously hard coded with path names, and have a few minor issues such as not waiting for he snapshot to complete prior to returning, which can be crudely worked around with a sleep command. They were mainly intended for a POC to prove that it could be done and that the backups would be fully restorable using standard SAP process.

Using the scripts means that HANA is aware of the backups and they are properly recorded in the backup history table and you can see them in HANA Studio. Of course you may also need to handle log purge and other things as well. You can also leverage online logs to play the database forward from the time of the snapshot backup to a specific point-in-time.

Without the scripts HANA is unaware of the backups but indeed they are crash consistent and you should be able to restore the VM and/or database without serious issues, but there will be an extended recovery step during startup and, if you decide to go this route, I'd strongly suggest testing it well in you environment. I'm not sure of SAPs supports for "crash consistent" backups from a recovery perspective which is why I think the scripts are a better approach. They use HANAs documented "snapshot" method for backup, which was primarily designed for storage snapshots but works just as well for VM snapshots.

The more advanced scripts I'm working on parse the sapservices file to automatically discover installed instances and run the snapshot commands, waiting for them to complete prior to returning. I may also add some additional logic for handling logs although this could also be easily handled outside of the pre-freeze/post-thaw as well. I'm hoping to have these new scripts in a testable state by the end of this week. I'm currently doing basic testing in my lab today and tomorrow, but I have a lot of other things on the calendar this week so who knows how that might go. :) I'll post them here when I get them in a state worth sharing.
tsightler
Veeam Software
 
Posts: 4801
Liked: 1758 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SAP B1 HANA Support?

Veeam Logoby evander » Tue Jan 26, 2016 11:31 am

Thanks to both of you, very helpful and I am definitely looking forward to the updated scripts you are working on Tom.
This is much appreciated.
evander
Enthusiast
 
Posts: 62
Liked: 4 times
Joined: Thu Nov 17, 2011 7:55 am

Re: SAP B1 HANA Support?

Veeam Logoby FabioM » Mon Feb 08, 2016 5:49 pm

Hi,
Is this valid for the Replication also?
Thanks
FabioM
Veeam ProPartner
 
Posts: 35
Liked: 4 times
Joined: Mon Sep 23, 2013 10:27 am
Full Name: Fábio Mendonça

Re: SAP B1 HANA Support?

Veeam Logoby PTide » Mon Feb 08, 2016 6:45 pm

Hi,

Yes, scripts should work for a replication job as well. In case you have a long replica sync interval then I suggest you to take a look at replica from backup feature.

Thank you.
PTide
Veeam Software
 
Posts: 3077
Liked: 250 times
Joined: Tue May 19, 2015 1:46 pm

Re: SAP B1 HANA Support?

Veeam Logoby tsightler » Mon Feb 08, 2016 6:51 pm 4 people like this post

Yes, it is valid for replication as well. Note that when you fail over the replica VM and the HANA services start they will automatically see the snapshot, perform a recovery and the snapshot will be tagged as "abandoned due to service restart". This is expected behavior and is the same behavior seen during full VM restores as well. No user interaction is required.

I've continued work on these scripts and they've grown significantly more sophisticated. Below I will post the URL to the current versions. This version has a few variables for username, password, SAP path (path to sapservices file) and timeout (default 5 minutes). The scripts now automatically parse the sapservices file to find installed instances, place each in snapshot mode, wait and check the status of the snapshot prior to exiting the pre-freeze script. They also no longer require storing a temporary file on the filesystem. I still plan to add a few more enhancements, such as the ability to use the user secure store instead of a password, and possibly some log file management, although the later can also easily be handled with a simple cron job so that might be overkill.

Please test and let me know how they work. Feedback and bug reports are welcome.

The current version of the scripts can be downloaded here.
tsightler
Veeam Software
 
Posts: 4801
Liked: 1758 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SAP B1 HANA Support?

Veeam Logoby tsightler » Mon Feb 08, 2016 10:53 pm 3 people like this post

One final update for today, I have just uploaded version 0.6 of these scripts which includes support for Secure User Store in addition to simple username/password auth. This is now the default behavior but does require some extra setup on the host. For regular username/password authentication you can just set the variables at the top of each script, the account needs only BACKUP ADMIN and CATALOG READ system privileges. However, for even more security, the script defaults to using the Secure User Store. You'll still need an account on each HANA instance with the same privileges as above, but you can then create a secure store for the OS user running the script (typically root, but can be a regular account), with encrypted credentials and you can even have separate HANA credentials for each instance. Instructions for setting this up are included in the scripts but I've also included that section below for reference. Once configured on the HANA host, the scripts themselves should need no modification at all, unless you want to use a different key prefix.

Code: Select all
# To use Secure User Store for SAP HANA authentication select a key prefix.
# This prefix will be combined with the instance number to reference a specific
# key for authentication.  For example, the default prefix is HDB, so for
# instance 00 the script will attempt to use key HDB00 to authenticate.
#
# To create Secure User Store use the following command syntax:
#
# ./hdbuserstore set <key> <host>:3<instance#>15 <user> <password>
#
# For example, to create keys for instance 00 and 01 on host "hana01"
# using a username "VEEAM" and password "Backup123" run the following commands
# as the OS user that will be running the script to create their secure store:
#
# ./hdbuserstore set HDB00 hana01:30015 VEEAM Backup123
# ./hdbuserstore set HDB01 hana01:30115 VEEAM Backup123
#
# Note that it is completely possible for the accounts to be difference for each
# instance.  The HANA account requires BACKUP ADMIN and CATALOG READ system privledges.
#
KEYPREFIX="HDB"


Scripts can be downloaded here.

I consider these being close to "production ready" but I'm definitely interested in feedback and bug reports. Also, I'm still considering adding log management and backup catalog purging into the scripts. It would add a significant additional complexity though, so feedback on the need for that is especially appreciated.
tsightler
Veeam Software
 
Posts: 4801
Liked: 1758 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SAP B1 HANA Support?

Veeam Logoby tsightler » Tue Feb 09, 2016 4:11 am 5 people like this post

I guess I was feeling extra motivated tonight so version 0.7 has been uploaded and includes basic catalog/log backup management. Default is to look for the first snapshot older than 3 days and purge any catalog and file log backups older than this. That gives three days with which you can easily restore from your Veeam restore points and still perform point-in-time restores. Of course you can also restore from older restore points as well, to the point of the backup image but recovering to a point-in-time for older backups would require manually restoring the correct log backups. It's certainly possible that 3 days may be too much for busy environments so there are two variables in the post-thaw script where you can tune the number of days, or disable this functionality completely.

In the next day or so I'll try to add some more logging and trap some additional error conditions and I'll publish a 1.0 version if I don't get any bug reports from the beta testers. I'm also working on a short guide to describe the setup of the scripts as well as the various restore processes, but that may take until next week.

Download here
tsightler
Veeam Software
 
Posts: 4801
Liked: 1758 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SAP B1 HANA Support?

Veeam Logoby PKaufmann » Fri Oct 07, 2016 7:27 am

Hi,

is there already a version 1.0 ?
Got some trouble to get version 0.6 running (pre-freeze script - unexpected error code 1) :(
PKaufmann
Novice
 
Posts: 3
Liked: never
Joined: Wed Oct 05, 2016 8:00 am

Re: SAP B1 HANA Support?

Veeam Logoby tsightler » Fri Oct 07, 2016 4:39 pm

Like so many things, I got distracted with other issues and the clients I were working with at the time reported success with version 0.7 that I posted above, so I ended up moving on to other things. I only had evaluation installs of SAP HANA and now they are expired so I don't have access to an instance to continue any work, however, the scripts can easily be run from the command line to see if they function and you may get better errors there.
tsightler
Veeam Software
 
Posts: 4801
Liked: 1758 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SAP B1 HANA Support?

Veeam Logoby dellock6 » Sat Oct 08, 2016 10:49 am

You can also check this paper we published lately:
https://www.veeam.com/wp-sap-oracle-dep ... guide.html
It has been written, from the technical point of view, by one of our solution architect Andreas Neufert, and we uses special consultancy from a large SAP integrator.

Luca
Luca Dell'Oca
EMEA Cloud Architect @ Veeam Software

@dellock6
http://www.virtualtothecore.com
vExpert 2011-2012-2013-2014-2015-2016
Veeam VMCE #1
dellock6
Veeam Software
 
Posts: 5061
Liked: 1342 times
Joined: Sun Jul 26, 2009 3:39 pm
Location: Varese, Italy
Full Name: Luca Dell'Oca

Re: SAP B1 HANA Support?

Veeam Logoby crackocain » Sat Oct 08, 2016 11:52 am

Feature Request - HANA Certified

http://scn.sap.com/docs/DOC-62799

Too many customer want to protect HANA servers are HANA certified backup software. Because of that Veeam eliminate at the start.

If Veeam in leaders at Gartner reports this feature must be in roadmap. Very important enterprise customers.
EMC, IBM Storage Specialist - VMCEv9 - Dosbil - Turkey
crackocain
Veeam ProPartner
 
Posts: 63
Liked: 7 times
Joined: Mon Dec 14, 2015 8:20 pm
Location: Turkey
Full Name: Mehmet Istanbullu

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: ferrus, mcz and 57 guests