Create a MAXDB (SAP) backup

Availability for the Always-On Enterprise

Create a MAXDB (SAP) backup

Veeam Logoby alex2801 » Tue Oct 19, 2010 8:27 am

Hi all,

I'm Looking for a way to backup some SAP server VM's with Veeam. The normal Veeam backup goes very well now and the last result is always "success". But since MaxDB is not VSS compliant ,the databases are in an inconsistent state. There must be more people in this situation ,but i can't find them with google .

Any help is appreciated.
alex2801
Lurker
 
Posts: 2
Liked: never
Joined: Fri Nov 06, 2009 9:49 am
Full Name: Alex Henstra

Re: Create a MAXDB (SAP) backup

Veeam Logoby Gostev » Tue Oct 19, 2010 9:57 am

Hi, you can use VMware prefreeze/postthaw scripts to suspend/resume database for snapshot operation. You may need to contact MaxDB vendor to find out what commands need to be used to suspend and resume database for hot backup.
Gostev
Veeam Software
 
Posts: 21386
Liked: 2348 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Create a MAXDB (SAP) backup

Veeam Logoby alex2801 » Wed Oct 20, 2010 11:39 am

Thanks for your reply Gostev,

I wil look for the freeze and thaw scripts. If anyone has succeeded in making such scripts, please let me now.
alex2801
Lurker
 
Posts: 2
Liked: never
Joined: Fri Nov 06, 2009 9:49 am
Full Name: Alex Henstra

Re: Create a MAXDB (SAP) backup

Veeam Logoby tsightler » Wed Oct 20, 2010 1:09 pm

SAP has some techniques for performing backups using "split mirror" techniques, which is basically the same thing. A split mirror is typically how Netapp or EMC describe using their snapshot technology to create backup snapshots presented to secondary host, but conceptually it's the same.

Unfortunately I don't have access to the SAP technotes, but SAP notes 371247 and 616814 seem to be the definitive reference for SAN based snapshots (VMware snapshots are not really different). Note 616814 has the following script:
Code: Select all
To create the split mirror or snapshot, proceed as follows:
dbmcli -d <database_name> -u < dbm_user>,<password>
util_connect < dbm_user>,<password>
util_execute suspend logwriter
==> Create the snapshot on the EVA
util_execute resume logwriter
util_release
exit


So effectively you should be able to use the concept to create a pre-freeze script to freeze the IO, and a post-thaw script to resume the logging but I must admit my experience here is minimal.
tsightler
Veeam Software
 
Posts: 4768
Liked: 1737 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: Create a MAXDB (SAP) backup

Veeam Logoby ehill@gtweed.com » Mon Jan 10, 2011 8:29 pm

Has anyone had any success with the thaw portion of this. I get a vmware snapshot error to do with non 0 return code by the custom portion of the quiesce script.
ehill@gtweed.com
Lurker
 
Posts: 1
Liked: never
Joined: Mon Jan 10, 2011 8:24 pm
Full Name: Ethan Hill

Re: Create a MAXDB (SAP) backup

Veeam Logoby Gostev » Mon Jan 10, 2011 8:50 pm

Did you verify that thaw script returns zero when both pre and then post scripts are executed manually?
Gostev
Veeam Software
 
Posts: 21386
Liked: 2348 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Create a MAXDB (SAP) backup

Veeam Logoby Felix » Mon Mar 21, 2011 5:01 am 1 person likes this post

Based on the info provided here and some googling, I'm now using the following freeze/saw script to backup our SAP MaxDB Windows machines:
Code: Select all
@echo off
REM %1 == freeze/thaw/freezeFail
if "%1" == "freeze" goto doFreeze
goto doThaw
:doFreeze
echo %1 >c:\freeze.log
dbmcli -d <dbname> -u <dbuser>,<dbpass> -uUTL -c "util_execute suspend logwriter" >>c:\freeze.log
goto EOF
:doThaw
echo %1 >>c:\freeze.log
dbmcli -d <dbname> -u <dbuser>,<dbpass> -uUTL -c "util_execute resume logwriter" >>c:\freeze.log
:EOF


