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
