Comprehensive data protection for all workloads
Post Reply
mirfan
Enthusiast
Posts: 40
Liked: never
Joined: Dec 17, 2020 7:28 am
Contact:

pre-freeze and post-thaw scripts for Linux

Post by mirfan »

Hi,

does anyone can provide me pre-freeze and post-thaw scripts for SAP Hana db and sybase running in Suse linux?
Please share

Regards
Natalia Lupacheva
Veteran
Posts: 1143
Liked: 302 times
Joined: Apr 27, 2020 12:46 pm
Full Name: Natalia Lupacheva
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by Natalia Lupacheva »

Hi @mirfan,

You can find the examples here: https://github.com/VeeamHub/application ... s/sap-hana

Thanks!
mirfan
Enthusiast
Posts: 40
Liked: never
Joined: Dec 17, 2020 7:28 am
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by mirfan »

Hi Natalia,

which server we have to use Pre-freeze and post-thaw script, sap hana db server or application server?

Thanks
janschulenburg
Novice
Posts: 9
Liked: 2 times
Joined: Nov 21, 2019 8:04 am
Full Name: Jan Schulenburg
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by janschulenburg » 1 person likes this post

You should put the pre-freeze and post-thaw scripts on the Veeam B&R server. From within the backup job you can call the scripts. I've put the scripts in c:\Scripts\Hana and call them from the job using Guest Processing, Application-aware processing options, Scripts, Linux scripts.

You can test the scripts by placing them on the SAP Hana server and run them from there (do it on the test environment).
Andreas Neufert
VP, Product Management
Posts: 6707
Liked: 1401 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by Andreas Neufert » 2 people like this post

Important points:

Do not edit the script with a Windows Editor that do not follow UNIX standards (the line end markers are not the same and only the first line in the script would work).
Make sure that the service account our Veeam Backup Service is running on has access to the script folder.
For Veeam VM processing select an ADM user for correct processing.
Veeam Agent for Linux uses root user to execute the script. You need to add a line to the script to "su" to the ADM user frist.
mirfan
Enthusiast
Posts: 40
Liked: never
Joined: Dec 17, 2020 7:28 am
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by mirfan »

janschulenburg wrote: Dec 28, 2020 8:38 am You should put the pre-freeze and post-thaw scripts on the Veeam B&R server. From within the backup job you can call the scripts. I've put the scripts in c:\Scripts\Hana and call them from the job using Guest Processing, Application-aware processing options, Scripts, Linux scripts.

You can test the scripts by placing them on the SAP Hana server and run them from there (do it on the test environment).
I have downloaded from github like info from Natalia.
besides I have to add "su" to root is there anything else I need to change from the script?

for testing do i have to run both script?


Regards
Andreas Neufert
VP, Product Management
Posts: 6707
Liked: 1401 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by Andreas Neufert » 1 person likes this post

Yes, both. It is the same operation as HANA would be set into Snapashot mode and then release it. If you do not release it you would run into some issues over time. (You can use UI or SQL commands as well if the scripts not working).

Follow carefully the script documentation in case of authentication setting.
mirfan
Enthusiast
Posts: 40
Liked: never
Joined: Dec 17, 2020 7:28 am
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by mirfan »

I am confused which part of the script should be changed according to my sap system :)

or I just need to change the hana.conf file?
Andreas Neufert
VP, Product Management
Posts: 6707
Liked: 1401 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by Andreas Neufert » 1 person likes this post

It depends on the situation. The hana.conf file will be only used if you store the script on the HANA server.
If you distribute it directly from B&R only the script itself is copied and you need to make adjustments directly there.

In both ways you need to edit the
keyprefix="HDB"
so that it matches you HANA installation.

Then you need to decide on the authentication.
Usually you use HDBuserstore way to give the user where the script is running access to HANA.
Or you can use the username and password (which means the password is written in plane text in the script).

The hdbuserstore way is documented in the script in detail.
mirfan
Enthusiast
Posts: 40
Liked: never
Joined: Dec 17, 2020 7:28 am
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by mirfan »

Hi Andreas,

thanks for the answer, I will try it

Regards
mirfan
Enthusiast
Posts: 40
Liked: never
Joined: Dec 17, 2020 7:28 am
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by mirfan »

does anyone have pre-freeze and post thaw script for sybase?

Thanks
Andreas Neufert
VP, Product Management
Posts: 6707
Liked: 1401 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by Andreas Neufert » 1 person likes this post

Here you can find a list of examples and limitations.
http://infocenter.sybase.com/help/index ... X16609.htm

When you google you will find additional examples that implemented error handling as well.
mirfan
Enthusiast
Posts: 40
Liked: never
Joined: Dec 17, 2020 7:28 am
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by mirfan »

Hi,

When we try Pre-freeze and post-thaw script for hana database server, Is there any effect to the hana database if the script used has an error?
I want to try the script in hana database server development

Thanks
Andreas Neufert
VP, Product Management
Posts: 6707
Liked: 1401 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by Andreas Neufert »

I am not sure what you ask for. Like nearly any database, HANA can be brought in a consistent state where no new IO is made to the database files so that you can create a snapshot or back them up. Usually you create a snapshot (software/VM/Hardware) to preserve this stage and immediately removing the consistent state. This is not different at HANA. HANA has a "Snapshot" preparation way built into the database. If you start it and the removal fails after it was started, then HANA will continue to not write the changes into the database files (only in the redolog on disk). This mode can lead over time to issues if you bring HANA not out of the snapshot preparation mode.
jtremblay
Novice
Posts: 4
Liked: never
Joined: Sep 01, 2020 7:32 pm
Full Name: James Tremblay
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by jtremblay »

Can someone post and\or "make sticky" a set of example scripts for MYSQL on Linux?
Egor Yakovlev
Veeam Software
Posts: 2536
Liked: 680 times
Joined: Jun 14, 2013 9:30 am
Full Name: Egor Yakovlev
Location: Prague, Czech Republic
Contact:

Re: pre-freeze and post-thaw scripts for Linux

Post by Egor Yakovlev » 1 person likes this post

Hi James,

GitHub page linked above has it all, not just HANA.
https://github.com/VeeamHub/application ... 20Examples

/Cheers!
Post Reply

Who is online

Users browsing this forum: No registered users and 217 guests