重庆思庄Oracle、Redhat认证学习论坛

标题: Alter Database Open Fails With ORA-00600 [kcfckde-mismatch-rlc] [打印本页]

作者: 刘泽宇 时间: 3 天前
标题: 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;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)