背景:误删除Undo数据文件,新建Undo表空间后指向新的undo表空间,删除旧的undo表空间时报错
SQL> drop tablespace undotbs1 including contents and datafiles;
drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU1_3724004606$' found, terminate
dropping tablespace
step1:查看回滚段的状态 -为needs recovery
Select segment_name, status, tablespace_name
from dba_rollback_segs
where status not in ('ONLINE', 'OFFLINE');
SEGMENT_NAME STATUS TABLESPACE_NAME
_SYSSMU1_3724004606$ NEEDS RECOVERY UNDOTBS1
_SYSSMU2_2996391332$ NEEDS RECOVERY UNDOTBS1
_SYSSMU3_1723003836$ NEEDS RECOVERY UNDOTBS1
_SYSSMU4_1254879796$ NEEDS RECOVERY UNDOTBS1
_SYSSMU5_898567397$ NEEDS RECOVERY UNDOTBS1
_SYSSMU6_1263032392$ NEEDS RECOVE