日志能传输到过来：

SQL> SELECT SEQUENCE#,FIRST_TIME,NEXT_TIME,applied from V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIME NEXT_TIME APP

---------- ------------------ ------------------ ---

21 03-APR-13 03-APR-13 YES

22 03-APR-13 03-APR-13 YES

……

55 03-APR-13 03-APR-13 YES

56 03-APR-13 03-APR-13 YES

57 03-APR-13 03-APR-13 YES

58 03-APR-13 04-APR-13 NO

59 04-APR-13 05-APR-13 NO

但MRP0进程不能启动：

SQL> select process,status,sequence#,block#,blocks from v$managed_standby;

PROCESS STATUS SEQUENCE# BLOCK# BLOCKS

--------- ------------ ---------- ---------- ----------

ARCH CONNECTED 0 0 0

ARCH CLOSING 56 100353 496

……

ARCH CONNECTED 0 0 0

RFS IDLE 0 0 0

查看警告日志：

Thu Apr 4 11:01:48 2013

Media Recovery Log /archive/shanghai/1_58_811768827.arc

Errors with log /archive/shanghai/1_58_811768827.arc

MRP0: Background Media Recovery terminated with error 331

Thu Apr 4 11:01:48 2013

Errors in file /oracle/app/admin/rollup/bdump/rollup_mrp0_8248.trc:

ORA-00331: log version 10.2.0.4.0 incompatible with ORACLE version 10.2.0.1.0

ORA-00334: archived log: '/archive/shanghai/1_58_811768827.arc'

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

……

原因：

之前对主备库都作了升级，主库已经把兼容性参数从10.2.0.1.0改到10.2.0.4.0，原以为备库会应用日志自动把参数修改，但显然需要手工修改了。

解决方法：

把备库的兼容性参数修改到10.2.0.4.0：

SQL> alter system set compatible='10.2.0.4.0' scope=spfile;

ITPub博客

compatible兼容参数不正确导致DG物理备库不能应用日志