Oracle 11gr2 Data G uard primary 和 standby被切換步驟

1. primary server
確認(rèn)是主: primary
select database_role from v$database;

alter database commit to switchover to physical standby with session shutdown;
shutdown immediate;
startup nomount;
 

alter database mount standby database;

2.standby server
select database_role from v$database;
physical standby
alter database commit to switchover to primary with session shutdown;

alter recover database managed standby database disconnect from session;
shutdown immediate;
startup;

select database_role from v$database;
select switchover_status from v$database;

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]