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 备份,出现以上错误;经查看原来是备份空间已经满了。
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) 磁盘空间不足。
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
- ORA-19502&ORA-27072
- RMAN ORA-19502&ORA-27072
- ORA
- ora
- ora-19624 ora-19502 ora-27040
- RMAN转储数据文件报错"ORA-19870 ORA-19502 ORA-27072"
- ORA-16038 ORA-19502 ORA-00312错误案例
- Oracle故障处理 ORA-16038 ORA-19502 ORA-00312
- ORA-00600 [kmgs_parameter_update_timeout_1], [27072] ORA-27072 解决方法
- 关于 ORA-19502 ORA-15081 问题
- ORA-27072 instance crash
- ORA-19502 磁盘空间不足
- Oracle Bug 4401119 for AIX Database crashes with ORA-221, ORA-206, ORA-202, ORA-27072
- ORA-01034 ORA-27101
- ORA-10567,ORA-00313
- ora-01128,ora-00275
- ORA-03113,ORA-07445
- ORA-32017 ORA-16179
- c++builder文件读写方法
- select、poll、epoll之间的区别总结[整理]
- The First One
- 在PowerShell 5.0中用Class关键字定义方法
- 【浏览器选择文件夹】springMVC上传篇
- ORA-19502&ORA-27072
- mysql的date操作
- Core Animation继承结构和基础介绍
- Android之批量加载图片OOM问题解决方案
- 堆叠相册效果,兼容pc和移动端
- 使用WinDbg —— .NET篇 (三)
- 语义分析的一些方法(中篇)
- oracle 数据库 日期
- Set List Map Vector ArrayList区别