咨询微信: dbservice1234 7 x 24 在线支持!

    你在这里

    • You are here:
    • 首页 > 博客 > PDSERVICE的博客 > Oracle 在只读表空间中闪回数据库失败显示[krhahws_02] 和ORA-01207: 文件比控制文件更新 - 旧的控制文件

Oracle 在只读表空间中闪回数据库失败显示[krhahws_02] 和ORA-01207: 文件比控制文件更新 - 旧的控制文件

Oracle 在只读表空间中闪回数据库失败显示[krhahws_02] 和ORA-01207: 文件比控制文件更新 - 旧的控制文件

 

 

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com

 

 

ORA-01207: 文件比控制文件更新 - 旧的控制文件

 

oerr ora 1207
01207, 00000, "file is more recent than control file - old control file"
// *Cause:  The control file change sequence number in the data file is 
//         greater than the number in the control file. This implies that
//         the wrong control file is being used. Note that repeatedly causing
//         this error can make it stop happening without correcting the real
//         problem. Every attempt to open the database will advance the
//         control file change sequence number until it is great enough.
// *Action: Use the current control file or do backup control file recovery to 
//         make the control file current. Be sure to follow all restrictions 
//         on doing a backup control file recovery.

 

 

适用于:

Oracle Database – Enterprise Edition – 版本 11.2.0.3  11.2.0.3 [Release 11.2]
本文信息适用于任何平台。

症状

闪回数据库到Guaranteed Restore Point (GRP)失败显示以下:

Flashback Restore Start
Wed Apr 22 17:13:45 2015
RFS[2]: Assigned to RFS process 10617306
RFS[2]: Database mount ID mismatch [0x7c9d3b45:0x7e106bfd] (2090679109:2115005437)
RFS[2]: Not using real application clusters
Wed Apr 22 17:13:58 2015
Flashback Restore Complete <<=======
Errors in file /usr2/oracle/sunoptp/diag/rdbms/sunopt_dr/sunopt/trace/sunopt_ora_26738752.trc  (incident=328195):
ORA-00600: internal error code, arguments: [krhahws_02], [], [], [], [], [], [], [], [], [], [], []

 

Problem appears to match that described in Note 14556461.8

However, even after setting disk_asynch_io to false, flashback db to guaranteed restore point still fails with the below:

SQL> FLASHBACK DATABASE TO RESTORE POINT sunopt_dr;
FLASHBACK DATABASE TO RESTORE POINT sunopt_dr
*
ERROR at line 1:
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: ‘/u02/oradata/sunoptp/sunopt/data/ADD1201.dbf’
ORA-01207: file is more recent than control file – old control file

 

原因

数据库有只读表空间,且使用参数 READ_ONLY_OPEN_DELAYED=TRUEmount

解决方案

1) 使用以下参数重新mount数据库:

disk_asynch_io           = TRUE
read_only_open_delayed   = FALSE

2) Then open with resetlogs as the database has already been flashed back

SQL> alter database open resetlogs;

3) 一旦数据库被打开,使用以下参数重新mount数据库,然后闪回到GRP以确保闪回进程整体完成:

disk_asynch_io           = FALSE
read_only_open_delayed   = FALSE

 

参考

BUG:14556461 – ORA-600 [KRHAHWS_02] WHEN USING FLASHBACK DATABASE
NOTE:14556461.8 – Bug 14556461 – ORA-600 [krhahws_02] when using flashback database
NOTE:67512.1 – Init.ora Parameter “READ_ONLY_OPEN_DELAYED” Reference Note
NOTE:1493350.1 – Master Note: Overview of Oracle Tablespace Management