Oracle8i回滚段表空间的坏块

核心提示： SQL>startup restrict (以受限模式启动数据库，为了防止其他用户登陆进来做相关操作，Oracle8i回滚段表空间的坏块(2)，这时候只允许管理员登陆）查找回滚段对应的表空间:SQL> select tablespace_name,status from dba

SQL>startup restrict (以受限模式启动数据库，为了防止其他用户登陆进来做相关操作，这时候只允许管理员登陆）

查找回滚段对应的表空间:

SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME??????????????? STATUS
------------------------------ ---------
SYSTEM???????????????????????? ONLINE
TOOLS????????????????????????? ONLINE
RBS??????????????????????????? ONLINE
TEMP?????????????????????????? ONLINE
USERS????????????????????????? ONLINE
INDX?????????????????????????? ONLINE
DRSYS????????????????????????? ONLINE
WACOS????????????????????????? ONLINE
NMS??????????????????????????? ONLINE
TEST?????????????????????????? ONLINE
FS???????????????????????????? ONLINE
PERFSTAT?????????????????????? ONLINE

12rows selected.

回滚段表空间为RBS.

查看当前回滚段表空间里是否有活动的事物:

SQL> SELECT s.username,t.xidusn,t.ubafil,
t.ubablk,t.used_ublk? FROM
v$session s,v$transaction t WHERE s.saddr=t.ses_addr;
no rows selected.

发现没有活动事物后，drop回滚段。

接下来查找回滚段存储参数信息:

SQL> col tablespace_name format a10
SQL> col SEGMENT_NAME format a12
SQL> set line 120
SQL> select SEGMENT_NAME,OWNER,TABLESPACE_NAME,
initial_extent,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS,
PCT_INCREASE from dba_rollback_segs;