物理standby转换为逻辑standby的步骤
物理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.