应用,然后只能把原来主库启动到mount状态下,原备库open后进行实时应用:
20:42:38 SQL>alter database recover managed standby database disconnect fromsession;
Database altered.
20:43:28 SQL>SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
----------------------------------------
TO PRIMARY
Ok,在此我们可以看到切换状态已经ok了;
再进行切换?
20:43:35 SQL>alter database commit to switchover to primary with sessionshutdown;
Database altered.
在原备库查看状态:
22:41:27 SQL>select NAME,OPEN_MODE,SWITCHOVER#,SWITCHOVER_STATUS,DATABASE_ROLEfrom v$database;
NAME OPEN_MODE SWITCHOVER#SWITCHOVER_STATUS DATABASE_ROLE
------------------ -------------- --------------------------------- ------------------
FELIX READ WRITE 3596915957 TO STANDBY PRIMARY
22:41:56 SQL>
算是完成切换;
分析整个过程用了十分钟左右,主要是要学会分析:
(1) 怎么找问题?要到警告日志里面进行查找
(2) 找到了怎么分析,要理解DG的原理,这样才能解决。所以学习懂原理会事半功倍