Re: bad undo, can I just rebuild it?
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: Oracle L <oracle-l@xxxxxxxxxxxxx>, po04541@xxxxxxxxx
- Date: Wed, 12 May 2010 13:31:22 -0700 (PDT)
I'm actually not seeing this say anywhere that you have a bad undo tablespace,
but I would check your spfile/pfile to see what it thinks you are using for
undo- manual or auto?
I'd check this first and find out what this returns first, then the answer, if
it is truly a problem, is to create a new one, switch your undo_tablespace to
the new one and ensure that all undo extents are truly expired- or you will
have some really nasty errors to go along with the ones you already have...
Kellyn Pedersen
Sr. Database Administrator
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.blogspot.com
"Go away before I replace you with a very small and efficient shell script..."
--- On Wed, 5/12/10, patrick obrien <po04541@xxxxxxxxx> wrote:
From: patrick obrien <po04541@xxxxxxxxx>
Subject: bad undo, can I just rebuild it?
To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
Date: Wednesday, May 12, 2010, 1:43 PM
Oracle experts,
oracle 10gR2, the alert log says the undo tablepace is bad,
ORA-00604: error occurred at recursive SQL level 1
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
Can I just drop the undo and recreate it?
thank you,
Patrick.
Other related posts:
