我的回滚段怎么在实例启动的时候不自动ONLINE呢？？？？

[lhzongji]

我有20个PUBLIC回滚段，每次实例启动后都处于OFFLINE

WHY？？？？？？？？

[fangbintao]

initsid.ora中有没有进行设置啊，rollback_segments ＝ 该参数你注意检查一下，看看有没有问题

[lhzongji]

SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
SYSTEM SYSTEM SYS
ONLINE

_SYSSMU1$ UNDOTBS1 PUBLIC
ONLINE

_SYSSMU2$ UNDOTBS1 PUBLIC
ONLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
_SYSSMU3$ UNDOTBS1 PUBLIC
ONLINE

_SYSSMU4$ UNDOTBS1 PUBLIC
ONLINE

_SYSSMU5$ UNDOTBS1 PUBLIC
ONLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
_SYSSMU6$ UNDOTBS1 PUBLIC
ONLINE

_SYSSMU7$ UNDOTBS1 PUBLIC
ONLINE

_SYSSMU8$ UNDOTBS1 PUBLIC
ONLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
_SYSSMU9$ UNDOTBS1 PUBLIC
ONLINE

_SYSSMU10$ UNDOTBS1 PUBLIC
ONLINE

RBS01 SYSTEM PUBLIC
OFFLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
RB20 ROLLBACK_GLC PUBLIC
OFFLINE

RB01 ROLLBACK_GLC PUBLIC
OFFLINE

RB02 ROLLBACK_GLC PUBLIC
OFFLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
RB03 ROLLBACK_GLC PUBLIC
OFFLINE

RB04 ROLLBACK_GLC PUBLIC
OFFLINE

RB05 ROLLBACK_GLC PUBLIC
OFFLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
RB06 ROLLBACK_GLC PUBLIC
OFFLINE

RB07 ROLLBACK_GLC PUBLIC
OFFLINE

RB08 ROLLBACK_GLC PUBLIC
OFFLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
RB09 ROLLBACK_GLC PUBLIC
OFFLINE

RB10 ROLLBACK_GLC PUBLIC
OFFLINE

RB11 ROLLBACK_GLC PUBLIC
OFFLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
RB12 ROLLBACK_GLC PUBLIC
OFFLINE

RB13 ROLLBACK_GLC PUBLIC
OFFLINE

RB14 ROLLBACK_GLC PUBLIC
OFFLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
RB15 ROLLBACK_GLC PUBLIC
OFFLINE

RB16 ROLLBACK_GLC PUBLIC
OFFLINE

RB17 ROLLBACK_GLC PUBLIC
OFFLINE


SEGMENT_NAME TABLESPACE_NAME OWNER
------------------------------ ------------------------------ ------
STATUS
----------------
RB18 ROLLBACK_GLC PUBLIC
OFFLINE

RB19 ROLLBACK_GLC PUBLIC
OFFLINE