Oracle 10G DG - 归档日志坏掉导致无法启用MRP问题

59 阅读 0 评论 39 点赞

我是靠谱客的博主年轻薯片，最近开发中收集的这篇文章主要介绍Oracle 10G DG - 归档日志坏掉导致无法启用MRP问题，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

10G DG 无法与主库进行数据库同步,归档日志已经传送过来,但无法启用MRP,所以主库的新数据无法同步.
在备库手动启用MRP,alter日志提示有日志出现异常.
SQL>recover managed standby database disconnect from session;

Mon Jan 16 16:31:39 CST 2012
ALTER DATABASE RECOVER managed standby database disconnect from session
Mon Jan 16 16:31:39 CST 2012
Attempt to start background Managed Standby Recovery process (JTPRODSB)
MRP0 started with pid=18, OS id=29139
Mon Jan 16 16:31:39 CST 2012
MRP0: Background Managed Standby Recovery process started (JTPRODSB)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 2 processes
Mon Jan 16 16:31:45 CST 2012
Waiting for all non-current ORLs to be archived...
Media Recovery Log /u01/oradata/JTPRODSB/archivelog/2012_01_16/o1_mf_1_66_7k7ohndz_.arc
Mon Jan 16 16:31:45 CST 2012
Errors in file /u01/app/oracle/admin/JTPRODSB/bdump/jtprodsb_mrp0_29139.trc:
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: '/u01/oradata/JTPRODSB/archivelog/2012_01_16/o1_mf_1_66_7k7ohndz_.arc'
Errors with log /u01/oradata/JTPRODSB/archivelog/2012_01_16/o1_mf_1_66_7k7ohndz_.arc
MRP0: Background Media Recovery terminated with error 317

归档日志有一个出现问题,为o1_mf_1_66_7k7ohndz_.arc此时备库上所有操作被这个有问题的归档所强制中断.

检查如下:
1,standby日志应用情况v$archived_log;
2,在主库和备库crosscheck copy,检查上述归档日志在主备两边的实际情况;
3,standby删除有问题的日志文件RMAN>delete expired copy;
4,在OS上删除文件rm -fo1_mf_1_66_7k7ohndz_.arc
5,此时dataguard会自动探测出日志gap,会自动从主库对该日志进行重新传送.