一、环境描述oracle 12cRHEL 7 二、操作注意:需要在物理standby节点执行切换,因为主节点要重启。 1.查看配置 DGMGRL> show configuration; Confi
一、环境描述
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>
--结束END--
本文标题: 12c DataGuard switchover to 'primary'
本文链接: https://www.lsjlt.com/news/36110.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0