ORA-16157: media recovery not allowed following successful FINISH recovery

客户在执行物理standby日志应用时,把recover managed standby database disconnect手误输入为recover managed
standby database finish.然后再次执行recover managed standby database disconnect没有报错,但standby无法接收和
应用日志,alert.log日志中报:
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 16157
Errors in file /u01/app/oracle/diag/rdbms/ct6604/ct6604/trace/ct6604_mrp0_7209.trc:
ORA-16157: media recovery not allowed following successful FINISH recovery
MRP0: Background Media Recovery process shutdown (ct6604)
Completed: alter database recover managed standby database disconnect from session

官方文档提示需要重建standby,但虽然standby执行过RECOVER managed standby database finish,但还没有转换为
primary,更没有read write打开过.所以此时,只需要还原控制文件即可以解决问题.

以下是ORA-16157的官方解释:
Managed Recovery Failing with ORA-16157 (文档 ID 834834.1)

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.7
This problem can occur on any platform.

Symptoms

Managed recovery failing with ORA-16157

alert.log of standby shows:
=========================
Thu Apr 16 17:35:56 2009
alter database recover managed standby database disconnect from session
Thu Apr 16 17:35:56 2009
Attempt to start background Managed Standby Recovery process (UPDATE1)
MRP0 started with pid=20, OS id=22960
Thu Apr 16 17:35:57 2009
MRP0: Background Managed Standby Recovery process started (UPDATE1)
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 16157
Thu Apr 16 17:36:02 2009
Errors in file /opt/oracle/admin/UPDATE1/bdump/update1_mrp0_22960.trc:
ORA-16157: media recovery not allowed following successful FINISH recovery

Cause
Managed recovery finish was executed in standby.

alert.log of standby shows:
=========================
Thu Apr 16 17:35:17 2009
Completed: ALTER DATABASE RECOVER managed standby database finish

Solution
Recreate the standby database.

Managed recovery can not started where managed standby database finish has been executed

Standby database can only be activated after performing managed standby database finish using:
SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28539951/viewspace-1805066/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28539951/viewspace-1805066/