oracle 19c使用dgmgrl来执行switchover和failover切换
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了oracle 19c使用dgmgrl来执行switchover和failover切换,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4909字,纯文字阅读大概需要8分钟。
内容图文
oracle 19c使用dgmgrl来执行switchover和failover切换
[oracle@raclhr-18c-n1 ~]$ dgmgrl sys/lhr@lhr19cdg DGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Aug 16 16:30:25 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "lhr19cdg" Connected as SYSDBA. DGMGRL> show configuration Configuration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 13 seconds ago) DGMGRL> switchover to lhr19cdg Performing switchover NOW, please wait... New primary database "lhr19cdg" is opening... Operation requires start up of instance "lhr19c" on database "lhr19c" Starting instance "lhr19c"... Connected to an idle instance. ORACLE instance started. Connected to "lhr19c" Database mounted. Database opened. Connected to "lhr19c" Switchover succeeded, new primary is "lhr19cdg" DGMGRL> show configuration Configuration - lhr19c Protection Mode: MaxPerformance Members: lhr19cdg - Primary database lhr19c - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 62 seconds ago) DGMGRL> failover to lhr19c Performing failover NOW, please wait... Error: ORA-16600: not connected to target standby database for failover Failed. Unable to failover DGMGRL> exit [oracle@raclhr-18c-n1 ~]$ dgmgrl sys/lhr@lhr19c DGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Aug 16 16:33:37 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "lhr19c" Connected as SYSDBA. DGMGRL> failover to lhr19c Performing failover NOW, please wait... Failover succeeded, new primary is "lhr19c" DGMGRL> DGMGRL> show configuration Configuration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database (disabled) ORA-16661: the standby database needs to be reinstated Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 28 seconds ago) DGMGRL> reinstate database lhr19cdg Reinstating database "lhr19cdg", please wait... Operation requires shut down of instance "lhr19cdg" on database "lhr19cdg" Shutting down instance "lhr19cdg"... Connected to "lhr19cdg" ORACLE instance shut down. Operation requires start up of instance "lhr19cdg" on database "lhr19cdg" Starting instance "lhr19cdg"... Connected to an idle instance. ORACLE instance started. Connected to "lhr19cdg" Database mounted. Connected to "lhr19cdg" Continuing to reinstate database "lhr19cdg" ... Reinstatement of database "lhr19cdg" succeeded DGMGRL> show configuration Configuration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 32 seconds ago) DGMGRL> switchover to lhr19cdg Performing switchover NOW, please wait... Operation requires a connection to database "lhr19cdg" Connecting ... Connected to "lhr19cdg" Connected as SYSDBA. New primary database "lhr19cdg" is opening... Operation requires start up of instance "lhr19c" on database "lhr19c" Starting instance "lhr19c"... Connected to an idle instance. ORACLE instance started. Connected to "lhr19c" Database mounted. Database opened. Connected to "lhr19c" Switchover succeeded, new primary is "lhr19cdg" DGMGRL> DGMGRL> show configuration Configuration - lhr19c Protection Mode: MaxPerformance Members: lhr19cdg - Primary database lhr19c - Physical standby database Error: ORA-16541: member is not enabled Fast-Start Failover: Disabled Configuration Status: ERROR (status updated 143 seconds ago) DGMGRL> show configuration Configuration - lhr19c Protection Mode: MaxPerformance Members: lhr19cdg - Primary database lhr19c - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 30 seconds ago) DGMGRL> switchover to lhr19c Performing switchover NOW, please wait... Operation requires a connection to database "lhr19c" Connecting ... Connected to "lhr19c" Connected as SYSDBA. New primary database "lhr19c" is opening... Operation requires start up of instance "lhr19cdg" on database "lhr19cdg" Starting instance "lhr19cdg"... Connected to an idle instance. ORACLE instance started. Connected to "lhr19cdg" Database mounted. Database opened. Connected to "lhr19cdg" Switchover succeeded, new primary is "lhr19c" DGMGRL> show configuration Configuration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database Fast-Start Failover: Disabled Configuration Status: SUCCESS (status updated 56 seconds ago)
内容总结
以上是互联网集市为您收集整理的oracle 19c使用dgmgrl来执行switchover和failover切换全部内容,希望文章能够帮你解决oracle 19c使用dgmgrl来执行switchover和failover切换所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。