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

On Nov 18, 9:14 am, dbagtcol <cx4gt..._at_gmail.com> wrote:
> 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
>
> Please help. please help.
>
> gtcol

Check to see if the tablespace is still defined to the system. If it is then use the alter tablespace drop datafile command to drop the missing file.

Next use drop tablespace including contents to remove the tablespace.

HTH -- Mark D Powell -- Received on Tue Nov 18 2008 - 08:36:44 CST