oracle 出错的行数 异常_【案例】Oracle报错ORA-00313 ORA-00312 ORA-27037 日志异常处理办法...

天萃荷净

运维DBA反映数据库重启后无法启动，报错：ORA-00313 ORA-00312 ORA-27037，分析原因为数据库redo日志损坏导致

一、环境模拟

删除INACTIVE状态redo日志的物理文件，然后进行大批量事务操作

二、出现现象

1、alert.log记录

Tue Aug 23 23:32:02 2011

Errors in file /u01/admin/xienfei/bdump/xff_arc1_8773.trc:

ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1]

ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/u01/oradata/xienfei/redo03.log]

ORA-27037: Message 27037 not found; No message file for product=RDBMS, facility=ORA

Linux Error: 2: No such file or directory

Additional information: 3

2、xff_arc1_8773.trc文件中内容

*** 2011-07-18 18:35:32.071 59526 kcrr.c

kcrrfail: dest:2 err:12541 force:0 blast:1

ORA-00313: Message 313 not found; No message fi