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