Database Administration (MOSC)

MOSC Banner

ORA-00313 9.2.0.4.0 - 64bit

edited Oct 28, 2016 5:01AM in Database Administration (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center