sap_hana

环境：HANA2.044，开发数据库(SYSTEMDB、DEV、QAS、POD、POQ)、正式数据库（SYSTEMDB、PRD、POP）DEV 、QAS、PRD在S4的DB13中发起备份作业，POD、POQ、POP、SYSTEMDB用OS脚本发起备份作业。 一、用脚本实施定时备份：开发数据库上1、确定数据库备份目录：/hana/shared/HED/HDB00/backup/data/DB_DEV/hana/shared/HED/HDB00/backup/data/DB_QAS/hana/shared/HED/HDB00/backup/data/DB_POD/hana/shared/HED/HDB00/backup/data/DB_POQ/hana/shared/HED/HDB00/backup/data/SYSTEMDB2、做一个备份脚本vi /tmp/backup.sh,脚本中的内容如下：PREFIX=“$(date+"$PREFIX”"----begin----------" hdbsql -i 00 -u SYSTEM -p 数据库密码 -n localhost:30013 “backup data for SYSTEMDB using file (‘$PREFI{X}^{\prime })"hdbsql-i00-uSYSTEM-p数据库密码-nlocalhost:30013"backupdataforPODusingfile{(}^{\prime }$PREFIX’)” hdbsql -i 00 -u SYSTEM -p 数据库密码 -n localhost:30013 “backup data for POQ using file (’$PREFI{X}^{\prime })"PREFIX="$(date +”%Y%m%d-%H%M%S")“echo “--------””$PREFIX""----end------------"修改/tmp/backup.sh文件属性未777.在root下用hedadm用户，crontab-e新建定时执行这个脚本：（查看crontab-l）01\ast \ast \ast su-hedadm-c"sh/tmp/backup.sh>>/tmp/backuplog.txt"等第二天观察是否执行成功。。。第二天检查，没有异常，POD、POQ、SYSTEMDB库已经在凌晨1点实施了备份正式数据库上1、确定数据库备份目录：/hana/shared/HEP/HDB00/backup/data/SYSTEMDB/hana/shared/HEP/HDB00/backup/data/D{B}_{P}RD/hana/shared/HEP/HDB00/backup/data/D{B}_{P}OP2、做一个备份脚本：vi/tmp/backup.sh,脚本中的内容如下：PREFIX="$(date +"%Y%m%d-%H%M%S")“echo “--------”“$PREFIX""----begin----------"hdbsql-i00-uSYSTEM-p数据库密码-nlocalhost:30013"backupdataforSYSTEMDBusingfile{(}^{\prime }$PREFIX’)” hdbsql -i 00 -u SYSTEM -p 数据库密码 -n localhost:30013 “backup data for POP using file (’$PREFI{X}^{\prime })"PREFIX="$(date +”%Y%m%d-%H%M%S”)“echo “--------””$PREFIX""----end------------"  修改/tmp/backup.sh文件属性未777.在root下用hepadm用户，crontab -e新建定时执行这个脚本：（查看crontab -l ）0 1 * * *  su - hepadm -c  “sh /tmp/backup.sh >> /tmp/backuplog.txt”  二、用脚本定期删除老的备份：开发数据库上1、确定日志备份目录：/hana/shared/HED/HDB00/backup/log/DB_DEV/hana/shared/HED/HDB00/backup/log/DB_QAS/hana/shared/HED/HDB00/backup/log/DB_POD/hana/shared/HED/HDB00/backup/log/DB_POQ/hana/shared/HED/HDB00/backup/log/SYSTEMDB2、确定数据库备份目录：/hana/shared/HED/HDB00/backup/data/DB_DEV/hana/shared/HED/HDB00/backup/data/DB_QAS/hana/shared/HED/HDB00/backup/data/DB_POD/hana/shared/HED/HDB00/backup/data/DB_POQ/hana/shared/HED/HDB00/backup/data/SYSTEMDB 3、编写脚本删除10天前的日志和数据库备份,把这些命令加入/tmp/backup.sh：find /hana/shared/HED/HDB00/backup/log/DB_DEV/log_backup*  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/log/DB_QAS/log_backup*  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/log/DB_POD/log_backup*  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/log/DB_POQ/log_backup*  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/log/SYSTEMDB/log_backup*  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/data/DB_DEV/databackup  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/data/DB_QAS/databackup  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/data/DB_POD/databackup  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/data/DB_POQ/databackup  -mtime +10 -exec rm -f {} ;find /hana/shared/HED/HDB00/backup/data/SYSTEMDB/databackup  -mtime +10 -exec rm -f {} ;       正式数据库上1、确定日志备份目录：/hana/shared/HEP/HDB00/backup/log/SYSTEMDB/hana/shared/HEP/HDB00/backup/log/DB_PRD/hana/shared/HEP/HDB00/backup/log/DB_POP————————————————版权声明：本文为CSDN博主「james-lx」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。原文链接：https://blog.csdn.net/ot512csdn/article/details/106763784