记ORA-00600: [4194]故障处理

故障现象

生产环境是 windowns Oracle11g 11203 版本的单机数据库。 在启动数据库实例时遇到“ORA-00600: internal error code, arguments: [4194] [][][].....”ora-1595错误，实例在启动后，会自然Down掉。具体情况如下所示：

4194：表示也是undo和redo不一致（Arg [a] Maximum Undo record number in Undo block，Arg [b] Undo record number from Redo block）

故障过程：

查看官方文档Step by step to resolve ORA-600 4194 4193 4197 on database crash (文档 ID 1428786.1)有提供详细的介绍。建议处理前，建议先查阅次文档，错误出现的主要场景： This issue generally occurs when there is a power outage or hardware failure that initially crashes the database. On startup, the database does the normal roll forward (redo) and then rollback (undo), this is where the error is generated on the rollback. 具体操作如下所示

1、 通过spfile创建生成pfile

SQL> create pfile from spfile;

File created.

2、修改pfile中undo_management为MANUAL

initorcl.ora

*.
undo_management
=
'MANUAL'
 

*.
undo_tablespace
=
'UNDOTBS2'

sqlplus 
/
 
as
 sysdba

SQL
>
 startup  restrict  pfile
=
'initorcl.ora'

SQL
>
 create undo tablespace UNDOTBS2 datafile  
''
E
:
\APP\ADMINSTRATOR\ORDATA\ORCL\UNDOTBS201
.
DBF
'

SIZE 5G;

Tablespace created.

SQL
>
 drop tablespace UNDOTBS including contents 
and
 datafiles
;

Tablespace
 dropped
.

SQL
>
 create spfile form pfile
;

SQL
>
 shutdown immediate
;

Database
 closed
.


Database
 dismounted
.


ORACLE instance shut down
.

SQL
>
 startup
;

ORACLE instance started
.

Total
 
System
 
Global
 
Area
 
1.6777E+10
 bytes

Fixed
 
Size
                  
2113368
 bytes

Variable
 
Size
            
9982443688
 bytes

Database
 
Buffers
         
6777995264
 bytes

Redo
 
Buffers
               
14663680
 bytes

Database
 mounted
.

Database
 opened
.