HANA Backup Automation Bash Script

[#1]

i have used the below script to automate the HANA backup and its working fine. but i would need to take the system DB backup as well. if i add "for SYSTEMDB" is giving below error

Error : 7: feature not supported: Invalid options FULL SYSTEM / FOR DATABASE (only on SYSTEMDB) SQLSTATE: HY000

#!/bin/sh

#/* Backup script */

source $HOME/.bashrc

date="$(date +"%Y-%m-%d")"

time="$(date +"%Y-%m-%d %H:%M:%S")"

backup="backup data using file ('$date')"

echo "daily backup :" $time "Start" >> $DIR_INSTANCE/backup.log

$DIR_EXECUTABLE/hdbsql -U backup -x $backup

time="$(date +"%Y-%m-%d %H:%M:%S")"

echo "daily backup :" $time "End" >> $DIR_INSTANCE/backup.log

Thanks

Ruchira Senevirathne

[HakanHaslaman]

I see the same error, if run a Backup via HDBSQL and the connection was done to the Tenant DB instead of the System DB.

Please check the attachment of https://launchpad.support.sap.com/#/notes/1651055 and check, if this helps you further https://developers.sap.com/tutorials/hxe-ua-dbfundamentals-backups.html (in the last part of the page)

[charithw]

Hi Hakan Haslaman,

Thank you for the details. 🙂

Thanks

Ruchira