ORACLE故障重启,请达人留步：遭遇实例重启故障

目前数据库情况如下：

1.数据库为单机、Windows XP，版本为10.1.0.2.0。

2.数据库配置参数如下：

sga_max_size=171966464

sga_target=0

SYSTEM剩余空间1.04%，是自动扩展。

SYSAUX剩余空间1.79%，是自动扩展。

3.故障情况为过几天就会发生实例重启现象，查看alert日志发现如下错误：

Fri May 01 17:54:14 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_ckpt_664.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF'

ORA-01115: IO error reading block from file 2 (block # 1)

ORA-27072: File I/O error

OSD-04006: ReadFile() 失败, 无法读取文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。

Fri May 01 17:54:14 2009

CKPT: terminating instance due to error 1242

Fri May 01 17:54:15 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_pmon_2016.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Fri May 01 17:54:17 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\udump\orcl_ora_2656.trc:

ORA-01092: ORACLE instance terminated. Disconnection forced

Sun May 03 08:04:52 2009

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Mon May 04 17:09:05 2009

KCF: write/open error block=0x12ce4 online=1

file=5 D:\NCCDB\TOPO01.DBF

error=27072 txt: 'OSD-04008: WriteFile() 失败, 无法写入文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。'

Mon May 04 17:09:05 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_lgwr_1144.trc:

ORA-00345: redo log write error block 16866 count 4

ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG'

ORA-27072: File I/O error

OSD-04008: WriteFile() 失败, 无法写入文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。

DBW0: terminating instance due to error 1242

Mon May 04 17:09:06 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\udump\orcl_ora_1424.trc:

ORA-01242: 数据文件出现介质故障: 数据库处于 NOARCHIVELOG 模式

Wed May 06 02:21:10 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_dbw0_1612.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-01114: IO error writing block to file 5 (block # 79920)

ORA-01110: data file 5: 'D:\NCCDB\TOPO01.DBF'

ORA-27072: File I/O error

OSD-04008: WriteFile() 失败, 无法写入文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。

DBW0: terminating instance due to error 1242

Wed May 06 02:21:11 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_mman_1380.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Thu May 07 18:25:47 2009

KCF: write/open error block=0x66c7 online=1

file=3 D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF

error=27072 txt: 'OSD-04008: WriteFile() 失败, 无法写入文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。'

Thu May 07 18:25:48 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_dbw0_688.trc:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

ORA-01114: IO error writing block to file 3 (block # 26311)

ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF'

ORA-27072: File I/O error

OSD-04008: WriteFile() 失败, 无法写入文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。

Sat May 09 17:47:25 2009

KCF: write/open error block=0x3151 online=1

file=5 D:\NCCDB\TOPO01.DBF

error=27072 txt: 'OSD-04008: WriteFile() 失败, 无法写入文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。'

Sat May 09 17:47:26 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_dbw0_700.trc:

ORA-00202: controlfile: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL01.CTL'

ORA-27091: unable to queue I/O

ORA-27070: async read/write failed

OSD-04006: ReadFile() 失败, 无法读取文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。

Tue May 26 15:42:49 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_lgwr_1156.trc:

ORA-00345: redo log write error block 8728 count 2

ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG'

ORA-27072: File I/O error

OSD-04008: WriteFile() 失败, 无法写入文件

O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。

LGWR: terminating instance due to error 340

Tue May 26 15:42:50 2009

Errors in file d:\oracle\product\10.1.0\admin\orcl\bdump\orcl_q001_38924.trc:

ORA-00340: IO error processing online log  of thread

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

从网上搜索相关信息后，做了如下检查：

OS的配额设置：正常

数据文件、控制文件、日志文件状态：目前正常

虽然sga设置只有171M左右，但从错误说明看SGA大小并不是直接原因吧？

最有可能的是不是硬盘损坏？用oracle的哪些命令能检测硬盘状况呢？

以上问题百思不得其解，还望各位达人指教，谢谢~

[本帖最后由 learninfly 于 2009-5-30 10:58 编辑]