今天发现一个windows平台的数据库出现错误,引起的原因不清楚,报警日志记录如下:
Wed Feb 20 13:15:47 2008
found dead shared server 'S000', pid = (10, 6)
Wed Feb 20 13:51:21 2008
Errors in file d:\oracle\admin\oraweb\bdump\oraweb_lgwr_2300.trc:
orA-00313: open failed for members of log group 2 of thread 1
orA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\ORAWEB\REDO02.LOG'
orA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。Wed Feb 20 13:51:21 2008
Errors in file d:\oracle\admin\oraweb\bdump\oraweb_lgwr_2300.trc:
orA-00313: open failed for members of log group 2 of thread 1
orA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\ORAWEB\REDO02.LOG'
orA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。Wed Feb 20 13:51:21 2008
LGWR: terminating instance due to error 313
Wed Feb 20 13:51:21 2008
Errors in file d:\oracle\admin\oraweb\bdump\oraweb_pmon_2236.trc:
orA-00313: open failed for members of log group of threadWed Feb 20 13:51:22 2008
Errors in file d:\oracle\admin\oraweb\udump\oraweb_s000_3132.trc:
orA-00313: open failed for members of log group of thread
其实就是日志文件组1,2突然不知道被谁删除了,
startup mount;
select * from v$log;
日志文件组1,2的状态都是归档的,直接
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database open;
数据库正常打开。
如果日志文件组1,2的状态都是非归档的,则用:
alter database clear unarchived logfile group 1;
说明:
1)、如果损坏的是非当前的联机日志文件,一般只需要clear就可以重建该日志文件,但是如果该数据库处于归档状态但该日志还没有归档,就
需要强行clear。
2)、建议clear,特别是强行clear后作一次数据库的全备份。
3)、此方法适用于归档与非归档数据库。
Link URL: http://item.feedsky.com/~feedsky/csjrc/~6177577/52059292/4285523/1/item.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/89703/viewspace-203000/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/89703/viewspace-203000/