This discussion is archived
2 Replies Latest reply: Aug 27, 2013 4:50 AM by saurabh RSS

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

1013248 Newbie
Currently Being Moderated

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)?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points