ITPub博客

首页 > 数据库 > Oracle > ORA-00600 [krcpop_badfile]错误处理

ORA-00600 [krcpop_badfile]错误处理

原创 Oracle 作者:尛样儿 时间:2014-02-10 22:33:05 0 删除 编辑

    客户的数据库是一个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                 ---> 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle数据库管理员,Oracle数据库系统构架员;2012年7月出版《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》一书;Oracle 10g OCM。

注册时间:2010-01-05

  • 博文量
    483
  • 访问量
    5327252