SAP Knowledge Base Article - Preview

3071072 - HANA Backup Automation Bash Script return an error

Symptom

Below script was used to automate the HANA backup and its working fine to the TenantDB. But if add "for SYSTEMDB" it 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


Read more...

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.