ORA-00600 [krcpop_badfile]錯誤處理

尛樣兒發表於2014-02-10

    客戶的資料庫是一個for HP-UX平臺的Oracle 10.2.0.4 Database RAC，在修改Oracle資料庫SGA初始化引數，重啟資料庫例項的時候收到如下報錯：
SQL> startup
ORACLE instance started.

Total System Global Area 3.0065E+10 bytes
Fixed Size                  2209328 bytes
Variable Size            2560444880 bytes
Database Buffers         2.7498E+10 bytes
Redo Buffers                4259840 bytes
Database mounted.
ORA-00600: internal error code, arguments: [krcpop_badfile], [], [], [], [],
[], [], []

雙例項的RAC，第一個例項啟動報錯，第二個例項正常啟動。

檢視資料庫的Block Change Tracking：
SQL> select * from v$block_change_tracking;

STATUS
----------
FILENAME
--------------------------------------------------------------------------------
     BYTES
----------
ENABLED
/archlog/blocktr/NGCRM/changetracking/o1_mf_9bmov2oc_.chg
 306283520

/archlog為共享目錄，且檔案真實存在。

檢視告警日誌，有如下提示：
Mon Jan 27 01:23:28 2014
ALTER DATABASE OPEN
CHANGE TRACKING file is not current.  It appears to be
older than the current control file.  This probably means
that an old backup of this file has been restored.
Resetting change tracking file.

根據提示重新設定change tracking file。

1).在第二個例項禁用Block Change Tracking:
SQL> alter database disable block change tracking;
禁用Block Change Tracking之後，原有的/archlog/blocktr/NGCRM/changetracking/o1_mf_9bmov2oc_.chg檔案被自動刪除。

2).重啟第一個例項。

3).兩節點例項都成功啟動後，重新啟用Block Change Tracking:
SQL> alter database enable block change tracking using file '/archlog/blocktr/NGCRM/changetracking/o1_mf_9bmov2oc_.chg';

參考文章：

Unable To Start The Database After RACconversion : ORA-00600 [krcpop_badfile] (文件 ID 1499650.1)
修改時間:2014-2-7型別:PROBLEM

In this Document


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

Starting a new RAC database fails on the 2nd node with :
  ORA-00600: internal error code, arguments: [krcpop_badfile], [], [], [], [], [], [], [], [], [], [], []

CAUSE

Block Change Tracking file NOT on a shared disk
 
SQL> select * from v$block_change_tracking;


STATUS
----------
FILENAME
--------------------------------------------------------------------------------
  BYTES
----------
ENABLED
/fd01/FIN2C/db/tech_st/11.2.0.2/dbs/FIN1S.bctf                 ---&gt THis is the Default location ORACLE_HOME/dbs
 11599872
 

SOLUTION

 

SQL> alter database disable block change tracking;
     alter database enable block change tracking using file '..shared location....';

example :
     alter database enable block change tracking using file '+DATA';

or

  alter database enable block change tracking using file '/shared_disk/orcl/block_change.bct'';


--end--

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23135684/viewspace-1079185/，如需轉載，請註明出處，否則將追究法律責任。

相關文章