http://blog.itpub.net/29254281/viewspace-1315088/

在物理StandBy的基础上进行SwitchOver

主库:192.168.1.1
备库:192.168.1.2

SwitchOver之后
主库:192.168.1.2
备库:192.168.1.1

首先,
修改主库的参数
alter system set log_archive_dest_2='service=standby valid_for=(all_logfiles,all_roles) db_unique_name=orcl' scope=both;

修改备库的参数
alter system set log_archive_dest_2='service=primary valid_for=(all_logfiles,all_roles) db_unique_name=orcl' scope=both;

查询主库SwitchOver状态
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO STANDBY

将192.168.1.1转换为StandBy,然后重启
alter database commit to switchover to physical standby with session shutdown;

shutdown immediate;
startup nomount;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

将192.168.1.2备库提升为主库
alter database commit to switchover to primary with session shutdown;

shutdown immediate;
startup open;

先启动备库，再启动主库，否则主库识别不了备库。

参考:
http://blog.csdn.net/tianlesoftware/article/details/5514082
http://blog.csdn.net/tianlesoftware/article/details/5768602

ITPub博客

DataGuard SwitchOver

最新文章