Oracle8i回滚段表空间的坏块

豆豆网技术应用频道 2007年07月31日社区交流

关键字： 0racle Oracle 10g 安装oracle 安装Oracle9i 回滚段 Oracle进程

内容摘要：Oracle8i回滚段表空间的坏块的解决方法

　　除了system,都是offline状态。

　　继续做脚本让除system外的回滚段online：

SQL> select 'alter rollback segment
'||segment_name||' online;'? from dba_rollback_segs;
alter rollback segment RBS0 online;
alter rollback segment RBS1 online;
alter rollback segment RBS2 online;
alter rollback segment RBS3 online;
alter rollback segment RBS4 online;
alter rollback segment RBS5 online;
alter rollback segment RBS6 online;
alter rollback segment RBS7 online;
alter rollback segment RBS8 online;
alter rollback segment RBS9 online;
alter rollback segment RBS10 online;
alter rollback segment RBS11 online;
alter rollback segment RBS12 online;
alter rollback segment RBS13 online;
alter rollback segment RBS14 online;
alter rollback segment RBS15 online;
alter rollback segment RBS16 online;
alter rollback segment RBS17 online;
alter rollback segment RBS18 online;
alter rollback segment RBS19 online;
alter rollback segment RBS20 online;
alter rollback segment RBS21 online;
alter rollback segment RBS22 online;
alter rollback segment RBS23 online;
alter rollback segment RBS24 online;
alter rollback segment RBS26 online;
alter rollback segment RBS27 online;
alter rollback segment RBS28 online;
alter rollback segment RBS25 online;
alter rollback segment APPRBS online;

　　执行以上脚本后，删除原来的undo表空间RBS：

SQL>drop tablespace rbs including contents;
Tablespace dropped.

　　操作完成。

上一页 1 2 3 4 5 6 78

责编：豆豆技术应用

点击搜索更多"回滚段"相关信息

点击发表评论

正在加载评论...