ORA-00600 arguments: [4194]

1.alert日志中如下报错

从报错信息可以得到的信息是因为数据库重做记录和回滚记录不匹配导致的--之前这个数据库修改过参数_allow_resetlogs_corruption跳过一致性检查导致的

Block recovery completed at rba 6.84.16, scn 1.6528460
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pmon_16931.trc (incident=109268):
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_109268/orcl_pmon_16931_i109268.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pmon_16931.trc:
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 16931): terminating the instance due to error 472
System state dump requested by (instance=1, osid=16931 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_16941_20210922173942.trc
Dumping diagnostic data in directory=[cdmp_20210922173942], requested by (instance=1, osid=16931 (PMON)), summary=[abnormal instance termination].

2.处理思路

重建undo表空间，但是现在已经无法将数据库open，现需要执行undo表空间为SYSETM、管理方式为手动管理MANAUL

3.处理过程

（1）修改参数

SQL> alter system set undo_tablespace='SYSTEM' scope=spfile;
SQL> alter system set undo_management='MANUAL' SCOPE=SPFILE;

（2）重启数据库

SQL> startup
Total System Global Area 417546240 bytes
Fixed Size 2253824 bytes
Variable Size 285215744 bytes
Database Buffers 125829120 bytes
Redo Buffers 4247552 bytes
Database mounted.
Database opened.

（3）重建undo表空间

SQL> drop tablespace UNDOTBS1 including contents and datafiles;
SQL> create undo tablespace UNDOTBS1 datafile '/oradata/orcl/undotbs01.dbf' size 50M;

（4）重新修改参数

SQL> alter system set undo_tablespace='UNDOTBS1' scope=spfile;
SQL> alter system set undo_management='AUTO' SCOPE=SPFILE;

（5）重启数据