标题: ORA-01153: an incompatible media recovery is active(产生原因及解决方法) [打印本页] 作者: jiawang 时间: 2020-7-15 13:55 标题: ORA-01153: an incompatible media recovery is active(产生原因及解决方法) 今天在standby 数据库上执行
alter database recover managed standby database using current logfile disconnect from session;
报如下错误：
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
从字面意思理解应该是“存在一个不兼容的介质恢复”。
仔细检查发现上面已经执行过一次
alter database recover managed standby database disconnect from session;
猜想应该是重复启用日志应用所致。故取消应用
alter database recover managed standby database cancel;
重新开启应用
alter database recover managed standby database using current logfile disconnect from session;