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,