database shutdown and error in alertlog
Hi all,
Can you please guide me. It has started since two days getting error in alert log. Also databse shutdown by itself at night. Then i have to restart it ever morning since two days: here is the text from Alertlog file:
Thu Jul 22 00:07:20 2010
Errors in file /LOcation/DBISNTANCE/admin/bdump/DBISNTANCE_lgwr_22648.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log'
ORA-27086: skgfglk: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 8
Thu Jul 22 00:07:20 2010
Doing block recovery for fno: 2 blk: 78
Thu Jul 22 00:07:20 2010
Errors in file /LOcation/DBISNTANCE/admin/bdump/DBISNTANCE_lgwr_22648.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log'
ORA-27086: skgfglk: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 8
Thu Jul 22 00:07:20 2010
LGWR: terminating instance due to error 313
Instance terminated by LGWR, pid = 22648
what is the solution?
thanks