Re: bad undo, can I just rebuild it?

I'd re-check your assumptions. This error message does not indicate a bad (read 
corrupted) tablespace. It would rather indicate to me that you either don't 
have an undo tablespace or that the undo_tablespace parameter is not set 
correctly. I am assuming these are the only error messages in your alert log.


 Robert G. Freeman
Master Principal Consultant, Oracle Corporation
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide 
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com




________________________________
From: patrick obrien <po04541@xxxxxxxxx>
To: Oracle L <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, May 12, 2010 1:43:15 PM
Subject: bad undo, can I just rebuild it?


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: