一聚教程网:一个值得你收藏的教程网站

热门教程

windows系统 Oracle数据文件大小为0的恢复例子

时间:2022-06-29 09:40:34 编辑:袖梨 来源:一聚教程网

一个网友的数据库部署在windows环境,可能是由于存储问题或者windows本身文件系统的问题,出现IO问题之后,最后数据库重启之后,竟然无法启动了,报错无法读取其中的几个文件,alert log如下:

Nov 14 12:33:12 2014
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m001_1704.trc  (incident=60577):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINC_METER_INFO.ams], [16], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 17) 系统无法将文件移到不同的磁盘驱动器。
......
......
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_4676.trc  (incident=92621):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCCKEY.ams], [21], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 22) 设备不识别此命令。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_4676.trc  (incident=92622):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCCKEY.ams], [22], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 23) 数据错误(循环冗余检查)。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_4676.trc  (incident=92623):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCCKEY.ams], [25], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 26) 无法访问指定的磁盘或软盘。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_4676.trc  (incident=92624):
..........
 
ORA-00600: internal error code, arguments: [17182], [0x00DCD3560], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17147], [0x00DCD3560], [], [], [], [], [], [], [], [], [], []
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_92644orcl_m000_3176_i92644.trc.
........
Starting up:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production.
Using parameter settings in server-side spfile D:ORACLEPRODUCT11.2.0DBHOME_1DATABASESPFILEORCL.ORA
........
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_6008.trc  (incident=92872):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_92872orcl_m000_6008_i92872.trc
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_6008.trc  (incident=92873):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_92873orcl_m000_6008_i92873.trc
Successful mount of redo thread 1, with mount id 1391358302
Trace dumping is performing id=[cdmp_20141114143618]
Database mounted in Exclusive Mode
Lost write protection disabled
Trace dumping is performing id=[cdmp_20141114143619]
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_6008.trc  (incident=92874):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
ORA-48101: error encountered when attempting to read a file [block] [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams] [0]
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_92874orcl_m000_6008_i92874.trc
Completed: ALTER DATABASE   MOUNT
Fri Nov 14 14:36:20 2014
ALTER DATABASE OPEN
Read of datafile 'D:ORACLEORADATAORCLZL9BASEITEM.DBF' (fno 6) header failed with ORA-01200
Rereading datafile 6 header failed with ORA-01200
Errors in file d:oraclediagrdbmsorclorcltraceorcl_ora_2876.trc:
ORA-01122: 数据库文件 6 验证失败
ORA-01110: 数据文件 6: 'D:ORACLEORADATAORCLZL9BASEITEM.DBF'
ORA-01200: 10240 的实际文件大小小于 44800 块的正确大小
ORA-1122 signalled during: ALTER DATABASE OPEN...
Trace dumping is performing id=[cdmp_20141114143621]
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_6008.trc  (incident=92875):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
ORA-48101: error encountered when attempting to read a file [block] [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams] [0]
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_92875orcl_m000_6008_i92875.trc
Fri Nov 14 14:36:21 2014
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m001_5816.trc  (incident=92880):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataHM_RUN.ams], [26], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 27) 驱动器找不到请求的扇区。
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_92880orcl_m001_5816_i92880.trc
Trace dumping is performing id=[cdmp_20141114143622]
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_6008.trc  (incident=92876):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
ORA-48101: error encountered when attempting to read a file [block] [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams] [0]
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
Fri Nov 14 14:37:18 2014
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_5340.trc  (incident=92877):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_5340.trc  (incident=92878):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCCKEY.ams], [25], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 26) 无法访问指定的磁盘或软盘。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_5340.trc  (incident=92879):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINC_METER_INFO.ams], [16], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 17) 系统无法将文件移到不同的磁盘驱动器。
.......
ORA-00600: internal error code, arguments: [17114], [0x010F35330], [], [], [], [], [], [], [], [], [], []
ORA-48312: Sweep incident 92687 staging file failed
ORA-00600: internal error code, arguments: [17182], [0x010F35330], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17147], [0x010F35330], [], [], [], [], [], [], [], [], [], []
Fri Nov 14 14:38:18 2014
..........
..........
Fri Nov 14 14:53:15 2014
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_3144.trc  (incident=108895):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 20) 系统找不到指定的设备。
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_108895orcl_m000_3144_i108895.trc
Successful mount of redo thread 1, with mount id 1391370839
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount exclusive
alter database open
Errors in file d:oraclediagrdbmsorclorcltraceorcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: 'D:ORACLEORADATAORCLZL9EXPENSE.DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 38) 已到文件结尾。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: 'D:ORACLEORADATAORCLZL9EPRDAT.DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 38) 已到文件结尾。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 15 - see DBWR trace file
ORA-01110: data file 15: 'D:ORACLEORADATAORCLZL9INDEXHIS.DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 38) 已到文件结尾。
Errors in file d:oraclediagrdbmsorclorcltraceorcl_dbw0_2808.trc:
ORA-01157: cannot identify/lock data file 16 - see DBWR trace file
ORA-01110: data file 16: 'D:ORACLEORADATAORCLZL9INDEXCIS.DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 38) 已到文件结尾。
Read of datafile 'D:ORACLEORADATAORCLZL9BASEITEM.DBF' (fno 6) header failed with ORA-01200
Rereading datafile 6 header failed with ORA-01200
Errors in file d:oraclediagrdbmsorclorcltraceorcl_ora_3380.trc:
ORA-01122: ????? 6 ????
ORA-01110: ???? 6: 'D:ORACLEORADATAORCLZL9BASEITEM.DBF'
ORA-01200: 10240 ????????? 44800 ??????
ORA-1122 signalled during: alter database open...
Fri Nov 14 14:53:16 2014
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m001_3752.trc  (incident=108903):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataHM_RUN.ams], [26], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。
O/S-Error: (OS 27) 驱动器找不到请求的扇区。
Incident details in: d:oraclediagrdbmsorclorclincidentincdir_108903orcl_m001_3752_i108903.trc
Errors in file d:oraclediagrdbmsorclorcltraceorcl_m000_3144.trc  (incident=108896):
ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [d:oraclediagrdbmsorclorclmetadataINCIDENT.ams], [19], [1], [], [], [], [], [], [], [], []
ORA-48102: encountered the end-of-file when reading the file
OSD-04026: 传递的参数无效。

O/S-Error: (OS 20) 系统找不到指定的设备。

我们可以看到,重启之前Oracle就开始报ORA-00700,ORA-00600以及ORA-48102错误。重启之后的错误更是郁闷,如下:


ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: 'D:ORACLEORADATAORCLZL9EXPENSE.DBF'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 38) 已到文件结尾。
很明显这是文件异常了,从操作系统查看,发现这4个文件大小居然为0了。 这显然是不正常的。 实际上我检查发现还有另外2个文件也是有问题,
可能是文件头损坏了,通过dbv校验直接报错。
最后经过处理之后,成功帮网友抢救了数据,据说最后只是发现某个核心表丢了一点数据,损失不大。
不推荐使用windows来跑Oracle,感觉总是会有一些莫名其妙的问题发生,而且很难搞。还有,数据库一定要归档模式,定期物理备份,否则
一旦出现故障,就是灾难性的。

热门栏目