Oracle 错误 ORA-00600 [kcvcrv_fb_inc_mismatch]

今天做测试时碰到[kcvcrv_fb_inc_mismatch]错误，经查metalink也无任何解释。试验过程如下仅作记录:
[quote]SQL> !uname -a
Linux mcprod 2.6.18-53.el5PAE #1 SMP Mon Nov 12 02:55:09 EST 2007 i686 i686 i386 GNU/Linux

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> select SEQUENCE# ,STATUS, FIRST_CHANGE# from v$log;

SEQUENCE# STATUS FIRST_CHANGE#
---------- ---------------- ---------------------
23 INACTIVE 9745339584505
24 CURRENT 9745339584940
22 INACTIVE 9745339584502

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> alter system switch logfile;

System altered.

SQL> select SEQUENCE# ,STATUS, FIRST_CHANGE# from v$log;

SEQUENCE# STATUS FIRST_CHANGE#
---------- ---------------- ---------------------
26 INACTIVE 9745339584955
27 INACTIVE 9745339584958
28 CURRENT 9745339584962

SQL> alter system checkpoint;

System altered.
QL> desc V$FLASHBACK_DATABASE_LOGFILE
Name Null? Type
----------------------------------------------------------------- -------- --------------------------------------------
NAME VARCHAR2(513)
LOG# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
FIRST_CHANGE# NUMBER
FIRST_TIME DATE

SQL> select name,log#,sequence#,first_change# from v$flashback_database_logfile;

NAME LOG# SEQUENCE# FIRST_CHANGE#
---------------------------------------- ---------- ---------- ---------------------
/ora10g/app/flash_recovery_area/SUPER/fl 1 1 9745339539220
/ora10g/app/flash_recovery_area/SUPER/fl 2 2 9745339584473

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size 1262020 bytes
Variable Size 973082172 bytes
Database Buffers 587202560 bytes
Redo Buffers 15511552 bytes
Database mounted.
SQL> flashback database to scn 9745339539220;

SQL> col OLDEST_FLASHBACK_SCN for 9999999999999999999
SQL> select OLDEST_FLASHBACK_SCN from v$flashback_database_log;
OLDEST_FLASHBACK_SCN
--------------------
9745339539104
SQL> flashback database to scn 9745339539105;

Flashback complete.

SQL> alter database open read only;

Database altered.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size 1262020 bytes
Variable Size 973082172 bytes
Database Buffers 587202560 bytes
Redo Buffers 15511552 bytes
Database mounted.
SQL> select current_scn from v$database;

CURRENT_SCN
-----------
0
SQL> col checkpoint_change# for 9999999999999999999999
SQL> select checkpoint_change# from v$datafile_header;
CHECKPOINT_CHANGE#
-----------------------
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105

8 rows selected.
SQL> alter database open resetlogs;

Database altered.

SQL> col resetlogs_change# for 999999999999999999999
SQL> select resetlogs_change# from v$database;

RESETLOGS_CHANGE#
----------------------
[color=red]9745339539106[/color]--可以看到resetlogs_change#递增+1
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size 1262020 bytes
Variable Size 973082172 bytes
Database Buffers 587202560 bytes
Redo Buffers 15511552 bytes
Database mounted.
SQL> flashback database to before resetlogs;

Flashback complete.

SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
-----------------------
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105
9745339539105

8 rows selected.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcvcrv_fb_inc_mismatch], [0], [456954], [697637328], [2269], [58744482],
[707057325], []
SQL> alter database open read only;

Database altered.[/quote]
经alert日志提示
[quote]Thu Dec 31 12:55:11 2009
Database incarnation does not match that in flashback
database logs. You can workaround this internal error and
restart database by turning flashback off first.[/quote]

[quote]SQL> alter database flashback off;

Database altered.

SQL> alter database open resetlogs;

Database altered.
[/quote]
说明：网上也出现诸多flashback to before resetlogs之后出现kcvcrv_fb_inc_mismatch]的情况，我估计是Oracle一bug。数据字典V$DATABASE_INCARNATION存放了INCARNATION信息，利用此信息结合v$archived_log中的归档日志信息，理论上来讲可以穿越resetlogs恢复。（当然这里面涉及到了很多Oracle bug，嘿嘿）