ORA-01153处理方法

ORA-01153处理方法


今天在做Oracle DG 主备库切换测试时，在切换后的新备库执行命令时报错如下：

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

经检查发现上面执行过如下命令：

SQL>recover managed standby database disconnect from session;
Media recovery complete.

猜想可能是重复启用日志应用所致，故取消应用：

SQL>alter database recover managed standby database cancel;

Database altered.

再次开启应用：

SQL>alter database recover managed standby database using current logfile disconnect from session;

Database altered.