RE: Fixing temp tablespace

Try
Alter database datafile 'filename' offline drop; If this does not work, try to recreate the control file. -- Mohammed
On Friday, May 17, 1996, Sean Garagan wrote...
> Greetings all,
>
> Being a newbie DBA, I created a small problem on the development
> system at work. I tried to extend the temp tablespace by adding
> another datafile using the alter tablespace command. It worked
> but the file was in the wrong spot. Not thinking, I used rollback
> (please don't laugh) and tried again. This time the file created
> and everything was fine, so I rm'ed the original file.
>
> A little bit after this, I was surprised to see that Oracle itself
> had crashed. When I tried to start the database, it complained
> it could not find the datafile and would shutdown Oracle again.
> I got it to the point where the database is up and running with
> a new datafile in it's place (created with the alter database
> create datafile as command).
>
> However, when I run a large update, it now looks at this file and
> sees it in recover status and refuses to continue. The database is
> not in archive mode nor are there any backups for this file. Is
> there a way to remove all pointers to this file or to get it into
> the database without having to do a recovery (which cannot be done)?
>
> Moral of this story: backup, backup, backup and don't forget to read
> your DBA handbook a little harder :)
>
> The Oracle version is 7.1.4 on a SVR4 Unix box.
>
> Thanks in advance,
> Sean
>
Received on Fri May 17 1996 - 00:00:00 CEST