pre-freeze and post-thaw scripts for Linux

[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]

Hi @mirfan,

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

Thanks!

[mirfan]

Hi Natalia,

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

Thanks

[janschulenburg]

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]

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]

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]

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]

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]

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]

Hi Andreas,

thanks for the answer, I will try it

Regards

[mirfan]

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

Thanks

[Andreas Neufert]

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]

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]

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]

Can someone post and\or "make sticky" a set of example scripts for MYSQL on Linux?

[Egor Yakovlev]

Hi James,

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

/Cheers!