Ora_4194错误处理方法(UNDO空间).docxVIP

Ora-00600?4194错误的解决方法数据库重新启动后，数据库可以临时打开，但一旦其他用户登录，就出现物理内存不足，当使用院内网页登录时，提示数据库某个数据文件需要回复。经查看，发现数据库已经宕机，查看alter_sid.log日志，发现出现了Ora-00600 4194错误，具体的日志如下：Tue Apr 17 21:08:55 2012Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3000.trc:ORA-00600: internal error code, arguments: [4194], [51], [53], [], [], [], [], []Tue Apr 17 21:08:57 2012db_recovery_file_dest_size of 2048 MB is 0.00% used. This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Tue Apr 17 21:08:57 2012Completed: alter database openTue Apr 17 21:08:57 2012Doing block recovery for file 2 block 847Block recovery from logseq 1459, block 93 to scn 337698703Tue Apr 17 21:08:58 2012Recovery of Online Redo Log: Thread 1 Group 3 Seq 1459 Reading mem 0Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOGBlock recovery stopped at EOT rba 1459.104.16Block recovery completed at rba 1459.104.16, scn 0.337698702Doing block recovery for file 2 block 153Block recovery from logseq 1459, block 93 to scn 337698687Tue Apr 17 21:08:58 2012Recovery of Online Redo Log: Thread 1 Group 3 Seq 1459 Reading mem 0Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOGBlock recovery completed at rba 1459.96.16, scn 0.337698690Tue Apr 17 21:08:58 2012Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3000.trc:ORA-01595: error freeing extent (3) of rollback segment (10))ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [4194], [51], [53], [], [], [], [], []Tue Apr 17 21:08:59 2012Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2892.trc:ORA-00600: 内部错误代码, 参数: [4194], [51], [53], [], [], [], [], []Tue Apr 17 21:09:00 2012DEBUG: Replaying xcb 0x6d9fc218, pmd 0x1e8bbadc for failed op 8Doing block recovery for file 2 block 847Block recovery from logseq 145