断电造成ORA-00600: internal error code, arguments: [4194]

问题描述：生产环境中机房突然断电造成ORACLE数据库启动过程中报ORA-00600: internal error code, arguments: [4194]
处理过程：
1、startup启动数据库
SQL> startup
ORACLE instance started.

Total System Global Area 583008256 bytes
Fixed Size 2022504 bytes
Variable Size 184550296 bytes
Database Buffers 394264576 bytes
Redo Buffers 2170880 bytes
Database mounted.
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [22], [39], [], [], [], [],[]

2、查看数据库具体日志
alertlog 如下：
Mon Dec 2 11:55:57 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 36 Reading mem 0
Mem# 0 errs 0: /oracle/oradata/lixora/redo03.log
Block recovery completed at rba 36.473.16, scn 0.7418494
Mon Dec 2 11:55:58 2013
Errors in file /oracle/admin/lixora/bdump/lixora_m000_3764.trc:
ORA-00600: internal error code, arguments: [4193], [1442], [1446], [], [], [], [], []
Doing block recovery for file 2 block 114
Block recovery from logseq 36, block 70 to scn 7418420
Mon Dec 2 11:56:01 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 36 Reading mem 0
Mem# 0 errs 0: /oracle/oradata/lixora/redo03.log
Block recovery completed at rba 36.72.16, scn 0.7418421
Doing block recovery for file 2 block 121
Block recovery from logseq 36, block 70 to scn 7418496
----发现数据文件id：2的文件有问题，默认情况下，id为2的数据文件为undo 数据文件。在mount状态下确认id为2的 数据库文件是什么？
select * from dba_data_files where file_id=2；

FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
/oracle/oradata/lixora/undotbs01.dbf
2 UNDOTBS1 1038090240 126720 AVAILABLE
2 YES 3.4360E+10 4194302 640 1038024704 126712
ONLINE

----------开始修复数据库：------------
----设置undo表空间的管理方式为：手工，缺省undotbs 为空，实际上市使用了 system 回滚段。
SQL> alter system set undo_management = manual scope=spfile;

System altered.

SQL> alter system set undo_tablespace='' scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 583008256 bytes
Fixed Size 2022504 bytes
Variable Size 184550296 bytes
Database Buffers 394264576 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
SQL>
SQL>
----创建新的undo表空间：
SQL> create undo tablespace undotbs2
2 datafile '/oracle/oradata/lixora/undotbs2.dbf' size 100M;

Tablespace created.

----设置undo管理方式为 ’自动‘：
SQL> alter system set undo_management =auto scope=spfile;

System altered.

----设置undotbs 为新建的undotbs2：
SQL> alter system set undo_tablespace = undotbs2 scope=spfile;

System altered.

----删除原来损坏的undo表空间 ：

SQL> drop tablespace undotbs02 including contents and datafiles;

Tablespace dropped.

SQL> startup force;
ORACLE instance started.

Total System Global Area 583008256 bytes
Fixed Size 2022504 bytes
Variable Size 234881944 bytes
Database Buffers 343932928 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29108856/viewspace-1728493/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29108856/viewspace-1728493/