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

    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
    Recover should be fine.
    RECOVER TABLESPACE (if successful) should solve the problem.
    If not successfull, then you are in deep problems


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