Home » RDBMS Server » Performance Tuning » Block Corruption (Oracle 9204, XP)
Block Corruption [message #417121] Thu, 06 August 2009 04:11 Go to next message
Messages: 56
Registered: September 2007
Location: PUNE
Hi Experts,

We have been facing an Undo Tablespace data corruption issue...
We have carried the following steps.
1) Shutdown immediate
2) Startup restrict
3) Create a new undo tablepace (undotbs2)
4) Make it default
5) Make the corrupted undo tablespace offline (undotbs1)
6) Checked the parameter undo_tablespace, to verify if it is pointing to the new undo tablespace (undotbs2).

When i do an export, i still get the error which says that the datafile in old undo tablespace (undotbs1) is corrupted..
Is it possible that some transactions are still using the old undo tablespace (undotbs1)

Please help me out in this

Re: Block Corruption [message #417231 is a reply to message #417121] Thu, 06 August 2009 11:23 Go to previous message
Messages: 24958
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Previous Topic: Temp Size
Next Topic: Need help to tune the query
Goto Forum:

Current Time: Sun Oct 23 03:37:39 CDT 2016

Total time taken to generate the page: 0.08108 seconds