Undo tbs corruption ora-00376,ora-01110
I am getting these errors in my alert log:
ora-00376: file 2 cannot be read at this time
ora-01110: datafile 2: 'f:/undotbs1.dbf'
when i checked dba_rollback_segs i found all the segments needed recovery apart from 2 which were offline. system was online. Can i just recover the particular datafile for the UNDO tbs? or is there more to this?
Urgent help needed
Thanks in advance,
Recover should be fine.
RECOVER TABLESPACE (if successful) should solve the problem.
If not successfull, then you are in deep problems
Click Here to Expand Forum to Full Width