Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Unable to Open Database: Remove Datafile

Unable to Open Database: Remove Datafile

From: Sumant Vashisth <svashisth_at_hotmail.com>
Date: Wed, 7 Feb 2001 13:49:44 -0800
Message-ID: <95sftp$842@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>
######################################################################
Received on Wed Feb 07 2001 - 15:49:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US