本文介绍了Oracle DataGuard环境中遇到的ORA-00310和ORA-00334错误，详细分析了由于v$archived_log视图异常导致的MRP进程故障。通过检查和验证，发现归档日志文件redo02.log被错误注册。解决方案是重新创建备用控制文件，并提供了具体的SQL命令和步骤，最终成功解决了故障。
天萃荷净
运维DBA反映生产环境的Oracle DataGuard环境报错ORA-00310 ORA-00334，分析原因因v$archived_log视图记录异常导致dg MRP进程异常
1.版本信息
操作系统Linux 4.8 x86
数据库版本ORACLE 9.2.0.4
2.alert日志报错
MRP进程出现异常报ORA-00310/ORA-00334错误
…………
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_75.dbf
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_76.dbf
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_77.dbf
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_78.dbf
Media Recovery Log /u01/oracle/oradata/oracleplus/redo02.log
MRP0: Background Media Recovery terminated with error 310
Thu Nov 8 07:44:39 2012
Errors in file /u01/oracle/admin/lunar/bdump/lunar_mrp0_25625.trc:
ORA-00310: archived log contains sequence 85; sequence 79 required
ORA-00334: archived log: '/u01/oracle/oradata/oracleplus/redo02.log'
Recovery interrupted.
MRP0: Background Media Recovery process shutdown
trace文件
*** SESSION ID:(17.13) 2012-11-08 07:24:12.986
Background Managed Standby Recovery process started
*** 2012-11-08 07:24:18.023
Managed Recovery: Active posted.
*** 2012-11-08 07:41:03.171
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_64.dbf
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_65.dbf
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_66.dbf
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_67.dbf
Media Recovery Log /u01/oracle/oradata/lunar/arch/1_68.dbf
Media Recovery Log /u01/oracle/orad
最低0.47元/天 解锁文章
扫一扫
2361
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
