ORA-19502&ORA-27072

来源:互联网 发布:提现棋牌源码 编辑:程序博客网 时间:2024/05/21 17:41

说明: 某天在rman 备份时报以下错误!

RMAN-03002: backup plus archivelog 命令 (在 03/16/2014 21:46:20 上) 失败
ORA-19502: 文件 "/u01/lch/TIMRAN11G/backupset/2014_03_16/o1_mf_annnn_TAG20140316T214456_%u_.bkp", 块编号 804865 (块大小=512) 上出现写入错误
ORA-27072: 文件 I/O 错误
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 804865
Additional information: 52736

rman 备份,出现以上错误;经查看原来是备份空间已经满了。


查看alert.log日志: 原来是磁盘空间不足

**********************************************************************************************************************
Errors in file f:\app\administrator\diag\rdbms\brorcl\brorcl\trace\brorcl_arc3_19032.trc:
ORA-19504: failed to create file "F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\BRORCL\ARCHIVELOG\2015_04_15\O1_MF_1_962_%U_.ARC"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) 磁盘空间不足。
ARC3: Error 19504 Creating archive log file to 'F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\BRORCL\ARCHIVELOG\2015_04_15\O1_MF_1_962_%U_.ARC'
ARCH: Archival stopped, error occurred. Will continue retrying
Errors in file f:\app\administrator\diag\rdbms\brorcl\brorcl\trace\brorcl_arc3_19032.trc:
ORA-16038: log 4 sequence# 962 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 1: 'F:\APP\ADMINISTRATOR\ORADATA\BRORCL\REDO004_1'
ORA-00312: online log 4 thread 1: 'F:\APP\ADMINISTRATOR\ORADATA\BRORCL\REDO004_2'
Wed Apr 15 14:51:13 2015
Thread 1 advanced to log sequence 964 (LGWR switch)
  Current log# 2 seq# 964 mem# 0: F:\APP\ADMINISTRATOR\ORADATA\BRORCL\REDO002_1
  Current log# 2 seq# 964 mem# 1: F:\APP\ADMINISTRATOR\ORADATA\BRORCL\REDO002_2
Wed Apr 15 14:51:18 2015
Errors in file f:\app\administrator\diag\rdbms\brorcl\brorcl\trace\brorcl_arc0_8412.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) 磁盘空间不足。

*****************************************************************************************************************************

【报错原因】

RMAN报错提示在生成备份集文件的时候遇到问题,文件I/O发生错误,所以怀疑是不是备份使用的空间满了,所以查看备份路径的空间,发现空间不够创建备份集文件。

0 0