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.
- Code: Select all
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
- Code: Select all
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
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.Can you link me to the thread where Tom speaks about those scripts, I cant find it.
Correct.If I don't use any scripts but let Veeam backup the server I will still have crash consistent backups?
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.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).
Yes. I'd also recommend you to keep your db backup copy somewhere away from your production server.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?
Not yet. You can create a separate feature request thread for that so other users can vote for that feature.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.
# 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.
Users browsing this forum: morty and 52 guests