1 现象说明

一朋友说Oracle 不能启动到mount 状态，报如下错误：

*** CLIENT DRIVER:(SQL*PLUS)2025-04-08T21:34:54.987308+08:00CONTAINER ID:(1)2025-04-08T21:34:54.987328+08:00
LTOCO0000]

Jump to table of contentsDump continued from file: /opt/oracle/diag/rdbms/orclcdb/oRcLcDB/trace/0RcLcDB_ora_7607.trc[TOCO0001]ORA-00600: ??????, ??: [kccsbck first], [1], [2968991602], [], [], [], [], [], [], [], [], []

LTOCOG0O1-END]
[TOC00002]
Dump for incident 816323 (0RA 600 [kccsbck_first])=-----=
*** 2025-04-08T21:34:54.990499+08:00dbkedDefpump(): starting incident default dumps (flags=0x2, level=3, mask=0x0)[TOC00003]Current soL statement for this session(sgl id=92b382ka0ggdt)----ALTER DATABASE MOUNT

[TOCO0003-END]

他怀疑哪里有问题，实际上Oracle 不管在怎么坏，肯定是可以启动到Mount状态的，这个是读控制文件，所以不会有其他问题。http://www.cndba.cn/dave/article/131626http://www.cndba.cn/dave/article/131626

2 解决方法

MOS 上对这个错误有说明，如下：http://www.cndba.cn/dave/article/131626

ERROR:              
   Format: ORA-600 [kccsbck_first] [a] [b] 

VERSIONS:           
   versions 8.1.5 to 10.2 

DESCRIPTION: 

   We receive this error because we are attempting to be the first 
   thread /instance to mount the database and cannot because it appears that 
   at least one other thread has mounted the database already. 

   We therefore abort the mount attempt and log this error. 

ARGUMENTS:          
   Arg [a] thread number which has database mounted 
   Arg [b] mount id of the thread 

FUNCTIONALITY:      
   CONTROL FILE COMPONENT

这里说的也很清楚，数据库不能mount的原因是已经mount了。 这个故障环境恰好是一个roseha集群，当关闭当前节点的数据库时候,另外一个节点认为oracle down掉了,然后自动在该节点去尝试启动数据库,而当前操作节点去尝试mount数据库的时候发生该错误,因为该数据库的另外一个节点已经mount了.http://www.cndba.cn/dave/article/131626http://www.cndba.cn/dave/article/131626

版权声明：本文为博主原创文章，未经博主允许不得转载。