Welcome 微信登录

首页 / 数据库 / MySQL / ORA-19502,ORA-27072 错误解决

1.1.1. ORA-19502,ORA-27072日期:2014-05-12 00:12环境:测试机【错误号】$ oerr ora 1950219502, 00000, "write error on file"%s", block number %s (block size=%s)"// *Cause: write error on output file// *Action: check the file$ oerr ora 2707227072, 00000, "File I/O error"// *Cause: read/write/readv/writev system call returned error, additional//       information indicates starting block number of I/O// *Action: check errno【情景描述】在RMAN中执行 backup database plus archivelog;命令进行数据库备份的时候,发生报错,备份失败。【报错信息】在RMAN中执行备份里命令时遇到的报错信息input datafile file number=00004name=/U01/app/Oracle/oradata/testdb/users01.dbfchannel ORA_DISK_1: starting piece 1 at2014-05-11 23:56:38RMAN-00571:===========================================================RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============RMAN-00571:===========================================================RMAN-03002: failure of backup plusarchivelog command at 05/11/2014 23:56:53ORA-19502: write error on file"/U01/app/test/rman/fra/TESTDB/backupset/2014_05_11/o1_mf_nnndf_TAG20140511T235638_9pz7fpb5_.bkp",block number 46336 (block size=8192)ORA-27072: File I/O errorAdditional information: 4Additional information: 46336Additional information: 53248查看alert.log日志:没有生成报错信息。【报错原因】RMAN报错提示在生成备份集文件的时候遇到问题,文件I/O发生错误,所以怀疑是不是备份使用的空间满了,所以查看备份路径的空间,发现空间不够创建备份集文件。【解决方法】删除无用/过期的备份集,释放空间,然后再次执行备份命令。ORA-01172、ORA-01151错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htmORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htmORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htmORA-00471 处理方法笔记 http://www.linuxidc.com/Linux/2013-09/90017.htmORA-00314,redolog 损坏,或丢失处理方法 http://www.linuxidc.com/Linux/2013-09/90646.htmORA-00257 归档日志过大导致无法存储的解决办法 http://www.linuxidc.com/Linux/2013-09/90594.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址