Re: Help!!

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 Wed Oct 02 1996 - 00:00:00 CEST