HANA 数据库备份hang住的解决办法
今天遇到 HANA 数据库备份hang住的情况。经过查 SAP NOTE 解决,记录一下过程。两个NOTE如下:
2452735 - HANA Backup failing with "[447]: backup could not be completed: [110122] A data backup cannot be created because another data backup is running or a storage snapshot has been prepared."https://launchpad.support.sap.com/#/notes/24527352827950 - How-To: Cancel Hanging Backup on SAP HANAhttps://launchpad.support.sap.com/#/notes/2827950负责备份同事报告,HANA 数据库备份失败。报错如下,完全符合NOTE 2452735中的描述,因为同一时间只能有一个备份执行,所有要把未能正常结束的备份进程杀掉。
"[447]: backup could not be completed: [110122] A data backup cannot be created because another data backup is running or a storage snapshot has been prepared."
打开 HANA Studio 开启 SQL Console 执行NOTE中的 sql 查看中备份情况,发现有一个ID为1633757933867 的 Backint 类型备份没有正常结束。
select * from "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running';
打开 Backup 页面,ID为 1633757933867 的备份当时Status列没有绿黄红灯状态,状态未知。
根据NOTE,找到并查看日志文件 /hana/shared/<SID>/HDB00/<HOSTNAME>/trace/<DB_tenentdbSID>/backint.log
locate backint.log
vim /hana/shared/<SID>/HDB00/<HOSTNAME>/trace/<DB_tenentdbSID>/backint.log
在日志中按照时间和备份的ID号,找到相应的 pid (是37023),把这个出问题的进程 kill 掉。
xxxx-xx-xx xx:xx:xx.xxx backint started: command: /usr/sap/SID/SYS/global/hdb/opt/hdbbackint -f backup -i /var/tmp/hdbbackint_SID.XXXXXX -o /var/tmp/hdbbackint_SID.XXXXXX -u SID -s 1604925958336 -c 1 -l LOG pid: 1887 <-- Process to kill input: #SOFTWAREID "backint 1.04" "HANA HDB server 4.50.000.00.0000000000"
kill -9 37023
再发起备份就完全正常了。
文章来自于网络,如果侵犯了您的权益,请联系站长删除!