当前位置:  数据库>oracle

ORA-600 [kcratr_scan_lastbwr] 逻辑坏块

    来源: 互联网  发布时间:2017-05-24

    本文导语: 数据库版本: 11.2.0.3 问题现象: 今天在启动一台测试数据库的时候,发现db不能open,报错如下: ERROR at line 1:  解决过程: 1、检查alert日志 Mon Jul 22 11:35:12 2013 ALTER DATABASE OPENBeginning crash recovery of 1 threadsparallel recovery started with 3 ...

数据库版本:

11.2.0.3

问题现象:

今天在启动一台测试数据库的时候,发现db不能open,报错如下:

ERROR at line 1:

 

解决过程:

1、检查alert日志

Mon Jul 22 11:35:12 2013

ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Started redo scan
Hex dump of (file 3, block 272) in trace file /opt/Oracle/diag/rdbms/ebai/ebai/trace/ebai_ora_4930.trc


Write verification failed for File 3 Block 272 (rdba 0xc00110)
Errors in file /opt/oracle/diag/rdbms/ebai/ebai/trace/ebai_ora_4930.trc (incident=71353):
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/ebai/ebai/incident/incdir_71353/ebai_ora_4930_i71353.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Aborting crash recovery due to error 600
Errors in file /opt/oracle/diag/rdbms/ebai/ebai/trace/ebai_ora_4930.trc:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
Errors in file /opt/oracle/diag/rdbms/ebai/ebai/trace/ebai_ora_4930.trc:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Dumping diagnostic data in directory=[cdmp_20130722113516], requested by (instance=1, osid=4930), summary=[incident=71353].
Mon Jul 22 11:36:11 2013
Sweep [inc][71353]: completed
Sweep [inc2][71353]: completed

2、分析并解决问题

alert日志里边其实已经说得很清楚了,实际上连trace文件基本都不需要查看了。上网简单goole了一下,就有解决办法,直接噶搞吧。

SUSE11sp2:/oracle/oraarch> sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 22 14:45:49 2013


Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> select status from v$instance;


STATUS
------------
MOUNTED


SQL> select open_mode from v$database;


OPEN_MODE
--------------------
MOUNTED



Media recovery complete.
SQL>
SQL>
SQL> alter database open;


Database altered.


SQL>
SQL>
SQL> select status from v$instance;


STATUS
------------
OPEN


SQL> select open_mode from v$database;


OPEN_MODE
--------------------
READ WRITE

3、验证处理效果

执行一次干净关闭,然后在打开,不在报错,问题处理完毕。

SQL> alter system checkpoint;

System altered.


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 4125462528 bytes
Fixed Size 2234840 bytes
Variable Size 956302888 bytes
Database Buffers 3154116608 bytes
Redo Buffers 12808192 bytes
Database mounted.
Database opened.
SQL>
SQL>

推荐阅读:

ORA-00600 [2662]错误解决

ORA-00600: internal error code, arguments: [4194]解决方法

ORA-00600: internal error code, arguments: [13013]解决方法


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 出现ORA-01401和ORA-01008错误?
  • Eclipse连接Oracle数据库的ORA-00604 ORA-12705错误
  • oracle ORA-01114、ORA-27067错误解决方法
  • Oracle不能删除表 ORA-00604 ORA-01422 错误
  • 如何得到带有ora的行的下一行
  • ORA-12514及ORA-28547错误解决方案
  • 如何配置 linux 下 oracle 的 listener .ora 和
  • 浅析如何在tnsnames.ora中配置监听
  • Orcle的package中访问其它Schema的表报错ORA-00942解决方法
  • oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法
  • [Oracle] 浅析令人抓狂的ORA-01555问题
  • 解决报错ora-32035的方法分析
  • aq.executeQuery: ORA-00020: maximum number of processes (59) exceeded
  • Oracle 数据库闪回功能设置出现ORA-19809和ORA-19804错误
  • ORA-00947:Not enough values (没有足够的值)的深入分析
  • solaris10 安装 ora9.2.0.1 时报错
  • 在UNIX下,我的ORA817该怎么样才可以自己启动呀?
  • 基于ORA-12170 TNS 连接超时解决办法详解
  • plsql连接oracle数据库报ora 12154错误解决方法
  • 安装oracle出现error:ora-01031:insufficient privilleges的解决


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,