In article <385fbc3f.460376_at_news1.a2000.nl>,
jantah_at_big.hand.com (Jantah) wrote:
> Had a bit of trouble on one of our databases the other day. We decided
> it would be best torestore a backup of the database. No problem,
> untill we discovered that the backup script skips one disk.
> Fortunately, this disk only holds a datafile for a temporary
> tablespace (phew...).
>
> Anyway, I am stuck with a database with one datafile out of sync with
> the control files. So this is what I did:
>
> - Mount the database.
> - Use alter database to take the datafile offline.
> - Open the database.
> - Drop the temporary tablespace.
> - Re-create the temporary tablespace, re-using the old files.
>
> All is fine now, but I wonder if had also been possible to just drop
> and re-create the datafile, instead of the entire tablespace.
>
> (Running Oracle 7.3.3 on Solaris)
>
> Thanks in advance
> --
> Jan
> jantah_at_big.hand.com
> (replace big.hand with bigfoot to email Jan)
>
I belive you followed the correct procedure. If you drop a datafile
from the database the tablespace containing the files goes/stays
offline and requires that you recover it. Since the reason you droped
the file to begin with is because you do not have a backup you would
have to drop and recreate the tablespace anyway you approached it.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Dec 22 1999 - 09:36:38 CST
