Re: can not startup oracle database

From: <deharo_at_my-dejanews.com>
Date: Wed, 30 Sep 1998 09:27:18 GMT
Message-ID: <6usthm$sfn$1@nnrp1.dejanews.com>

In article <6un85l$99k$1_at_news.ksc.co.th>, "charnsil" <charnsil_at_ksc.th.com> wrote:
> i have problem. could you help me.?
> i deleted some datafile. and now i cannot startup database.
> it error ORA-01157 cannot identify datafile arap1.dat file not found.
>
> thank in advance
> charnsil_at_ksc.th.com
>
>

Hi,

For your problem, the solution depends on the tablespace to which the removed datafile belongs.
If that can help you, I 've already had this error (ORA-01157) following a crash disk on the index datafile.
Here what I did:

startup mount
alter database datafile index_datafile_name offline drop alter database open
This makes it possible to open the base (with ' alter... ' the logical link with the datafile removes in the control file). It is then necessary to remove the tablespace indexes(*) (drop tablespace index_tablespace_name including contents cascade constraints)
Then, I can recreate the index tablespace and indexes.

(*) Note: Before removing index tablespace, it is necessary

               to desactivate primary keys (referenced in this tablespace)
                --> if do not, ORA-02429
               (alter  table all_table_names disable primary key cascade)

Regards,
               Thierry de Haro

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 30 1998 - 04:27:18 CDT