dataguard如何实现切换_DataGuard主备库切换步骤

旧主库：

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS

--------------------

TO STANDBY

alter database commit to switchover to standby with session shutdown;

旧备库，新主库：

select switchover_status from v$database;

SWITCHOVER_STATUS

--------------------

TO PRIMARY

其他备库：

select switchover_status from v$database;

SWITCHOVER_STATUS

--------------------

TO PRIMARY

旧备库，新主库

alter database commit to switchover to primary with session shutdown;

alter database open;

旧主库：

shutdown immediate;

startup;

select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

其他备库：

都不需要做操作，但是需要提前打开state和参数配置正确。

确认切换成功：

select database_role,open_mode from v$database;

检查同步：

select process,sequence#,status from v$managed_standby;

alter system switch logfile;

select max(sequence#) from v$archived_log where applied='YES';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26194851/viewspace-1719258/，如需转载，请注明出处，否则将追究法律责任。