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.