2 Replies Latest reply: Aug 27, 2013 6:50 AM by saurabh RSS

    ORA-00313: open failed for members of log group 1 of thread 1

    1013248

      Hi,

       

      My DB is Oracle 11g and that is located on Linux.

      yesterday the users01.dbf file was removed and the database was (unfortunatelly) shutdown.

       

      I can´t startup the database without the following error:

      SELECT STATUS FROM v$instance;
      STATUS
      ------------
      MOUNTED
      
      
      ALTER DATABASE OPEN;
      ERROR at line 1:
      ORA-00313: open failed for members of log group 1 of thread 1
      ORA-00312: online log 1 thread 1: '/oracle/oradata/DEV/redo01.log'
      ORA-27037: unable to obtain file status
      Linux-x86_64 Error: 2: No such file or directory
      Additional information: 3
      

       

      There is no redo01.log file on my system!

       

      Is it possible to remove the tablespace and recreate it somehow?

      Or is it possible to recreate the database (The data is saved elsewhere)?