发现的过程:
周一早晨上班例行看了下数据库没有备份(周六周日),怀疑是空间,为啥怀疑呢?因为通过查询备份日志没有报错,查询视图只看见有FAILED的错误,奇葩。于是改了下备份策略,多预留点空间。今早发现报错依旧,找了不繁忙的库,手工改执行脚本,看看到底有没有报错,惊喜!报错如下:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c3 channel at 05/10/2016 09:32:18
ORA-19504: failed to create file "/u01/bak/backup/mposbak/rmanbak/full_MPOS_20160510_3172_1"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 30: Read-only file system
解决:
去备份的这台服务器手工执行mkdir报错, Read-only file system
存储工程师没有发现备份的这台机器存储有一层,于是重启用于备份的服务器(nfs)。
周一早晨上班例行看了下数据库没有备份(周六周日),怀疑是空间,为啥怀疑呢?因为通过查询备份日志没有报错,查询视图只看见有FAILED的错误,奇葩。于是改了下备份策略,多预留点空间。今早发现报错依旧,找了不繁忙的库,手工改执行脚本,看看到底有没有报错,惊喜!报错如下:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c3 channel at 05/10/2016 09:32:18
ORA-19504: failed to create file "/u01/bak/backup/mposbak/rmanbak/full_MPOS_20160510_3172_1"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 30: Read-only file system
解决:
去备份的这台服务器手工执行mkdir报错, Read-only file system
存储工程师没有发现备份的这台机器存储有一层,于是重启用于备份的服务器(nfs)。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30536096/viewspace-2096880/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30536096/viewspace-2096880/