Re: Undo tablespace offline and ORA-00376

Hi Sami,

   I was hitting a very similar issue on 9.2.0.4 on linux (non RAC). I posted a similar problem on this list and I got some very interesting answers. IIRC it seems that the only solution is to drop the old undo tablespace(s) (after a clear shutdown and startup in order to be sure that none needs undo info from the old tablespace). Hope it helps,

    Giovanni

On 3/16/06, Sami Seerangan <dba.orcl_at_gmail.com> wrote:
> 2 Node RAC,9.2.0.6, Sun OS 2.8
>
> We created new undo tablespaces (UNDO3, UNDO4) for each node1 and
> node2 respectively and changed default undo tablespace to UNDO3 and
> UNDO4. Then we put old UNDO tablespaces offline.
>
> After 2 days we are trying to create a new index and it gives the
> following error.
>
> Any idea?
>
> SQL> CREATE UNIQUE INDEX ABC_KEY_IDX01 ON ABC_STAGE (SESSN_KEY,
> PART_KEY,SUB_PART_KEY) TABLESPACE STAGE_INDEX LOCAL NOPARALLEL;
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00376: file 2 cannot be read at this time
> ORA-01110: data file 2: '/u01/oradata/pdw/undotbs01.dbf'
>
>
> Luckily the tablespace is still offline and I can bring it online. But
> I just wanted to know teh reason behind this?
>
>
> Thanks
> Sami
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
--------------------------------------------------------------------
Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/
Now version 0.9
--
http://www.freelists.org/webpage/oracle-l