system made a temp hung up in oracle 10GR4 in window 2003
592815Jan 6 2009 — edited Jan 6 2009Hi Experts,
I got two times that system temp hung up.I saw alert info as
Mon Jan 05 18:33:22 2009
C001: large txn committed, xid: 0x000e.026.0003937f
Mon Jan 05 18:38:22 2009
C001: large txn committed, xid: 0x0010.003.00037e8c
Mon Jan 05 18:43:24 2009
C001: large txn committed, xid: 0x000c.014.00038a14
Mon Jan 05 18:48:22 2009
C001: large txn committed, xid: 0x000c.001.00038a1b
Mon Jan 05 18:53:23 2009
C001: large txn committed, xid: 0x0010.014.00037ebf
Mon Jan 05 18:58:23 2009
C001: large txn committed, xid: 0x0011.027.000332cb
Mon Jan 05 19:03:26 2009
C001: large txn committed, xid: 0x000b.00f.0002d4a5
Mon Jan 05 19:08:25 2009
C001: large txn committed, xid: 0x000c.02c.00038a28
Mon Jan 05 19:13:24 2009
Thread 1 advanced to log sequence 13909 (LGWR switch)
Current log# 2 seq# 13909 mem# 0: G:\ORACLE\ORADATA\SALE\REDO02.LOG
Current log# 2 seq# 13909 mem# 1:
G:\ORACLE\ORADATA\SALE\REDO02_MIRROR.LOG
Mon Jan 05 19:13:25 2009
Errors in file
d:\oracle\product\10.2.0\admin\SALE\bdump\SALE_arc0_2056.trc:
ORA-00333: redo log read error block 6145 count 2048
ORA-00312: online log 1 thread 1: 'G:\ORACLE\ORADATA\SALE\REDO01.LOG'
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 1450) Insufficient system resources exist to complete the
requested service
then on Mon Jan 05 19:19:27 2009
kcrrdmx: Successful archiving of previously failed ORL
Archiver process freed from errors. No longer stopped
If it is currept for REDO01.LOG. but now REDO01 and 2.LOG works
After install CA backup tool in other driver in that server. or apply a security patch in windwo system? why do i got this issue?
Any suggestion?
Thanks
JIm