Tablespace problems - db can't shutdown

From: Dylan Fairbairn <dylanf_at_aldiscon.ie>
Date: Thu, 29 Oct 1998 19:24:29 +0000
Message-ID: <3638C0EC.165C6D7E@aldiscon.ie>

Hi all,

Any suggestions would be welcomed as this is causing extreme hedaches. Im new to the DB world so feel free to assume ignorance.

prob:- a new tablespace and datafile was created and a new table created in this space.
the table was subsequently dropped
unfortunately the datafile was deleted from the drive without being removed from
the database so now the db gives the following error when a shutdown is requested:

SVRMGR> shutdown immediate

ORA-01116: error in opening database file 6
ORA-01110: data file 6: '/usr1/rob072.ts2'
ORA-07368: sfofi: open error, unable to open database file.

HP-UX Error: 2: No such file or directory

What I need to know is how to get rid of all references to '/usr1/rob072.ts2'

also note:
this may be complicated by the fact that in the view dba_data_files we have
/usr1/rob072.ts2

6 TS3                              10485760       2560 AVAILABLE


/usr1/rob072.ts3


7 TS3                              10485760       2560 AVAILABLE

would this cause an additional conflict?

thanks in advance

Dylan Received on Thu Oct 29 1998 - 13:24:29 CST