ORA-01153: an incompatible media recovery is active

备库开启闪回时报错：

SYS@SBDB1> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
 

 

然后确认数据库open_mode：

SYS@SBDB1> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY
 

然后操作：

SYS@SBDB1> recover managed standby database cancel;
Media recovery complete.
SYS@SBDB1> alter database flashback on;

Database altered.

 

 

问题解决，再将备库状态还原即可。

 

(笔者原创文章，转载请注明出处：https://blog.csdn.net/LFCuiYs）谢谢！