Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

system made a temp hung up in oracle 10GR4 in window 2003

592815Jan 6 2009 — edited Jan 6 2009
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2009
Added on Jan 6 2009
7 comments
725 views