Home » Server Options » RAC & Failsafe » database goes down (oracle 10.2.0, failsafe 3.3.4,windows 64bit)
database goes down [message #304540] Wed, 05 March 2008 10:18 Go to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
Hi Experts,
The database is on 64 bit windows. we are cluster utility fail safe. version is 10.2.1. my database goes down when i review the alert log i found the error which i have pasted below.
i want to know what is the problem ??

Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc1_2264.trc:
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:23:22 2008
KCF: write/open error block=0x8977 online=1
file=3 L:\ORACLE\ORADATA\FAB300\SYSAUX01.DBF
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1167) The device is not connected.'
Sat Mar 01 21:23:34 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_mmon_3032.trc:
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:23:35 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc0_1636.trc:
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:23:36 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_dbw0_2808.trc:
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:23:37 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_lgwr_1752.trc:
ORA-00345: redo log write error block 145413 count 100
ORA-00312: online log 2 thread 1: 'L:\ORACLE\ORADATA\FAB300\REDO02A.LOG'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1167) The device is not connected.

Sat Mar 01 21:23:42 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_ckpt_2024.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'M:\ORACLE\ORADATA\FAB300\CONTROL02.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1167) The device is not connected.
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1167) The device is not connected.

Sat Mar 01 21:23:42 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_ckpt_2024.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'M:\ORACLE\ORADATA\FAB300\CONTROL02.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1167) The device is not connected.
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1167) The device is not connected.

Sat Mar 01 21:23:43 2008
CKPT: terminating instance due to error 221
Sat Mar 01 21:23:43 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_q002_2468.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:23:46 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_psp0_604.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:23:52 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_pmon_2956.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:23:53 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_mman_1556.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:24:00 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_j001_2712.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:24:00 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_lgwr_1752.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:24:16 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_reco_756.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:24:19 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_smon_2960.trc:
ORA-00221: error on write to control file

Sat Mar 01 21:24:43 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_dbw0_2808.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:24:53 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc0_1636.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:24:54 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc0_1636.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:24:54 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc0_1636.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:24:54 2008
Master background archival failure: 204
Sat Mar 01 21:25:10 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_mmon_3032.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kxsdcbc+1053] [PC:0x9A3183] [ADDR:0x1C] [UNABLE_TO_READ] []
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:25:20 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc1_2264.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:25:20 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc1_2264.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:25:20 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_arc1_2264.trc:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:25:20 2008
Master background archival failure: 204
Sat Mar 01 21:25:27 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_mmon_3032.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kxsdcbc+1053] [PC:0x9A3183] [ADDR:0x1C] [UNABLE_TO_READ] []
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

Sat Mar 01 21:25:28 2008
Errors in file c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_mmon_3032.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kxsdcbc+1053] [PC:0x9A3183] [ADDR:0x1C] [UNABLE_TO_READ] []
ORA-00202: control file: 'L:\ORACLE\ORADATA\FAB300\CONTROL01.CTL'
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 1167) The device is not connected.

please help me

Thanks,
Sheldon
Re: database goes down [message #304542 is a reply to message #304540] Wed, 05 March 2008 10:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i want to know what is the problem ??

What part of "O/S-Error: (OS 1167) The device is not connected" do you NOT understand?

One or more of your disk volumes is/are no longer accessible to your system.

Contact your System Administrator for assistance.
Re: database goes down [message #304550 is a reply to message #304540] Wed, 05 March 2008 10:39 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
ok...
thanks for your assistance.
i think the L: drive was not accessible.
because all the errors are shown in L: drive.
my controlfile is in L: drive or what??
Re: database goes down [message #304553 is a reply to message #304540] Wed, 05 March 2008 11:10 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>because all the errors are shown in L: drive.
Not ALL the errors.

>Sat Mar 01 21:23:42 2008
>Errors in file >c:\oracle\product\10.2.0\admin\fab300\bdump\fab300_ckpt_2024.trc:
>ORA-00206: error in writing (block 3, # blocks 1) of control file
>ORA-00202: control file: 'M:\ORACLE\ORADATA\FAB300\CONTROL02.CTL'

It appears M:\ has also gone missing.

Previous Topic: May somebody send me document for installing Oracle10g RAC in Solaris?
Next Topic: question on RAC configuration
Goto Forum:
  


Current Time: Thu Mar 28 03:55:24 CDT 2024