Re: Urgent help needed. Datafile dropped from OS. Please help.
Date: Tue, 18 Nov 2008 21:53:35 +0100
Message-ID: <49232b4d$0$8912$426a74cc@news.free.fr>
"dbagtcol" <cx4gtcol_at_gmail.com> a écrit dans le message de news:
044b0c9a-6708-4782-9428-95e943d7ed90_at_s1g2000prg.googlegroups.com...
> 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