Corrupt Tablespace Datafile

From: <bmennell_at_bftl.com>
Date: Sat, 18 Jul 1998 14:04:37 GMT
Message-ID: <6oqa1l$ja7$1@nnrp1.dejanews.com>

I created a new tablespace using the Storage Manager. There was no error reported but it failed to create a proper data file due to there being insufficient space on disk. In fact it created a zero-length data file.

After the next server shutdown, the database would not open, and gave these error messages:

ORA-01157: cannot identify data file 8 - file not found
ORA-01110: data file 8: 'D:\ORANT\DATABASE\OEM1ORCL.ORA'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: invalid file header

We have tried to use svrmgr to take the tablespce off-line using 'alter tablespace <name> offline'
but we get the message 'ORA-1109 database not open'.

So we have a catch-22 situation: the database will not open because a tablespace datafile it expects is not there, and we cannot disable the tablespace unless the database is open.

There must surely be a way of altering the Oracle configuration settings (without the database being open) in such a way as to disable a bad tablespace data file.

Any ideas ?

We are using Oracle 8.0.3 on Windows NT.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Jul 18 1998 - 09:04:37 CDT