ORA-00313 9.2.0.4.0 - 64bit
Good morning all
after an outage my Oracle database has a problem. the database is open but when i try some operation i have these errors in my alert file
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/apps/oracle/oradata/redo02.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 24: Too many open files
Additional information: 2
the OUTPUT of this query give me this result
SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE;
GROUP#||';'||STATUS||';'||MEMBER
----------------------------------------------------------------------------------------------------
3;;/apps/oracle/oradata/redo03.log
2;;/apps/oracle/oradata/redo02.log
1;STALE;/apps/oracle/oradata/redo01.log