ORA-01153: an incompatible media recovery is active 错误处理

问题说明

今天在standby 数据库上执行如下操作，出现ORA-01153错误：

SQL> alter database open;

Database altered.


SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
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;

猜测爆粗原因可能是重复启用日志应用。

处理方式

取消应用：

SQL> alter database recover managed standby database cancel;

Database altered.

重新开启应用：

SQL> alter database recover managed standby database disconnect from session;

Database altered.