ORA-600[kcratr_scan_lastbwr]邏輯壞塊解決

標籤：bit   解決   rtu   rect   connect   關閉   request   corrupt   package   

 

 資料庫版本：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 2013ALTER DATABASE OPENBeginning crash recovery of 1 threads parallel recovery started with 3 processesStarted redo scanHex dump of (file 3, block 272) in trace file /opt/oracle/diag/rdbms/ebai/ebai/trace/ebai_ora_4930.trcReading 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.trcUse 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 600Errors 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 2013Sweep [inc][71353]: completedSweep [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 ProductionWith 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 immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL>SQL>SQL>SQL>SQL> startupORACLE instance started.  Total System Global Area 4125462528 bytesFixed Size                  2234840 bytesVariable Size             956302888 bytesDatabase Buffers         3154116608 bytesRedo Buffers               12808192 bytesDatabase mounted.Database opened.SQL>SQL>

ORA-600[kcratr_scan_lastbwr]邏輯壞塊解決