---- 将旧回滚段及回滚表空间删除。
svrmgrl >alter rollback_segment r01 offline 0drop.
svrmgrl >alter rollback_segment r02 offline 0drop.
svrmgrl >alter rollback_segment r03 offline 0drop.
svrmgrl >alter rollback_segment r04 offline 0drop.
svrmgrl >0drop tablespace rbs including contents.
---- 重建新的回滚表空间及回滚段。
svrmgrl >connect internal
svrmgrl >create rollback segment ro tablespace system.
svrmgrl >alter rollback segment ro online.
svrmgrl >create tablespace rbs datafile
##/##/rbs01.dbf’ size ##k.
svrmgrl >create rollback segment r01 tablespace rbs.
svrmgrl >create rollback segment r02 tablespace rbs.
svrmgrl >create rollback segment r03 tablespace rbs.
svrmgrl >create rollback segment r04 tablespace rbs.
svrmgrl >alter rollback segment r01 online.
svrmgrl >alter rollback segment r02 online.
svrmgrl >alter rollback segment r03 online.
svrmgrl >alter rollback segment r04 online.
svrmgrl >Shutdown abort
$ vi $ORACLE_HOME/dbs/init< sid >.ora
rollback_segments=(r01,r02,r03,r04)
将参数_corrupted_rollback_segment
_allow_resetlogs_corruption=true去掉
svrmgrl >Startup normal |