ORA-600[kcratr_scan_lastbwr]論理不良ブロック
4065 ワード
データベースのバージョン:
11.2.0.3
問題:
今日、テストデータベースを起動したとき、dbがopenできないことに気づき、次のようにエラーが発生しました.
解決プロセス:
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[inc 2][71353]:completed 2、問題の分析と解決
alertログでは実ははっきり言っていますが、実際にはtraceファイルもほとんど見る必要はありません.インターネットを利用して简単にgoogleして、解决方法があって、直接gaしましょう.
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、処理効果の検証
クリーンクローズを1回実行し、オープンし、エラーが報告されず、問題の処理が完了します.
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>
___________________________________________________________________________________
著作権は所有して、文章は転載することを許可して、しかしリンクの方式でソースの住所を明記しなければならなくて、さもなくば法律の責任を追及します!
Author: laven54 (lurou)
Email: [email protected]
Blog: http://blog.csdn.net/laven54
QQグループ:164734649グループで質問できますが、Oracleに関する質問には興味があります.
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[inc 2][71353]:completed 2、問題の分析と解決
alertログでは実ははっきり言っていますが、実際にはtraceファイルもほとんど見る必要はありません.インターネットを利用して简単にgoogleして、解决方法があって、直接gaしましょう.
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、処理効果の検証
クリーンクローズを1回実行し、オープンし、エラーが報告されず、問題の処理が完了します.
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>
___________________________________________________________________________________
著作権は所有して、文章は転載することを許可して、しかしリンクの方式でソースの住所を明記しなければならなくて、さもなくば法律の責任を追及します!
Author: laven54 (lurou)
Email: [email protected]
Blog: http://blog.csdn.net/laven54
QQグループ:164734649グループで質問できますが、Oracleに関する質問には興味があります.