This discussion is archived
3 Replies Latest reply: Aug 28, 2013 5:02 AM by 1013248 RSS

Users Tablespace

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

  • 1. Re: Users Tablespace
    Karthick_Arp Guru
    Currently Being Moderated

    Try General Questions forum. This forum is primarily for SQL and PL/SQL related questions.

  • 2. Re: Users Tablespace
    EdStevens Guru
    Currently Being Moderated

    1013248 wrote:

     

    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:

    1. SELECT STATUS FROM v$instance; 
    2. STATUS 
    3. ------------ 
    4. MOUNTED 
    5. ALTER DATABASE OPEN
    6. ERROR at line 1: 
    7. ORA-00313: open failed for members of log group 1 of thread 1 
    8. ORA-00312: online log 1 thread 1: '/oracle/oradata/DEV/redo01.log' 
    9. ORA-27037: unable to obtain file status 
    10. Linux-x86_64 Error: 2: No such file or directory 
    11. 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)?

    looks like more than the user01.dbf file was removed.  your error is reporting a missing redo log file, which is an entirely different kettle of fish.

     

    Are your redo logs multiplexed?  Do you have a backup?  Why and how were the files removed?  The fact that you report that a data file was removed but oracle reports that a redo has gone missing suggests there is a lot more that we need to know.  But it still comes back to ... What backups do you have?

  • 3. Re: Users Tablespace
    1013248 Newbie
    Currently Being Moderated

    Thanx for the answer, but I droped the database and created it again.

    I didn´t have a backup and it was too time consuming to repair the mess.

Legend

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