Re: Unable to Open Database: Remove Datafile

"Sumant Vashisth" <svashisth_at_hotmail.com> escribió en el mensaje news:95sftp$842_at_scel.sequent.com...
> I receive the following error message when I try to open the database. I
 had
> just created the
> database and added the following file to the tablespace had not yet backed
> it up.
> There should not be any data stored in the file. Is there a workaround to
> this problem
> (deleting the datafile etc.). There is another datafile in the ts which
 has
> data stored in it
> and so it would not be possible for me to drop the tablespace.
> Thanks in anticipation
> ######################################################################
> SVRMGR> alter database open;
> alter database open
> *
> ORA-01122: database file 31 failed verification check
> ORA-01110: data file 31: 'G:\ORACLE\STS\SAPDATA6\BTABD_5\BTABD.DATA5'
> ORA-01251: Unknown File Header Version read for file number 31
> SVRMGR>
> ######################################################################
>
>

I'm not sure, but you can try to recreate control files declaring all datafiles except
the lost datafile, maybe it works...... Anyway I would try on another machine with a
copy of original database.

Dani Paz,, Received on Wed Feb 07 2001 - 16:20:11 CST