| Block Corruption [message #417121] |
Thu, 06 August 2009 04:11  |
saharookiedba
Messages: 56
Registered: September 2007
Location: PUNE
|
Member |
|
|
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
