共计 1382 个字符，预计需要花费 4 分钟才能阅读完成。
一、环境描述
Oracle 12c
RHEL 7
二、操作
注意：需要在物理 standby 节点执行切换，因为主节点要重启。
1. 查看配置
| DGMGRL> show configuration; | |
| Configuration - dg_config | |
| Protection Mode: MaxAvailability | |
| Members: | |
| orcl - Primary database | |
| orcldg - Physical standby database | |
| Fast-Start Failover: DISABLED | |
| Configuration Status: | |
| SUCCESS (status updated 30 seconds ago) |
2. 验证主库
| DGMGRL> validate database orcl; | |
| Database Role: Primary database | |
| Ready for Switchover: Yes | |
| Flashback Database Status: | |
| orcl: Off |
3. 验证物理备库
| DGMGRL> validate database orcldg; | |
| Database Role: Physical standby database | |
| Primary Database: orcl | |
| Ready for Switchover: Yes | |
| Ready for Failover: Yes (Primary Running) | |
| Flashback Database Status: | |
| orcl: Off | |
| orcldg: On | |
| Standby Apply-Related Information: | |
| Apply State: Running | |
| Apply Lag: 13 hours 29 minutes 48 seconds (computed 1 second ago) | |
| Apply Delay: 0 minutes |
4. 进行切换
| DGMGRL> switchover to orcldg; | |
| Performing switchover NOW, please wait... | |
| New primary database "orcldg" is opening... | |
| Oracle Clusterware is restarting database "orcl" ... | |
| ORA-01017: invalid username/password; logon denied | |
| Warning: You are no longer connected to ORACLE. | |
| shut down instance "orcl" of database "orcl" | |
| start up instance "orcl" of database "orcl" |
5. 切换后确认
| DGMGRL> show configuration; | |
| Configuration - dg_config | |
| Protection Mode: MaxAvailability | |
| Members: | |
| orcldg - Primary database | |
| orcl - Physical standby database | |
| Fast-Start Failover: DISABLED | |
| Configuration Status: | |
| SUCCESS (status updated 30 seconds ago) | |
| DGMGRL> |
更多 Oracle 相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址：http://www.linuxidc.com/Linux/2017-12/149265.htm
正文完
星哥玩云-微信公众号
