Re: Corrupt Tablespace Datafile

Try mounting the database without opening it. You should be able to drop the tablespace then open the database.

bmennell_at_bftl.com wrote:

> 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 - 20:45:53 CDT