ORA-00600 [krcpop_badfile]错误处理

    客户的数据库是一个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

Symptoms

Cause

Solution

---

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23135684/viewspace-1079185/