Undo tbs corruption ora-00376,ora-01110
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Undo tbs corruption ora-00376,ora-01110

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    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,

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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
  •  



Click Here to Expand Forum to Full Width