D:\oracle\product\11.2.0\dbhome_1\database
提示如下错误：（D:\oracle\diag\rdbms\seinescm\seinescm\alert\log.xml）
Errors in file D:\ORACLE\diag\rdbms\seinescm\seinescm\trace\seinescm_dbw0_5288.trc:
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 6 (block # 686464)
ORA-01110: data file 6: 'H:\DB_DATA\SEINESCMDB\STGDATA_DATA01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.
D:\oracle\diag\rdbms\seinescm\seinescm\trace
Trace file D:\ORACLE\diag\rdbms\seinescm\seinescm\trace\seinescm_dbw0_5288.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 32 - type 8664, 32 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:13116M/65512M, Ph+PgF:59256M/131024M
Instance name: seinescm
Redo thread mounted by this instance: 1
Oracle process number: 10
Windows thread id: 5288, image: ORACLE.EXE (DBW0)
*** 2016-03-03 07:36:00.533
*** SESSION ID:(711.1) 2016-03-03 07:36:00.533
*** CLIENT ID:() 2016-03-03 07:36:00.533
*** SERVICE NAME:(SYS$BACKGROUND) 2016-03-03 07:36:00.533
*** MODULE NAME:() 2016-03-03 07:36:00.533
*** ACTION NAME:() 2016-03-03 07:36:00.533
KCF: read, write or open error, block=0xa7980 online=1
file=6 'H:\DB_DATA\SEINESCMDB\STGDATA_DATA01.DBF'
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.'
Encountered write error
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 6: 'H:\DB_DATA\SEINESCMDB\STGDATA_DATA01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.
error 63999 detected in background process
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 6 (block # 686464)
ORA-01110: data file 6: 'H:\DB_DATA\SEINESCMDB\STGDATA_DATA01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
ksedsts()+585<-kjzdssdmp()+329<-kjzduptcctx()+288<-kjzdicrshnfy()+87<-ksuitm()+1562<-ksbrdp()+4371<-opirip()+853<-opidrv()+907<-sou2o()+98<-opimai_real()+299<-opimai()+191<-BackgroundThreadStart()+646<-00000000775559ED<-000000007768C521
----- End of Abridged Call Stack Trace -----
*** 2016-03-03 07:36:01.469
DBW0 (ospid: 5288): terminating the instance due to error 63999
Dump file d:\oracle\diag\rdbms\seinescm\seinescm\trace\seinescm_dbw0_5288.trc
Thu Mar 03 07:36:09 2016
ORACLE V11.2.0.3.0 - 64bit Production vsnsta=0
vsnsql=16 vsnxtr=3
*** 2016-03-03 07:36:09.206 ssthreadkillsafe: about to forcefully terminate tid=7828, dumping call stack:
------------------- Call Stack Trace ---------------------
*** 2016-03-03 07:36:09.269
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
00000000776B165A 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000011
000007FEFD691203 00000000776B1650 0000000034b5d268 0000000000000000 0000000034b5d1d0 0000000000000000
ksuitm()+840 000007FEFD691150 00000000298bf400 0000000000000001 0000000000000000 0000000000000000
ksliwat()+16434 ksuitm() 0000000000000000 000000000000f9ff 0000000000000000 0000000000000000
kslwaitctx()+184 ksliwat() 0000000928e7b858 0000000928e7b858 000001f4000001f4 00000000409d4b30
kslwait()+160 kslwaitctx() 0000000000000001 000000092b2d4818 0000000000000048 0000000145f8621f
ksarcv()+216 kslwait() 000006a90058280e 00000000000000e2 00000000000000d0 000006a90058280e
ksbabs()+533 ksarcv() 0000000000000000 0000000000cff45d 0000000000000000 00000000000001d0
ksbrdp()+1311 ksbabs() 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opirip()+853 ksbrdp() 000000000000001e 00000001476c3fac 0000000034b5f938 0000000000000001
opidrv()+907 opirip() 0000000000000032 0000000000000004 0000000034b5fd20 4f5c3a4400000000
sou2o()+98 opidrv()+150 0000000000000032 0000000000000004 0000000034b5fd20 0000000000000000
opimai_real()+299 sou2o() 01d1749e511c846d 0000000000000000 00000003000307e0 000401ed001c000c
opimai()+191 opimai_real() 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart()+646 opimai() 0000000034b5fe68 000000000000000d 0000000000000000 0000000000000000
00000000775559ED BackgroundThreadStart() 00000000042a8b10 0000000000000000 0000000000000000 0000000000000000
000000007768C521 00000000775559E0 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace -----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 63 ms
symbol translation time: 0 ms
total time: 63 ms
*** 2016-03-03 07:36:13.652
ksuitm: waiting up to [5] seconds before killing DIAG(5764)
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 32 - type 8664, 32 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:13116M/65512M, Ph+PgF:59256M/131024M
Instance name: seinescm
Redo thread mounted by this instance: 1
Oracle process number: 10
Windows thread id: 5288, image: ORACLE.EXE (DBW0)
*** 2016-03-03 07:36:00.533
*** SESSION ID:(711.1) 2016-03-03 07:36:00.533
*** CLIENT ID:() 2016-03-03 07:36:00.533
*** SERVICE NAME:(SYS$BACKGROUND) 2016-03-03 07:36:00.533
*** MODULE NAME:() 2016-03-03 07:36:00.533
*** ACTION NAME:() 2016-03-03 07:36:00.533
KCF: read, write or open error, block=0xa7980 online=1
file=6 'H:\DB_DATA\SEINESCMDB\STGDATA_DATA01.DBF'
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.'
Encountered write error
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 6: 'H:\DB_DATA\SEINESCMDB\STGDATA_DATA01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.
error 63999 detected in background process
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 6 (block # 686464)
ORA-01110: data file 6: 'H:\DB_DATA\SEINESCMDB\STGDATA_DATA01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 2) The system cannot find the file specified.
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
ksedsts()+585<-kjzdssdmp()+329<-kjzduptcctx()+288<-kjzdicrshnfy()+87<-ksuitm()+1562<-ksbrdp()+4371<-opirip()+853<-opidrv()+907<-sou2o()+98<-opimai_real()+299<-opimai()+191<-BackgroundThreadStart()+646<-00000000775559ED<-000000007768C521
----- End of Abridged Call Stack Trace -----
*** 2016-03-03 07:36:01.469
DBW0 (ospid: 5288): terminating the instance due to error 63999
Dump file d:\oracle\diag\rdbms\seinescm\seinescm\trace\seinescm_dbw0_5288.trc
Thu Mar 03 07:36:09 2016
ORACLE V11.2.0.3.0 - 64bit Production vsnsta=0
vsnsql=16 vsnxtr=3
*** 2016-03-03 07:36:09.206 ssthreadkillsafe: about to forcefully terminate tid=7828, dumping call stack:
------------------- Call Stack Trace ---------------------
*** 2016-03-03 07:36:09.269
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- ---------------- ---------------- ---------------- ----------------
00000000776B165A 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000011
000007FEFD691203 00000000776B1650 0000000034b5d268 0000000000000000 0000000034b5d1d0 0000000000000000
ksuitm()+840 000007FEFD691150 00000000298bf400 0000000000000001 0000000000000000 0000000000000000
ksliwat()+16434 ksuitm() 0000000000000000 000000000000f9ff 0000000000000000 0000000000000000
kslwaitctx()+184 ksliwat() 0000000928e7b858 0000000928e7b858 000001f4000001f4 00000000409d4b30
kslwait()+160 kslwaitctx() 0000000000000001 000000092b2d4818 0000000000000048 0000000145f8621f
ksarcv()+216 kslwait() 000006a90058280e 00000000000000e2 00000000000000d0 000006a90058280e
ksbabs()+533 ksarcv() 0000000000000000 0000000000cff45d 0000000000000000 00000000000001d0
ksbrdp()+1311 ksbabs() 0000000000000000 0000000000000000 0000000000000000 0000000000000000
opirip()+853 ksbrdp() 000000000000001e 00000001476c3fac 0000000034b5f938 0000000000000001
opidrv()+907 opirip() 0000000000000032 0000000000000004 0000000034b5fd20 4f5c3a4400000000
sou2o()+98 opidrv()+150 0000000000000032 0000000000000004 0000000034b5fd20 0000000000000000
opimai_real()+299 sou2o() 01d1749e511c846d 0000000000000000 00000003000307e0 000401ed001c000c
opimai()+191 opimai_real() 0000000000000000 0000000000000000 0000000000000000 0000000000000000
BackgroundThreadStart()+646 opimai() 0000000034b5fe68 000000000000000d 0000000000000000 0000000000000000
00000000775559ED BackgroundThreadStart() 00000000042a8b10 0000000000000000 0000000000000000 0000000000000000
000000007768C521 00000000775559E0 0000000000000000 0000000000000000 0000000000000000 0000000000000000
---------------- End of Call Stack Trace -----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 63 ms
symbol translation time: 0 ms
total time: 63 ms
*** 2016-03-03 07:36:13.652
ksuitm: waiting up to [5] seconds before killing DIAG(5764)
以上ORA-01115、ORA-01110、ORA-27091、ORA-27070、OSD-04006、O/S-Error 这堆报错本质与Oracle数据库层面没有关系，问题的根本原因是Windows上对应磁盘驱动器下的文件无法读取出来，这可能是OS bug 也可能就是对应磁盘出现了坏道或其他物理故障，所以对于该问题有限考虑在OS层面解决文件的读取问题， 如果确实发现无法从OS层面或从备份解决，那么可以考虑特殊的恢复手段。‘
浙公网安备 33010602011771号