Error 600 encountered while recovering transaction (10, 0)

查詢發現有一個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中加上----------

--在初始化引數里加

然後重啟DB。

drop tablespace UNDOTBS1  including contents 。

錯誤消除了。