查询发现有一个rollback segment 的状态是 NEEDS RECOVERY
SELECT segment_name,tablespace_name,owner,status
FROM dba_rollback_segs;
_SYSSMU10$ UNDOTBS1 NEEDS RECOVERY
create undo tablespace undo3 datafile '/u01/oracle/oradata/JH/undo3.dbf' size 100M;
alter system set undo_tablespace=undo3;
create pfile='/tmp/pfile' from spfile;
-------/tmp/pfile中加上----------
--在初始化参数里加
_CORRUPTED_ROLLBACK_SEGMENTS =(_SYSSMU10$)
---------------------------------
然后重启DB。
drop tablespace UNDOTBS1 including contents 。
错误消除了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8183550/viewspace-752315/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8183550/viewspace-752315/