今天接到一个电话，一个应用的同事说的登录不上数据库，该数据库是在一台windows服务器上的，登录主机后，发现在系统的服务里面，oracle是启动的，但是登录数据库发现数据库已经宕机。检查数据库的alertlog发现：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
Tue Oct 19 03:22:38 2010 Thread 1 advanced to log sequence 40786 Current log# 3 seq# 40786 mem# 0: D:\ORACLE\ORADATA\JPJDE2\REDO03.LOG Tue Oct 19 03:25:44 2010 Thread 1 advanced to log sequence 40787 Current log# 1 seq# 40787 mem# 0: D:\ORACLE\ORADATA\JPJDE2\REDO01.LOG Tue Oct 19 03:29:48 2010 Errors in file d:\oracle\admin\jpjde2\bdump\jpjde2_lgwr_2532.trc: ORA-00321: log 2 of thread 1, cannot update log file header ORA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\JPJDE2\REDO02.LOG' ORA-27091: skgfqio: unable to queue I/O ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 32) The process cannot access the file because it is being used by another process. Tue Oct 19 03:29:48 2010 Errors in file d:\oracle\admin\jpjde2\bdump\jpjde2_lgwr_2532.trc: ORA-00321: log 2 of thread 1, cannot update log file header LGWR: terminating instance due to error 321 Instance terminated by LGWR, pid = 2532 |
看来昨天晚上3 […]