ORA-19502: write error on file

1         

问题:

RMAN> backup database;

 

Starting backup at 23-JUL-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/enmoedu1/system01.dbf

input datafile file number=00002 name=/u01/app/oracle/oradata/enmoedu1/sysaux01.dbf

input datafile file number=00005 name=/u01/app/oracle/oradata/enmoedu1/example01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/enmoedu1/undotbs01.dbf

input datafile file number=00006 name=/u01/app/oracle/oradata/enmoedu1/ts_users01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/enmoedu1/users01.dbf

channel ORA_DISK_1: starting piece 1 at 23-JUL-16

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/23/2016 14:37:34

ORA-19502: write error on file "/u01/app/oracle/fast_recovery_area/ENMOEDU1/backupset/2016_07_23/o1_mf_nnndf_TAG20160723T143733_cs645fhs_.bkp", block number 4224 (block size=8192)

ORA-27072: File I/O error

Additional information: 4

Additional information: 4224

Additional information: 331776

 

2

原因:

磁盘空间不足;

 

 

3

验证:

加大磁盘之后:

RMAN> backup database;

 

Starting backup at 23-JUL-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=133 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oralce/oradata/enmoedu1/system01.dbf

input datafile file number=00002 name=/u01/app/oralce/oradata/enmoedu1/sysaux01.dbf

input datafile file number=00005 name=/u01/app/oralce/oradata/enmoedu1/example01.dbf

input datafile file number=00003 name=/u01/app/oralce/oradata/enmoedu1/undotbs01.dbf

input datafile file number=00004 name=/u01/app/oralce/oradata/enmoedu1/users01.dbf

channel ORA_DISK_1: starting piece 1 at 23-JUL-16

channel ORA_DISK_1: finished piece 1 at 23-JUL-16

piece handle=/u01/app/oralce/fast_recovery_area/ENMOEDU1/backupset/2016_07_23/o1_mf_nnndf_TAG20160723T165635_cs6db347_.bkp tag=TAG20160723T165635 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 23-JUL-16

channel ORA_DISK_1: finished piece 1 at 23-JUL-16

piece handle=/u01/app/oralce/fast_recovery_area/ENMOEDU1/backupset/2016_07_23/o1_mf_ncsnf_TAG20160723T165635_cs6dbm63_.bkp tag=TAG20160723T165635 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 23-JUL-16

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606702/viewspace-2122422/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/30606702/viewspace-2122422/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值