Re: Urgent help needed. Datafile dropped from OS. Please help.

From: astalavista <>
Date: Tue, 18 Nov 2008 21:53:35 +0100
Message-ID: <49232b4d$0$8912$>

"dbagtcol" <> a écrit dans le message de news:
> Hi all
> Somebody just dropped an Oracle datafile from OS commands in our
> development RAC. The tablespace isn't that important but i am afraid
> RAC may be down. Please suggest how can I get rid of this tablespace.
> I am on RAC environment with two nodes, in noarchivelog mode.
> When I to drop the tablespace, it gives me this error:
> ORA-01116: error in opening database file 24
> ORA-01110: data file 24: '/oracle/undo01/S0031001_X.dbf'
> ORA-27041: unable to open file
> Linux-x86_64 Error: 2: No such file or directory

did you try to comment undo_tablespace in int.ora and start the database ? Received on Tue Nov 18 2008 - 14:53:35 CST

Original text of this message