sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

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

时间:2016-06-29 15:13   来源:Oracle研究中心   作者:惜分飞   点击:

天萃荷净 运维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回滚表空间在回滚段中无事务时损坏恢复详细步骤

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/624.html

Oracle研究中心

关键词:

Oracle undo损坏恢复

undo回滚段中无事务时损坏恢复

重建undo表空间详细案例

删除undo中的回滚段