Re: Urgent help needed. Datafile dropped from OS. Please help.
Date: Tue, 18 Nov 2008 21:53:35 +0100
"dbagtcol" <cx4gtcol_at_gmail.com> 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 10.2.0.4 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