配置完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.
此后，主机的插入数据就可以实时查询到了
