ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]错误处理

机器断电以后,重新启动报如下错误:

[oracle@zhuxg ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 1 11:28:49 2013

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  276197376 bytes
Fixed Size                  1344400 bytes
Variable Size             171969648 bytes
Database Buffers           96468992 bytes
Redo Buffers                6414336 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],[], [], [], [], [], [], [], []

在alert日志中有如下报错信息:

Wed May 01 08:21:09 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
:
Aborting crash recovery due to error 600
Errors in file /u01/app/oracle/diag/rdbms/asmdb/ASMDB/trace/ASMDB_ora_5210.trc:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
Errors in file /u01/app/oracle/diag/rdbms/asmdb/ASMDB/trace/ASMDB_ora_5210.trc:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN /* db agent *//* {0:0:2} */...

在ASMDB_ora_5210.trc文件中有如下的信息:

..................

17755E0 03C10222 096F780B 36380113 6029D938  ["....xo...868.)`]
17755F0 D843E0FF 7CAA8000 02C1B000 88DC0248  [..C....|....H...]
Reading datafile '+ZHUXGASM/asmdb/datafile/undotbs1.258.813246367' for corruption at rdba: 0x00c00858 (file 3, block 2136)
Reread (file 3, block 2136) found same corrupt data (logically corrupt)
******** WRITE VERIFICATION FAILED ********

由此我们知道是因为数据库宕机之后,出现了逻辑坏块 (logically corrupt),因此需要进行介质恢复。

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  276197376 bytes
Fixed Size                  1344400 bytes
Variable Size             171969648 bytes
Database Buffers           96468992 bytes
Redo Buffers                6414336 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

介质恢复之后,再打开数据库就好了。

时间: 2024-09-20 00:11:38

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]错误处理的相关文章

ORA-00600: internal error code, arguments: [4194]

使用PlateSpin复制出来的一数据库服务器(Oracle 10g)在启动数据库实例时遇到"ORA-00600: internal error code, arguments: [4194]....."错误,实例在启动后,会自然Down掉.具体情况如下所示: Successfully onlined Undo Tablespace 54. Mon Nov 21 11:34:03 2016 SMON: enabling tx recovery Mon Nov 21 11:34:03 2

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []

    今天在PlateSpin Forge(关于PlateSpin相关介绍,请见最下面部分简单介绍) 复制出来的一台数据库服务器上,测试数据库能否正常启动时,遇到了"ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []"错误:   在官方文档介绍中,这个错误主要出现在磁盘出现故障导致数据库崩溃后,实例启动失败,并报ORA-00600: arguments: [k

ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []

故障现象:     在查询wwl005这张表的时候,报内部错误,对于这张表我们刚才是做了不一致性恢复,之后在查询报如下错误,对于这种现象一般都是由于bug或坏块引起. 15:43:53 SQL> select * from wwl005; select * from wwl005               * ERROR at line 1: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0]

ORA-00600: internal error code, arguments: [17281], [1001], [0x1FF863EE8], [], [], [], [], []

我们生产服务器中的一个数据库发出监控告警日志的邮件,内容如下所示,在31号09:11分出现了大名鼎鼎的ORA-00600错误. Dear All:   The Instance xxx' alert log occured the ora errors ,please see the detail blow and take action for it. many thanks! -----------------------------------------  The errors is b

删除数据报ORA-00600: internal error code, arguments: [ktbesc_plugged]

Oracle在删除数据是以下错误: ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], [] 原因是由于进行过表空间的传输操作. 解决方法: ALTER TABLE 表名 MOVE tablespace 表空间名 ;     Ora-600 [Ktbesc_plugged] Error On Insert Or Delete (文档 ID 1372

ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]

案例环境:                操作系统版本: Red Hat Enterprise Linux ES release 4                数据库版本  : 10.2.0.4.0 32 bit 案例介绍: 今天我 执行stop_oracle.sh脚本关闭数据库时遭遇了ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []. 其中

使用DBLINK查询时报ORA-00600: internal error code, arguments: [kzdlk_zt2 err]

  >                           >                                          > >                 > >                                                                   <>   <><>     <>  <>                        

Win8系统安装过程中提示Error Code:0x0000005D错误的解决方法

  win8系统虽然在慢慢退出市场,不过还是有不少的用户喜欢Win8系统的风格,而在Win7升级win8系统的过程中会出现一些问题,有位用户遇到错误提示Error Code:0x0000005D的问题,该如何解决此问题呢?下面小编研究整理安装Win8系统提示Error Code:0x0000005D错误的解决方法. 错误信息如下: Your PC needs to restart. Please hold down the power button Error Code:0x0000005D P

安装Win8系统提示Error Code:0x0000005D错误怎么办

  错误信息如下: Your PC needs to restart. Please hold down the power button Error Code:0x0000005D Paramers: 0x030F0209 0x756E6547 0x49656E69 0x6C65746E 解决办法: 进入BIOS设置,在Advanced > CPU 栏目之下找到 EXECUTE DISABLE BIT, 默认如果是Disabled 的话,Enable之,重启继续安装.问题解决. 注意:某些主板