Alter Database Open Fails With ORA-00600 [kcfckde-mismatch-rlc]

刘泽宇

处理方法：
Error ORA-00600:  [kcfckde-mismatch-rlc]  [expected_resetlogs_id], [current_resetlogs_id] while opening a database

i.e: ORA-00600 [kcfckde-mismatch-rlc], [1113582060], [1067549566]

The error are produced due to mismatch between the current incarnation and the expected incarnation.

Following queries can be run with the Database in mount state:

SQL> select ICRID, ICRLC_I from x$kccic;

ICRID ICRLC_I
1 1067549566
2 1113582060

2 rows selected.

SQL> select DIRLC_I from x$kccdi;

DIRLC_I


1113582060

1 row selected.

SQL> Select INCARNATION#, RESETLOGS_CHANGE#, RESETLOGS_TIME, STATUS,RESETLOGS_ID  from  v$database_incarnation;

INCARNATION# RESETLOGS_CHANGE#    RESETLOGS_TIME                       STATUS         RESETLOGS_ID
1                            1    <date time when resetlog was done>   CURRENT        1067549566
2                    111939815    <date time when resetlog was done>   ORPHAN         1113582060




SQL> select file#,name,RESETLOGS_TIME,status from v$datafile_header;

FILE#     NAME         RESETLOGS_TIME     

1     <file_name>     24-aug-2022 16:21:00     
2     <file_name>     24-aug-2022 16:21:00     





RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name         DB ID            STATUS       Reset SCN   Reset Time
------- -------      --------           ---------------- --------      ------------   ------------
1           1         <DBNAME>   <DBID>         CURRENT                       1  18-MAR-21
2           2         <DBNAME>   <DBID>         ORPHAN          111939815  24-AUG-22



As you can see from above output, the  incarnation 2 (Orphan) does match with the Resetlogs_time of the data files.

To resolve this, Place the database in mount state and run

rman target /

RMAN> reset database to incarnation 2;
RMAN> list incarnation of database;
exit

sqlplus / as sysdba

SQL> Alter database open;