Re: can not startup oracle database

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Tue, 29 Sep 1998 19:46:49 -0700
Message-ID: <6us5pq$s0j@sjx-ixn4.ix.netcom.com>

you need to recover your database. First, are you running archive log or noarchive log. For no archive log mode, u need to drop that tablespace:

startup mount
alter database datafile <..> offline drop alter database open
drop tablespace <..>

if you are running in archive log mode, then you have to recover that datafile with the backup you have and apply all the archive log:

startup mount
alter database datafile <..> offline
alter database open

alter tablespace <..> offline
recover datafile <..>
alter tablespace <..> online

Winnie

charnsil wrote in message <6un85l$99k$1_at_news.ksc.co.th>...
>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
>
>
Received on Tue Sep 29 1998 - 21:46:49 CDT