当前位置:操作系统 > Unix/Linux >>

物理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.

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,