本文共 6092 字，大约阅读时间需要 20 分钟。
oracle 19c使用dgmgrl来执行switchover和failover切换
[oracle@raclhr-18c-n1 ~]$ dgmgrl sys/lhr@lhr19cdgDGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Aug 16 16:30:25 2019Version 19.2.0.0.0Copyright (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 configurationConfiguration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database Fast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 13 seconds ago)DGMGRL> switchover to lhr19cdgPerforming 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 configurationConfiguration - lhr19c Protection Mode: MaxPerformance Members: lhr19cdg - Primary database lhr19c - Physical standby database Fast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 62 seconds ago)DGMGRL> failover to lhr19cPerforming failover NOW, please wait...Error: ORA-16600: not connected to target standby database for failoverFailed.Unable to failoverDGMGRL> exit[oracle@raclhr-18c-n1 ~]$ dgmgrl sys/lhr@lhr19cDGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Aug 16 16:33:37 2019Version 19.2.0.0.0Copyright (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 lhr19cPerforming failover NOW, please wait...Failover succeeded, new primary is "lhr19c"DGMGRL> DGMGRL> show configurationConfiguration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database (disabled) ORA-16661: the standby database needs to be reinstatedFast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 28 seconds ago)DGMGRL> reinstate database lhr19cdgReinstating 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" succeededDGMGRL> show configurationConfiguration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database Fast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 32 seconds ago)DGMGRL> switchover to lhr19cdgPerforming 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 configurationConfiguration - lhr19c Protection Mode: MaxPerformance Members: lhr19cdg - Primary database lhr19c - Physical standby database Error: ORA-16541: member is not enabledFast-Start Failover: DisabledConfiguration Status:ERROR (status updated 143 seconds ago)DGMGRL> show configurationConfiguration - lhr19c Protection Mode: MaxPerformance Members: lhr19cdg - Primary database lhr19c - Physical standby database Fast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 30 seconds ago)DGMGRL> switchover to lhr19cPerforming 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 configurationConfiguration - lhr19c Protection Mode: MaxPerformance Members: lhr19c - Primary database lhr19cdg - Physical standby database Fast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 56 seconds ago)
About Me
| ........................................................................................................................ ● 本文作者：小麦苗，部分内容整理自网络，若有侵权请联系小麦苗删除 ● 本文在itpub、博客园、CSDN和个人微 信公众号（ ）上有同步更新 ● 本文itpub地址： ● 本文博客园地址： ● 本文CSDN地址： ● 本文pdf版、个人简介及小麦苗云盘地址： ● 数据库笔试面试题库及解答： ● DBA宝典今日头条号地址： ........................................................................................................................ ● QQ群号： 230161599 （满） 、618766405 ● 微 信群：可加我微 信，我拉大家进群，非诚勿扰 ● 联系我请加QQ好友 （ 646634621 ） ，注明添加缘由 ● 于 2019-08-01 06:00 ~ 2019-08-31 24:00 在西安完成 ● 最新修改时间：2019-08-01 06:00 ~ 2019-08-31 24:00 ● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解 ● 版权所有，欢迎分享本文，转载请保留出处 ........................................................................................................................ ● 小麦苗的微店 ： ● 小麦苗出版的数据库类丛书 ： ● 小麦苗OCP、OCM、高可用网络班 ： ● 小麦苗腾讯课堂主页 ： ........................................................................................................................ 使用 微 信客户端 扫描下面的二维码来关注小麦苗的微 信公众号（ ）及QQ群（DBA宝典）、添加小麦苗微 信， 学习最实用的数据库技术。 ........................................................................................................................ |
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26736162/viewspace-2653934/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/26736162/viewspace-2653934/