Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

switch undo tablespace

924375Feb 6 2014 — edited Feb 6 2014

in an 11.2.0.3 oracle database, which set undo_management = AUTO, I've done:

  • create a new undo tablespace
  • set undo_tablespace to point new undo tablespace
  • wait for all segments in old undo tablespace seem offline in DBA_ROLLBACK_SEGS
  • turn offline old undo tablespace
  • and these errors came up:

          ORA-00376: file 111 cannot be read at this time

          ORA-01110: data file 111: '+FRA/orcl/undotbs01.dbf'

I've read it's ok to drop undo tablespace after all segments in undo tablespace turn offline. Why it tried to read old undo tablespace?

Thanks...

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2014
Added on Feb 6 2014
7 comments
4,251 views