Undo tablespace offline and ORA-00376 2006-03-17 - By Giovanni Cuccu
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@(protected)> 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 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1
> ORA-00376 (See ORA-00376.ora-code.com): file 2 cannot be read at this time
> ORA-01110 (See ORA-01110.ora-code.com): 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
|
|