Put the file as eg. 00_maxdb_logwriter.bat into %ProgramFiles%\VMware\VMware Tools\backupScripts.d\.
To test if it works, create a snapshot through VIMClient amd enable the quiesce filesystem checkbox.

You can find debugging info in the file c:\freeze.log, if everything went fine it should say freeze OK/IO SEQUENCE = <some number> and thaw OK.

You need to enable VMware Tools Quiesce in the Veeam Backup job options.
I'm not sure wether it makes sense to leave Veeam Backups's own VSS handler enabled or better disable it for the specific VMs.

Regards, Felix
Felix
Enthusiast
 
Posts: 37
Liked: 2 times
Joined: Fri Oct 30, 2009 2:43 am
Full Name: Felix Buenemann

[MERGED] Backup VM with SAP and MaxDB

Veeam Logoby HendrikHackmann » Tue Sep 29, 2015 6:37 am

Hello,

is anyone using VEEAM to Backup a VMWARE Guest with SAP and MaxDB?
Is there any documented and certified way to do this?

I look forward to receiving your feedback

Thanks
Hendrik
HendrikHackmann
Lurker
 
Posts: 1
Liked: never
Joined: Tue Sep 29, 2015 6:29 am
Full Name: Hendrik Hackmann

Re: Backup VM with SAP and MaxDB

Veeam Logoby PTide » Tue Sep 29, 2015 10:13 am

Hi,

Currently the only way to backup some unsupported database is to use pre/post guest script approach, see above. Starting v8, using these scripts can be fully automated in the backup job, as a part of guest processing.

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

Re: Create a MAXDB (SAP) backup

Veeam Logoby Andreas Neufert » Wed May 18, 2016 8:02 am 1 person likes this post

Starting from 7.8.02 and 7.9 it isn´t anymore supported to stop the log writer with above script. The replacement commands for this can be found in the SAPNOTE 1928060
Andreas Neufert
Veeam Software
 
Posts: 2198
Liked: 357 times
Joined: Wed May 04, 2011 8:36 am
Location: Germany
Full Name: @AndyandtheVMs Veeam PM

Re: Create a MAXDB (SAP) backup

Veeam Logoby fwagner » Wed Jun 01, 2016 12:22 pm

You can also use our MaxDB VSS Writer (see http://www.maxback.io).

It has been created by our company explicitly for integration with Veeam and has been released as part of our MaxDB backup solution recently.

Best Regards,
Frank
fwagner
Lurker
 
Posts: 2
Liked: never
Joined: Wed Jun 01, 2016 12:03 pm
Full Name: Frank Wagner

Re: Create a MAXDB (SAP) backup

Veeam Logoby Andreas Neufert » Thu Jun 02, 2016 7:58 am

very cool, thank you.

Is the VSS Writer free or paid?
Andreas Neufert
Veeam Software
 
Posts: 2198
Liked: 357 times
Joined: Wed May 04, 2011 8:36 am
Location: Germany
Full Name: @AndyandtheVMs Veeam PM

Re: Create a MAXDB (SAP) backup

Veeam Logoby fwagner » Thu Jun 02, 2016 7:14 pm

Is the VSS Writer free or paid?


It is a paid solution.

If you what to know more just send me an email or use the contact form on http://www.maxback.io.

Best Regards,
Frank
fwagner
Lurker
 
Posts: 2
Liked: never
Joined: Wed Jun 01, 2016 12:03 pm
Full Name: Frank Wagner

[MERGED] VBR and MAXDB snapshots

Veeam Logoby thylab » Mon Jul 11, 2016 2:09 pm

Hi All

Hoping someone can perhaps share some information and tips with regards to backing up SAP running MAXDB which isnt VSS compatible. What would be the best way have consistent backups of this SAP MAXDB database?

Any assistance would be appreciated.
Kind Regards
thylab
Influencer
 
Posts: 10
Liked: 1 time
Joined: Mon Jul 11, 2016 1:57 pm
Full Name: Thys Basson

Re: Create a MAXDB (SAP) backup

Veeam Logoby Vitaliy S. » Mon Jul 11, 2016 3:05 pm

Hi Thys, if VSS cannot be used, then pre-freeze/post-thaw scripts should be a way to go. Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19541
Liked: 1098 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Majestic-12 [Bot], quazer and 53 guests