今天在做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.
成功执行!