Log Wait In Shutting Down The database
969526Mar 19 2013 — edited Mar 19 2013Hi Exports,
We have a production server. It contain its some of its datafile a cluster disk on windows server 2008. Yesterday Suddenly one of the cluster disk offline due to some network issue. And i found the following error on my alert log.
Mon Mar 18 19:59:27 2013
KCF: write/open error block=0xd13a6 online=1
file=22 M:\LEGACY_ORADATA\LEGACY.DBF
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 19) The media is write protected.'
Mon Mar 18 19:59:27 2013
Automatic datafile offline due to write error on
file 22: M:\LEGACY_ORADATA\LEGACY.DBF
Mon Mar 18 19:59:28 2013
KCF: write/open error block=0xd3c10 online=1
file=22 M:\LEGACY_ORADATA\LEGACY.DBF
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 19) The media is write protected.'
Mon Mar 18 19:59:28 2013
Automatic datafile offline due to write error on
file 22: M:\LEGACY_ORADATA\LEGACY.DBF
Mon Mar 18 21:49:34 2013
MMNL absent for 1204 secs; Foregrounds taking over
Mon Mar 18 22:00:05 2013
Errors in file d:\oracle\product\10.2.0\admin\legacy\bdump\legacy_j000_13148.trc:
ORA-12012: error on auto execute of job 8950
ORA-01115: IO error reading block from file ORA-01115: IO error reading block from file 5 (block # 106)
ORA-01110: data file 5: 'M:\LEGACY_ORADATA\OLD_TRANSACTION.DBF'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 21) The device is not ready.
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1500
ORA-06512: at "SYS.DBMS_SPACE", line 1566
(block # )
After that cluster disk available i am getting the same error. when i am trying to recover the datafile then i got the the
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 22 - file is in use or recovery
ORA-01110: data file 22
So check the database open_mode and it shows READ WRITE.
so i fire shut Immediate command. Now it take very long time to to shut down. Please suggest some solution as it is a prodtction database.
Thanks in advance...
Asit K. Mohanty