ORA-00600: [2662]、 [4097]

P720:/u01/app_new/product/11.2/dbs$sqlplus / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 3.7413E+10 bytes
Fixed Size                  2229304 bytes
Variable Size            3.3152E+10 bytes
Database Buffers         4160749568 bytes
Redo Buffers               98418688 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [4097], [71], [24], [53830], [], [],
[], [], [], [], [], []
Process ID: 21299408
Session ID: 937 Serial number: 3


在Oracle进行延迟块清除时,会去查询回滚段头,以确认事务状态,然而,由于一些损坏或强制性恢复手段的采取,获得的回滚段信息来自与未来,超前于当前数据库状态.这样就出现了4097号错误.


 
DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
Error at line 2
ORA-01548: 已找到活动回退段 '_SYSSMU3_3253239717$', 终止删除表空间
 
处理方法：
*._offline_rollback_segments=(_SYSSMU3_3253239717$,_SYSSMU4_1787702501$,_SYSSMU134_3204151252$,_SYSSMU136_3776625891$)


DROP ROLLBACK SEGMENT "_SYSSMU3_3253239717$";


select segment_name, owner, tablespace_name, status from dba_rollback_segs where status != 'OFFLINE';
select segment_name from dba_rollback_segs where status != 'OFFLINE';

操作记录1：

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area 3.7413E+10 bytes
Fixed Size                  2229304 bytes
Variable Size            3.3152E+10 bytes
Database Buffers         4160749568 bytes
Redo Buffers               98418688 bytes
Database mounted.
Database opened.
SQL> select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';


TABLESPACE_NAME                STATUS           SEGMENT_NAME
------------------------------ ---------------- ------------------------------
SYSTEM                         ONLINE           SYSTEM
UNDOTBS1                       PARTLY AVAILABLE _SYSSMU116_3584053428$
UNDOTBS1                       PARTLY AVAILABLE _SYSSMU85_1523276694$
UNDOTBS1                       PARTLY AVAILABLE _SYSSMU46_1758101107$
UNDOTBS1                       PARTLY AVAILABLE _SYSSMU44_523600858$
UNDOTBS1                       PARTLY AVAILABLE _SYSSMU7_2714763860$


6 rows selected.

操作记录2：

SQL> create undo tablespace UNDOTBS2 datafile size 1024M;
create undo tablespace UNDOTBS2 datafile size 1024M
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [3165734096], [0],
[3165743389], [4336694], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [3165734095], [0],
[3165743389], [4336694], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [3165734094], [0],
[3165743389], [4336694], [], [], [], [], [], []
Process ID: 20381736
Session ID: 937 Serial number: 3




SQL> 
SQL> select count(*) from smon_scn_time;
ERROR:
ORA-03114: not connected to ORACLE




SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
P720:/u01/app_new/product/11.2/dbs$r
sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Sun Jun 2 23:55:28 2013


Copyright (c) 1982, 2011, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options


SQL> select count(*) from smon_scn_time;


  COUNT(*)
----------
      1885


SQL> truncate table smon_scn_time;
truncate table smon_scn_time
               *
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [3165734756], [0],
[3165743389], [4336694], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [3165734755], [0],
[3165743389], [4336694], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [3165734754], [0],
[3165743389], [4336694], [], [], [], [], [], []
Process ID: 19529874
Session ID: 937 Serial number: 7




SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
P720:/u01/app_new/product/11.2/dbs$r
sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Sun Jun 2 23:55:57 2013


Copyright (c) 1982, 2011, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options


SQL> delete from smon_scn_time ;


1885 rows deleted.


SQL> commit;


Commit complete.


SQL> startup force;
ORACLE instance started.


Total System Global Area 3.7413E+10 bytes
Fixed Size                  2229304 bytes
Variable Size            3.3152E+10 bytes
Database Buffers         4160749568 bytes
Redo Buffers               98418688 bytes
Database mounted.
Database opened.
SQL> create undo tablespace UNDOTBS2 datafile size 1024M;
Tablespace created.

SQL>

首先备份并清理损坏的在线重做日志文件，分别在不同阶段加入以下参数，
*.undo_management='MANUAL'，*._allow_error_simulation=true，*._allow_resetlogs_corruption=true相关参数来强行屏蔽相关报错
使用参数alter session set events '10015 trace name adjust_scn level 2';将SCN向前推进2亿,强制打开数据库