Flashback Database fails with [krhahws_02] and ORA-01207 for read only tablespaces

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

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

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

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.

症状

如下所示，闪回数据库到保证恢复点失败：

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], [], [], [], [], [], [], [], [], [], [], []

问题似乎与Note 14556461.8中描述的一致。
但是，即使是在将disk_asynch_io 设为false后，闪回db到保证恢复点仍旧失败，如下所示:

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=TRUE参数装载。

解决方案

1)用下列参数重新安装数据库:

disk_asynch_io           = TRUE
read_only_open_delayed   = FALSE

2) 然后用resetlogs打开，因为数据库已经被闪回。
SQL> alter database open resetlogs;
3) 一旦数据库打开，用下列参数重新安装数据库，然后闪回到GRP以确保你的闪回过程全部完成:

disk_asynch_io           = FALSE
read_only_open_delayed   = FALSE