DataGrard异常-ORA-38868

ORA-38868

数据库alert报错，并且MRP进程无法启动，数据库同步发生了异常。

环境信息

cnsh230249:cfods > uname -a
Linux cnsh230249 2.6.18-164.9.1.el5 #1 SMP Wed Dec 9 03:27:37 EST 2009 x86_64 x86_64 x86_64 GNU/Linux
cnsh230249:cfods > sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jan 28 19:55:43 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>

报错内容

Sat Jan 28 15:34:43 2012
alter database recover managed standby database parallel 64 disconnect from session
Attempt to start background Managed Standby Recovery process (cfods)
Sat Jan 28 15:34:43 2012
MRP0 started with pid=49, OS id=2416 
MRP0: Background Managed Standby Recovery process started (cfods)
 started logmerger process
Sat Jan 28 15:34:48 2012
 大专栏  DataGrard异常-ORA-38868Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 38868
Errors in file /path/app/oracle/rdbms/diag/rdbms/scfods/cfods/trace/cfods_pr00_2598.trc:
ORA-38868: warning: the control file may have incorrect data file structure
Slave exiting with ORA-38868 exception
Errors in file /path/app/oracle/rdbms/diag/rdbms/scfods/cfods/trace/cfods_pr00_2598.trc:
ORA-38868: warning: the control file may have incorrect data file structure
Recovery Slave PR00 previously exited with exception 38868
MRP0: Background Media Recovery process shutdown (cfods)
Completed: alter database recover managed standby database parallel 64 disconnect from session

解决方法

1. 确认DG目前为mount状态
2. SQL> alter database open read only;
3. SQL> select open_mode from v$database;（结果为READ ONLY）
4. SQL> shutdown immediate
5. SQL> startup nomount
6. SQL> alter database mount standby database;
7. SQL> alter database recover managed standby database disconnect parallel 8;
8. SQL> select process,block# from v$managed_standby;（多次运行）
9. 通过上一步查询，看到MRP进程的BLOCK#在变化，说明已经开始apply日志了
10. 检查alert日志，发现同步正常

分析总结

虽然第一次遇到这个错误，但是不并复杂，Oracle给出了这个错误的原因及解决方法，如下：

cnsh230249:cfods > oerr ora 38868
38868, 00000, "warning: the control file may have incorrect data file structure"
// *Cause:  This control file was created or converted based on a control file
//          from a time different from the time of the database.
// *Action: Open database read-only to synchronize the control file with the 
//          database dictionary. You can also force recovery to proceed by 
//          invoking recovery again.
cnsh230249:cfods >