ORA-01153: an incompatible media recovery is active
配置完dataguard，发现主机插入的数据不能直接在备机查询到
原来设置的
启动redo 应用 SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
现在想切换为
启动实时应用 SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
切换时报错
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT * ERROR at line 1: ORA-01153: an incompatible media recovery is active
原来备机需要先取消
SQL> alter database recover managed standby database cancel; Database altered.
然后备机再执行
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT; Database altered.
此后，主机的插入数据就可以实时查询到了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70004783/viewspace-2789065/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
