Oracle8i回滚段表空间的坏块

核心提示： 接下来drop刚刚建立的rbs01表空间,重新建立rbs01表空间:SQL> create tablespace rbs01 datafile '/opt/oracle/db02/oradata/ORCL/rbs01.dbf' size 1024M?autoexten

接下来drop刚刚建立的rbs01表空间,重新建立rbs01表空间:

SQL> create tablespace rbs01 datafile '/opt/oracle/db02/
oradata/ORCL/rbs01.dbf' size 1024M
?autoextend on next 1M maxsize unlimited;
Tablespace created.
SQL> select EXTENT_MANAGEMENT from dba_tablespaces where
tablespace_name='RBS01';
EXTENT_MAN
----------
DICTIONARY

这回表空间不是LMT的，是DMT的。

下面是正式的任务：

SQL> set feedback off
SQL> set pages 0
SQL> select 'alter rollback segment '||segment_name||'
offline;'? from dba_rollback_segs;

做一个脚本把除system回滚段以外的回滚段都offline掉，省的一个一个敲，脚本结果如下:

alter rollback segment RBS0 offline;
alter rollback segment RBS1 offline;
alter rollback segment RBS2 offline;
alter rollback segment RBS3 offline;
alter rollback segment RBS4 offline;
alter rollback segment RBS5 offline;
alter rollback segment RBS6 offline;
alter rollback segment RBS7 offline;
alter rollback segment RBS8 offline;
alter rollback segment RBS9 offline;
alter rollback segment RBS10 offline;
alter rollback segment RBS11 offline;
alter rollback segment RBS12 offline;
alter rollback segment RBS13 offline;
alter rollback segment RBS14 offline;
alter rollback segment RBS15 offline;
alter rollback segment RBS16 offline;
alter rollback segment RBS17 offline;
alter rollback segment RBS18 offline;
alter rollback segment RBS19 offline;
alter rollback segment RBS20 offline;
alter rollback segment RBS21 offline;
alter rollback segment RBS22 offline;
alter rollback segment RBS23 offline;
alter rollback segment RBS24 offline;
alter rollback segment RBS25 offline;
alter rollback segment RBS26 offline;
alter rollback segment RBS27 offline;
alter rollback segment RBS28 offline;
alter rollback segment APPRBS offline;