日志能传输到过来:
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
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博客 ” ,链接:http://blog.itpub.net/25465866/viewspace-1168665/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25465866/viewspace-1168665/