客户的数据库是一个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 ---> 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博客 ” ,链接:https://blog.itpub.net/23135684/viewspace-1079185/
,如需转载,请注明出处,否则将追究法律责任。