ITPub博客

首页 > 数据库 > Oracle > ORA-19502: write error on file

ORA-19502: write error on file

原创 Oracle 作者:wenjunheyixiao 时间:2016-07-23 16:54:10 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-12-02

  • 博文量
    117
  • 访问量
    162132