-
Undo tbs corruption ora-00376,ora-01110
Hi all,
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
Regards
Boris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|