HANA数据库备份与恢复:
登录HANA数据库
hdbsql -n host -u SYSTEM -d SYSTEMDB
执行BACKUP
BACKUP DATA FOR SYSTEMDB USING FILE ('/usr/sap/ECD/HDB00/backup','COMPLETE_DATA_BACKUP666')
BACKUP DATA FOR ECD USING FILE ('/usr/sap/ECD/HDB00/backup','COMPLETE_DATA_BACKUP555')
命令说明:
BACKUP TYPE: DATA、DATA INCREMENTAL、DATA DIFFERENTIAL
检查备份文件:
ecdadm@saphanaecd:/> hdbbackupcheck -v /usr/sap/ECD/HDB00/backup/COMPLETE_DATA_BACKUP555_databackup_0_1
恢复命令:
RECOVER DATA FOR ECD USING FILE (‘文件目录/文件名前缀’) CLEAR LOG
RECOVER DATABASE FOR ECD UNTIL TIMESTAMP ‘YYYY-MM-DD HH:MM:SS’
RECOVER DATABASE FOR ECD UNTIL TIMESTAMP ‘YYYY-MM-DD HH:MM:SS’ USING DATA PATH (‘数据库备份文件目录’) USING LOG PATH (‘日志备份文件目录1’,‘日志备份文件目录2’)
除了命令行备份和恢复之外, 还可以使用HANA studio处理备份和恢复。
标签:ECD,MM,HANA,数据库,USING,备份文件,DATA,备份 From: https://blog.csdn.net/jason_xie0822/article/details/144263101