加载中…ORA-00376: 此时无法读取文件问题处理
(2010-07-21 16:18:03)
标签：
杂谈 |
分类： 故障处理 |
Alertlog中的错误信息：
Created Oracle managed file
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2010_07_17\O1_MF_1_7329_641T9YS2_.ARC
Sat Jul 17 08:29:35 2010
KCF: write/open error block=0x148de
online=1
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。'
Automatic datafile offline due to write error on
file 3:
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF
Sat Jul 17 08:29:37 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_5436.trc:
ORA-00202: 控制文件: 'D:\DISK3\CONTROL01.CTL'
ORA-27091: 无法将 I/O 排队
ORA-27070: 异步读取/写入失败
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
KCF: write/open error block=0x112 online=1
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。'
Automatic datafile offline due to write error on
file 7:
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\JERRY_UNDO.DBF
Sat Jul 17 08:31:47 2010
ORA-376 encountered when generating server alert SMG-3503
Sat Jul 17 08:31:48 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_7120.trc:
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF'
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 7097
ORA-06512: at line 1
Sat Jul 17 08:31:48 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_8132.trc:
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF'
ORA-06512: at "SYS.DBMS_AQ", line 577
ORA-06512: at "SYSMAN.EMD_NOTIFICATION", line 492
ORA-06512: at line 1
Sat Jul 17 08:31:49 2010
KCF: write/open error block=0x116e online=1
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。'
Sat Jul 17 08:31:49 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1656.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\JERRY_UNDO.DBF'
Sat Jul 17 08:31:50 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_dbw0_1596.trc:
ORA-01243: system tablespace file suffered media failure
ORA-01114: IO error writing block to file 1 (block # 4462)
ORA-01110: data file 1:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
DBW0: terminating instance due to error 1243
Sat Jul 17 08:31:51 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_smon_1656.trc:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\JERRY_UNDO.DBF'
Sat Jul 17 08:31:51 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_pmon_1472.trc:
ORA-01243: system tablespace file suffered media failure
Sat Jul 17 08:31:53 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_lgwr_1600.trc:
ORA-01243: system tablespace file suffered media failure
Sat Jul 17 08:31:53 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_ckpt_1576.trc:
ORA-01243: system tablespace file suffered media failure
Sat Jul 17 08:31:54 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_mman_1592.trc:
ORA-01243: system tablespace file suffered media failure
Sat Jul 17 08:32:14 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_q000_2332.trc:
ORA-01243: system tablespace file suffered media failure
Sat Jul 17 08:32:15 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_reco_1660.trc:
ORA-01243: system tablespace file suffered media failure
Sat Jul 17 08:32:17 2010
Instance terminated by DBW0, pid = 1596
Dump file
d:\oracle\product\10.1.0\admin\myoracle\bdump\alert_myoracle.log
ALERTLOG中，
ublished database character set on system events channel
Wed Jul 21 16:04:04 2010
All processes have switched to database character set
Wed Jul 21 16:04:04 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_5780.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00376: 此时无法读取文件 7
ORA-01110: 数据文件 7:
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\JERRY_UNDO.DBF'
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Wed Jul 21 16:04:05 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_dbw0_3056.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jul 21 16:04:05 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_pmon_1660.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jul 21 16:04:05 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_mman_4788.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jul 21 16:04:05 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_ckpt_5344.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jul 21 16:04:06 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_reco_3448.trc:
ORA-00604: error occurred at recursive SQL level
Wed Jul 21 16:04:06 2010
Errors in file
d:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_lgwr_4160.trc:
ORA-00604: error occurred at recursive SQL level
Instance terminated by USER, pid = 5780
ORA-1092 signalled during: alter database open...
原因可能是断电引起的，导致2个文件（数据文件3和数据文件7需要恢复），恢复后还是无法打开数据库，因为数据文件处于脱机状态，导致无法打开。
关于该错误的一个解释：
=====================================
SQL> /
STATUS
------- ----------
SYSTEM
ONLINE
OFFLINE
ONLINE
ONLINE
ONLINE
ONLINE
ONLINE
ONLINE
ONLINE
ONLINE
STATUS
------- ----------
ONLINE
ONLINE
ONLINE
ONLINE
已选择15行。
SQL> alter database datafile 3 online;
数据库已更改。
SQL> alter database open;
数据库已更改。
SQL>
喜欢
0
赠金笔