Re: Can't open file

My best guess would be that the path name was not defined with this file, and as a result, it is looking for in the default directory of Oracle. You can't take it offline, because the file does not exist. Find out where this database thinks he is - what directory is the default, you may have to put this file in a couple of places. My first try would be where the init.ora file is located.

(This is assuming that you are on 7.2 or higher).

start the database nomount
mount the database - alter database mount; now, rename the datafile
alter database rename file 'RBS1AMDB.ORA' to '/fullpathname/RBS1AMDB.ORA';
see if that works.

Since the file is most likely not in the directory that it is looking, just typing in
alter database datafile 'RBS1AMDB.ORA' offline drop will not work. You won't be able to drop the tablespace since you can't open the database.

Hope this helps

-Sheilah Scheurich
DBA
If you want to contact me remove wantnospam from my address :-)

rfm_at_musicandmail.com wrote:

> Hi,
>
> we have the following problem:
>
> >alter database ammain mount exclusive
> >Mon Dec 01 11:31:24 1997
> >SNP0 started
> >LGWR started
> >Mon Dec 01 11:31:24 1997
> >DBWR started
> >Mon Dec 01 11:31:25 1997
> >Successful mount of redo thread 1.
> >Mon Dec 01 11:31:25 1997
> >Completed: alter database ammain mount exclusive
> >Mon Dec 01 11:31:25 1997
> >alter database ammain open
> >SNP1 started
> >Mon Dec 01 11:31:26 1997
> >Errors in file W:\ORANT\RDBMS73\trace\amdbDBWR.TRC:
> >ORA-01157: cannot identify data file 2 - file not found
> >ORA-01110: data file 2: 'RBS1AMDB.ORA'
> >ORA-09202: sfifi: error identifying file
> >OSD-04002: Die Datei kann nicht geöffnet werden. (OS 2)
> >ORA-1157 signalled during: alter database ammain open...
>
> As you can read, we can't open the database.
> On the server we have two instance of oracle.
> The first instance work without any problem.
> But the second...
>
> We have tried the following:
>
> " alter database datafile 'full pathname' offline drop;"
>
> But we receive the following error:
> ORA-01516: not existing databasefile "full pathname".
>
> We have doublechecked that the path and filename is correct.
>
> Need help to solve this problem!
>
> Best Regards
>
> Raymond Michalek
Received on Tue Dec 02 1997 - 00:00:00 CST