Friday, October 5, 2012

ORA-00313 ,ORA-00312 open failed for members of log group

ORA-00313: open failed for members of log group 206 of thread 2
ORA-00312: online log 206 thread 2: '/u05/oradata/stdby/'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory



 Solution :

1-Mount the database.

SQL>STARTUP MOUNT
Database mounted.

2-Check the status of the logile to see whether it is current.

SELECT STATUS FROM V$LOG WHERE GROUP#=2;
STATUS
----------------
CURRENT
 Note : If the status did not CURRENT then simply drop the log file by:

 
SQL>ALTER DATABASE DROP LOGFILE GROUP 2;

3-Add new Redo Log by :

SQL>ALTER DATABASE ADD LOGFILE GROUP 4 'u03/App/Oradata/redo3.log' SIZE 50M;


4-Do Recover and Open Database Resetlog :


SQL>RECOVER DATABASE UNTIL CANCEL;
SQL>ALTER DATABASE OPEN RESETLOGS; 

Enjoy
Osama Mustafa

14 comments:

  1. thanksssssssssssssssssss

    ReplyDelete
  2. name: hamidreza
    family: fakhari
    email:esmid2@yahoo.com

    thanks for comment

    ReplyDelete
  3. same error in my alert log and continuous trace file created in udump

    ReplyDelete
  4. Hey man, i got the same problem but with my rac database. I have manual deleted one log file in the +FRA by my mistake, so what do i need to do to get rid of this error?

    Thanks in advance and sorry for my bad English!

    ReplyDelete
    Replies
    1. How could you delete redolog by mistake ?

      Delete
    2. I access asm though asmcmd and looking for the files inside it. Last time i got some problems which relate to file in redo log. I have backup redo log file which i deleted before delete it but i can't get it back though copy in Linux. It's my big mistake. Hiz. Can you give me some advice for that? Here is my alert log after delete one redo log file:
      ORA-00313: open failed for members of log group 1 of thread 1
      ORA-00312: online log 1 thread 1: '+FRA/mydb/onlinelog/group_1.256.810237741'
      ORA-17503: ksfdopn:2 Failed to open file +FRA/mydb/onlinelog/group_1.256.810237741
      ORA-15012: ASM file '+FRA/mydb/onlinelog/group_1.256.810237741' does not exist
      Errors in file /u01/app/oracle/diag/rdbms/mydb/mydb1/trace/mydb1_lgwr_16702.trc:
      ORA-00321: log 1 of thread 1, cannot update log file header
      ORA-00312: online log 1 thread 1: '+FRA/mydb/onlinelog/group_1.256.810237741'
      Errors in file /u01/app/oracle/diag/rdbms/mydb/mydb1/trace/mydb1_lgwr_16702.trc:
      ORA-00313: open failed for members of log group 1 of thread 1
      Thread 1 advanced to log sequence 711 (LGWR switch)
      Current log# 1 seq# 711 mem# 0: +DATA/mydb/onlinelog/group_1.262.810237741
      Fri Apr 05 01:02:19 2013
      Archived Log entry 1122 added for thread 1 sequence 710 ID 0x2c01e5e9 dest 1:
      Fri Apr 05 01:59:33 2013
      Clearing Resource Manager plan via parameter

      Delete
  5. What is the solution if the redo log file is the current redolog file?

    ReplyDelete
    Replies
    1. there's command called
      Alter system Switch logfile / Alter system checkpoint

      Delete
  6. Hi I am also facing the same problem. Here, redolog files has been deleted and there are no redolog files and the one showing is current, How to resolve this?

    ReplyDelete
    Replies
    1. alter system switch logfile
      Alter system checkpoint

      but at least you should have 2 redolog on your database .

      Delete
  7. sir when i try to drop my group that is not current they give error ORA-00350: log 3 of instance orcl3 (thread 1) needs to be archived what solution of this ........

    ReplyDelete
    Replies
    1. SQL> alter database clear unarchived logfile group 3;
      SQL> alter database drop logfile group 3;
      add new log

      Delete