-
Hi,
I check my alert file and found following error. On talking to my clleaues I found that some error occured in database and it was shutdown and again brought online. (I was on leave).
Foll is the SID ALERT log.
************************************
Dump file E:\oracle\P62\816\RDBMS\trace\p62ALRT.LOG
Thu Dec 06 16:13:12 2001
ORACLE V8.1.6.1.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 6, CPU type 586
Thu Dec 06 16:13:12 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\p62CKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'L:\ORACLE\P62\SAPARCH\CNTRL\CNTRLP62.DBF'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 21) The device is not ready.
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'J:\ORACLE\P62\ORIGLOGA\CNTRL\CNTRLP62.DBF'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 21) The device is not ready.
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'M:\ORACLE\P62\SAPDATA1\CNTRL\CNTRLP62.DBF'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 21) The device is not ready.
Thu Dec 06 16:13:12 2001
CKPT: terminating instance due to error 221
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00524.TRC:
ORA-00600: internal error code, arguments: [12333], [7], [3], [54], [], [], [], []
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00312.TRC:
ORA-00600: internal error code, arguments: [12333], [7], [3], [54], [], [], [], []
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\p62SMON.TRC:
ORA-00221: error on write to controlfile
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00275.TRC:
ORA-00600: internal error code, arguments: [12333], [7], [4], [195], [], [], [], []
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00476.TRC:
ORA-00221: error on write to controlfile
ORA-00221: error on write to controlfile
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00075.TRC:
ORA-00221: error on write to controlfile
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00347.TRC:
ORA-00221: error on write to controlfile
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00481.TRC:
ORA-00221: error on write to controlfile
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00570.TRC:
ORA-00221: error on write to controlfile
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00475.TRC:
ORA-00221: error on write to controlfile
Thu Dec 06 16:13:16 2001
Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00626.TRC:
ORA-00221: error on write to controlfile
****************************
SIDSMON.TRC
*** SESSION ID:(4.7) 2001-12-06 16:13:12.843
*** 2001-12-06 16:13:12.843
SMON: following errors trapped and ignored:
ORA-00221: error on write to controlfile
***********************************
SIDDBW0.TRC
*** 2001-12-06 16:13:15.781
*** SESSION ID:(2.1) 2001-12-06 16:13:13.890
error 221 detected in background process
********************************
I also found that this kind of error had occured earlier also in Sept and July.
What should I do. Any precaution to be taken .
--------------------------
The Time has come ....
-
Looks like a hardware problem involving I/O.
Get a hardware expert.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|