Re: Help!!

Hi,

        Sorry for asking, but did you notice the 'drop' behind the 'alter ..ofline' ,
in the other replies?

Mario Broodbakker  

mwang <mwang_at_colorbank.com> wrote in article <3252D92C.167E_at_colorbank.com>...
> varad acharya wrote:
> >
> > mwang wrote:
> > >
> > > Because I deleted a datafile from directory, I am not able to restart
> > > Oracle. After I created a file, as suggested, with the same name
 and
> > > size in the same directory, the error messages are:
> > >
> > > SQLDBA> connect internal;
> > > Connected.
> > > SQLDBA> start mount;
> > Is /usr/people/mwang/data/abc.dbf the name of the new file you added?
> > If so try the folowing.
> >
> > startup mount
> > alter database datafile '/usr/people/mwang/data/abc.dbf' offline
> > alter database open
> >
> > The oracle instance should startup albeit the above datafile will not
> > be available.Data that was contained in the original file of this name
> > is lost.
> >
> > --
> >
> > Regards,
> >
> > Varad Acharya
>
>
>
> Sorry. I forgot to show you the result.
>
>
> /3 Oracle/usr/people/oracle/sqldba lmode=y
>
> SQL*DBA: Release 7.1.6.2.0 - Production on Wed Oct 2 13:57:57 1996
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> Oracle7 Server Release 7.1.6.2.0 - Production Release
> PL/SQL Release 2.1.6.2.0 - Production
>
> SQLDBA> connect internal;
> Connected.
> SQLDBA> startup mount;
> ORACLE instance started.
> Database mounted.
> SQLDBA> alter database datafile '/usr/people/mwang/data.dbf' offline;
> ORA-01516: nonexistent log/data file '/usr/people/mwang/data.dbf'
> SQLDBA> alter database datafile '/usr/people/mwang/data/abc.dbf'
> offline;
> ORA-01145: offline immediate disallowed unless media recovery enabled
> SQLDBA>
>
>
>
> What's the next should be?
>
> Min Wang
>
Received on Sat Oct 12 1996 - 00:00:00 CEST