oracle回滚段空间满了,【案例】Oracle undo回滚表空间在回滚段中无事务时损坏恢复详细步骤...

天萃荷净

运维DBA反映数据库undo回滚表空间损坏，经检查回滚表空间中回滚段并无当前事务，记录一下处理步骤与思路

startup nomount;

create pfile=’/tmp/pfile’ from spfile;

修改pfile

*.undo_management=’MANUAL’

*.undo_tablespace=’SYSTEM’

#*.undo_tablespace=’UNDOTBS02′

#*.undo_management=’AUTO’

startup pfile=’/tmp/pfile’ mount;

alter database datafile 2 offline drop;

alter database open;

drop tablespace undotbs1 including contents;

select segment_name,status from dba_rollback_segs;

drop rollback segment “_SYSSMUx”$;

drop tablespace undotbs1 including contents;

CREATE UNDO TABLESPACE UNDOTBS02

DATAFILE ‘/opt/oracle/oradata/xifenfei/UNDOTBS02.dbf’ SIZE 50M

shutdown immediate;

修改pfile

#*.undo_management=’MANUAL’

#*.undo_tablespace=’SYSTEM’

*.undo_tablespace=’UNDOTBS02′

*.undo_management=’AUTO’

startup pfile=’/tmp/pfile’;

create spfile from pfile=’/tmp/pfile’;

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle undo回滚表空间在回滚段中无事务时损坏恢复详细步骤