Re: sqldba startup problem

Ian Cary wrote:
>
> Hi Noorazmi,
>
> I am afraid that what you have done could be pretty serious depending
 on
> the surrounding cicumstances. Manually deleting Oracle datafiles is
> definately NOT the thing to do.
>
> If you can be sure that the datafile you deleted only conatained data
> for the user you deleted it may be possible to get the database back
 up
> by issuing the following
>
> >startup mount;
 

> >alter database datafile 'file_name' offline drop;
 

> >alter database open;
>
> If this doesn't work you will have to resort to recovery I'm afraid
 (I
> can help you with this if you are not familiar with it)
>
> There may also be a couple of other things to do but I would need
 more
> information about your setup (e.g. Number of projects, Location of
> tablespaces, which project is using which tablespace) before making
 any
> more recommendations.
>
> Regards,
>
> Ian Cary

I've solved the problem. Thanks.

I copied another database files from another tablespace and rename them DBNAME_DATA and DBNAME_INDEX. In sqldba I ran these commands:
>connect internal
>startup mount
>alter database datafile '../DBNAME_DATA' offline drop;
>alter database datafile '../DBNAME_INDEX' offline drop;
>alter database open;
>drop tablespace DBNAME_DATA;
>drop tablespace DBNAME_INDEX;

Everything's fine now.

Cheers

Azmi Received on Thu Jul 31 1997 - 00:00:00 CDT