smon无法回滚一例

查看alert日志发现:
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Errors in file /oracle/diag/rdbms/orcl/orcl/trace/orcl_smon_8476.trc  (incident=54120):



查看orcl_smon_8476.trc 文件:
*** 2014-09-02 11:02:06.443
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (7))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kdBlkCheckError], [3], [224], [38504], [], [], [], [], [], [], [], []

看到7号回滚段无法回滚,查看回滚段:
[oracle@mbank-test1 orcl]$ strings system01.dbf | grep -i SYSSMU7 | sort -u
_SYSSMU7_2070203016$
_SYSSMU7_2070203016$|
_SYSSMU7_2070203016$l
_SYSSMU7_2271882308$

编辑pfile
[oracle@mbank-test1 dbs]$ cat initorcl.ora 
orcl.__db_cache_size=687865856
orcl.__java_pool_size=16777216
orcl.__large_pool_size=83886080
orcl.__oracle_base='/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=553648128
orcl.__sga_target=1056964608
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=251658240
orcl.__streams_pool_size=0
*.audit_file_dest='/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/oracle/oradata/orcl/control01.ctl','/oracle/oradata/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.diagnostic_dest='/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.memory_target=1606418432
*.nls_language='AMERICAN'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
_allow_resetlogs_corruption=TRUE
_offline_rollback_segments="_SYSSMU7_2070203016$";
_offline_rollback_segments="_SYSSMU7_2271882308$";
_corrupted_rollback_segments="_SYSSMU7_2070203016$";
_corrupted_rollback_segments="_SYSSMU7_2271882308$";

从pfile启动:

------这步不需要
 alter system set event='10513 trace name context forever,level 2 : 10512 trace name context forever,level 1: 10511 trace name context forever,level 2: 10510 trace name context forever,level 1' scope=spfile;


启动正常