年后放假回来，同事反应某dg环境不一致，备库从放假以来一直没有应用归档日志，归档文件已经传送到备库，备库启动在read only状态下，但没有appliy日志通过alter日志文件发现发下

Tue Feb 17 12:47:24 2015
Trace dumping is performing id=[cdmp_20150217124724]
Recovery Slave PR04 previously exited with exception 600
Tue Feb 17 12:47:24 2015
MRP0: Background Media Recovery terminated with error 448
Errors in file /u01/app/oracle/diag/rdbms/un_dg253/wxcrm/trace/wxcrm_pr00_10854.trc:
ORA-00448: normal completion of background process
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 79130967
Errors in file /u01/app/oracle/diag/rdbms/un_dg253/wxcrm/trace/wxcrm_pr00_10854.trc:
ORA-00448: normal completion of background process
Errors in file /u01/app/oracle/diag/rdbms/un_dg253/wxcrm/trace/wxcrm_mrp0_10840.trc:
ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
MRP0: Background Media Recovery process shutdown (wxcrm)
Trace dumping is performing id=[cdmp_20150217124725]

数据库版本为
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

通过网上一些网友说是oracle bug
具体参看 http://blog.csdn.net/kelly1984/article/details/41694983

后我shutdown immediate关闭备备，再启动到mount下。再启用实时应用，

alter database recover managed standby database using current logfile disconnect from session; 问题得以解决，归档也一个个被应用，希望以上经验能帮助其它同行

ITPub博客

oracle datagurad 故障处理

最新文章