oracle意外宕机

mason003

os：windows 2003 Enterprise X64   Service Pack 2 （5.2 版本3790）16G内存

oracle版本:10.2.0.5 单机
--添加：以前使用 MSCS和failsafe 做的双机 现在修改成单机

存储：ds4700 文件系统肯定够用

数据库意外宕机2次，附件为日志，请协助查看

2013-2-2 7:00 左右m001进程死掉造成数据库宕机，日志里只写了m001进程死掉，怀疑os导致oracle宕机

2013-2-2 9:20 左右先报出ora-07445之后dbwr进程死掉，pmon发现dbwr进程死掉造成数据库宕机

2次宕机os一直没有死掉，只有数据库宕了

查看操作系统日志发现很多组策略报错

我不知道这个问题是由于操作系统导致的数据库宕机还是数据库的bug

mason003

thanks maclean   因为这个原因我真的不知道该如何写   谢谢理解

Maclean Liu(刘相兵

先打 bug 9772888 RDBMS 10.2.0.5 BUFFER CACHE PRODID-5 PORTID-23 Abstract: WARNING:COULD NOT LOWER THE ASYNCH I/O LIMIT TO 160 FOR SQL DIRECT I/O. 看看吧

Maclean Liu(刘相兵

对于这个问题 不太想看， 原因：

1. 帖子一开始不完整
2. 日志一开始贴的不对。。。。。。。。。来回折腾。。。
3. 标题始终无实际意义

Maclean Liu(刘相兵

1. 
   
2. Redo thread mounted by this instance: 1
   
3. 
   
4. Oracle process number: 29
   
5. 
   
6. Windows thread id: 2692, image: ORACLE.EXE (SHAD)
   
7. 
   
8. 
   
9. *** SERVICE NAME:(SYS$USERS) 2013-01-26 04:59:14.035
   
10. *** SESSION ID:(838.47337) 2013-01-26 04:59:14.035
    
11. WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
    
12. WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
    
13. WARNING:Could not lower the asynch I/O limit to 224 for SQL direct I/O. It is set to -1
    
14. WARNING:Could not lower the asynch I/O limit to 192 for SQL direct I/O. It is set to -1
    
15. WARNING:Could not lower the asynch I/O limit to 256 for SQL direct I/O. It is set to -1
    
16. WARNING:Could not lower the asynch I/O limit to 224 for SQL direct I/O. It is set to -1
    
17. WARNING:Could not lower the asynch I/O limit to 192 for SQL direct I/O. It is set to -1
    
18. WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
    
19. WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
    
20. WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
    
21. WARNING:Could not lower the asynch I/O limit to 192 for SQL direct I/O. It is set to -1
    
22. WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
    
23. Dump file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2692.trc
    
24. Sat Feb 02 09:17:12 2013
    
25. ORACLE V10.2.0.5.0 - 64bit Production vsnsta=0
    
26. vsnsql=14 vsnxtr=3
    
27. Entering Exception Handler more than once
    
28. 
    
29. EnumerateLoadedModules64 failed with error -1073741819
    
30. 
    
31. 
    
32. Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
    
33. Process Id: 0x0000022c  Thread Id : 0x00000a84    Time : Sat Feb 02 09:17:12
    
34. Excp. Code: 0xc0000005  Excp. Type: ACCESS_VIO    Flags: 0x00000010
    
35. 
    
36. 
    
37. ------------------- Registers ----------------------------
    
38. ip=0000000078EE1CD6 sp=00000000125054C8 rp=0000000012506954
    
39. r1=00000000A44C0001 r2=0000000005030E50 r3=0000000000000520
    
40. r4=00000000125057B0 r5=00000000125054C8 r6=0000000012506954 r7=0000000005030E50
    
41. r8=0000000005030000 r9=0000000000000046 r10=0000000000000006 r11=0000000003E32467
    
42. r12=0000000000000003 r13=0000000000000000 r14=0000000000000006 r15=0000000000000046
    
43. ------------------- End of Registers ---------------------
    
44. 
    
45. 
    
46. *** 2013-02-02 09:17:12.476
    
47. ksedmp: internal or fatal error
    
48. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
49. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
50. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
51. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
52. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
53. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
54. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
55. ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x78EE1CD6] [ADDR:0x520] [UNABLE_TO_READ] []
    
56. ORA-07445: 出现异常错误: 核心转储 [ACC
    
57. Current SQL information unavailable - no session.
    
58. check trace file e:\oracle\product\10.2.0\db_1\rdbms\trace\orcl_ora_0.trc for preloading .sym file messages
    
59. ----- Call Stack Trace -----

复制代码

Maclean Liu(刘相兵

alert.log 最后日期为

Mon Nov 12 17:43:50 2012
Thread 1 advanced to log sequence 83132
  Current log# 3 seq# 83132 mem# 0: G:\ORACLE\ORCL\REDO03.LOG