物理standby转换为逻辑standby的步骤

1.备库：与主库同步后停止日志应用
alter database recover managed standby database cancel;

2.主库：build数据字典到redo

SQL> execdbms_logstdby.build;
PL/SQL procedure successfully completed.

3.备库：转换physical standby 到 logic standby
SQL> alter database recover to logical standby busi;      
Database altered.

4.备库：关闭重启
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Database mounted.
5.备库：打开logicstandby
SQL> alter database open resetlogs;
Database altered.
6.备库：开始应用日志
SQL> alter database start logical standby apply ;

Database altered.

7.备库：停止应用命令
SQL> alter database stop logical standby apply;
Database altered.