物理standby转换为逻辑standby的步骤
1.备库：与主库同步后停止日志应用alter database recover managed standby database cancel;2.主库：build数据字典到redoSQL> execdbms_logstdby.build;PL/SQL procedure successfully completed.3.备库：转换physical standby 到 logic standbySQL> alter database recover to logical standby busi; Database altered.4.备库：关闭重启SQL> shutdown immediateORA-01507: database not mountedORACLE instance shut down.SQL> startup mount;ORACLE instance started.Database mounted.5.备库：打开logicstandbySQL> alter database open resetlogs;Database altered.6.备库：开始应用日志SQL> alteoracle账号r database start logical standby apply ;Database altered.7.备库：停止应用命令SQL> alter database stop logical standby apply;Database altered.