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

[dvankempen]

Hi Ruchira,

Note that the documented approach is to use SAP HANA cockpit

• Scheduling Backups | SAP HANA Administration with SAP HANA Cockpit

Note that Note 1651055 dates was last updated in 2014 (SAP HANA 1.0 SPS 08), long before multi-tenant databases, XS advanced, and the scheduling functionality of SAP HANA cockpit. According to the author "one of the most stupid things I’ve done in my life"

• https://blogs.sap.com/2014/11/27/new-and-final-version-of-backup-script/

See also

• https://blogs.sap.com/2014/03/14/sap-hana-academy-backup-and-recovery-scheduling-scripts-2/

At the time, DBACOCKPIT was most commonly used as most systems hosted Business Suite or Business Warehouse applications.

[charithw]

Hi Denys,

Thank you for the details.

since i was struggling to take bash script backup for SYSTEMDB, if I use the below parameter will resolve the issue right?

B.SERVICE_TYPE_NAME='nameserver'

Thanks

Ruchira

[dvankempen]

Looks about right (without documentation) but double check the syntax to see that the query retuns a result set and not an answer.