ORA-600 [kcratr_scan_lastbwr] 邏輯壞塊

資料庫版本：

11.2.0.3

問題現象：

今天在啟動一台測試資料庫的時候，發現db不能open，報錯如下：

ERROR at line 1:

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

解決過程：

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
Reading datafile '/oracle/oradata/ebai/undotbs01.dbf' for corruption at rdba: 0x00c00110 (file 3, block 272)
Reread (file 3, block 272) found same corrupt data (logically corrupt)
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


SQL> recover database;
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]解決方案