12cDataGuardswitchoverto'primary'
一、环境描述
Oracle 12c
RHEL 7
创新互联公司长期为上1000+客户提供的网站建设服务,团队从业经验10年,关注不同地域、不同群体,并针对不同对象提供差异化的产品和服务;打造开放共赢平台,与合作伙伴共同营造健康的互联网生态环境。为永兴企业提供专业的网站制作、网站设计,永兴网站改版等技术服务。拥有10余年丰富建站经验和众多成功案例,为您定制开发。
二、操作
注意:需要在物理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>
网站标题:12cDataGuardswitchoverto'primary'
标题链接:http://azwzsj.com/article/gjdejd.html