Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP ! ! ! temp tablespace

Re: HELP ! ! ! temp tablespace

From: mrbaker001 <noreply_at_nowhere.com>
Date: Thu, 22 Feb 2001 02:00:21 -0000
Message-ID: <pm_k6.4475$5U3.20936@NewsReader>

I'm sure there are people out here with more up to date knowledge than mine, but I think the problem lies in that it is still looking for the original file. When you rename or drop a datafile you have to do this both from the database and then the operating system separately - in this order (or at least in Oracle 7.x.x you did). It wouldn't let you shutdown normal or immediate because it wanted to write to the datafile you'd moved before closing - each file records an internal counter, the SCN (system change number) used to keep them in step. By shutting down "abort" it skipped that but recorded that it needed recovery as a result. Presumably, on startup, it wasn't available to recover and you had to take it offline before opening? For now the proper fix eludes me, but as this is a temp tablespace you may be able to create a new temp tablespace to be going on with and at a convenient time perform a full database export then trash the old database, create afresh and perform a full import.

But it'd be worth waiting 24 hours for a response from someone with more recent DBA experience!

Regards
Mark

"ahmed kashif" <Ahmed_at_U.Arizona.Edu> wrote in message news:971ll1$jvv$1_at_news.ccit.arizona.edu...
> my temp (temporary) tablespace grew to ~14g (dont know why it was set to
> unlimited?) - ended up taking all the disk space. I moved it to another
 disk
> and brought it online, but then it wouldn't let me shutdown the database
> with the exception of shutdown abort. i tried to drop it with drop
> tablespace command, but it always seemed like it hung the database. i even
> let it go for hours - no luck. then i created a new tablespace 'temp2',
 and
> made that tablespace the temporary tablespace for all the users. then i
> shutdown (abort) the database and removed that sucker from the filesystem.
> brought the database up with no problem. then i tried again to drop it
> throught drop tablespace, but it still does the same - hang the database
 on
> me.
>
> i still can see that tablespace in dba_tablespaces, and i still can't
> shutdown normal or immediate. please HELP!!!
>
> --
>
>
> Thanks,
>
> ahmed
>
>
Received on Wed Feb 21 2001 - 20:00:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US