oracle 19c使用dgmgrl來執行switchover和failover切換
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)
About Me
........................................................................................................................ ● 本文作者:小麥苗,部分內容整理自網路,若有侵權請聯絡小麥苗刪除 ● 本文在itpub、部落格園、CSDN和個人微 信公眾號( xiaomaimiaolhr )上有同步更新 ● 本文itpub地址: http://blog.itpub.net/26736162 ● 本文部落格園地址: http://www.cnblogs.com/lhrbest ● 本文CSDN地址: https://blog.csdn.net/lihuarongaini ● 本文pdf版、個人簡介及小麥苗雲盤地址: http://blog.itpub.net/26736162/viewspace-1624453/ ● 資料庫筆試面試題庫及解答: http://blog.itpub.net/26736162/viewspace-2134706/ ● DBA寶典今日頭條號地址: http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826 ........................................................................................................................ ● 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 ● 文章內容來源於小麥苗的學習筆記,部分整理自網路,若有侵權或不當之處還請諒解 ● 版權所有,歡迎分享本文,轉載請保留出處 ........................................................................................................................ ● 小麥苗的微店 : https://weidian.com/s/793741433?wfr=c&ifr=shopdetail ● 小麥苗出版的資料庫類叢書 : http://blog.itpub.net/26736162/viewspace-2142121/ ● 小麥苗OCP、OCM、高可用網路班 : http://blog.itpub.net/26736162/viewspace-2148098/ ● 小麥苗騰訊課堂主頁 : https://lhr.ke.qq.com/ ........................................................................................................................ 使用 微 信客戶端 掃描下面的二維碼來關注小麥苗的微 信公眾號( xiaomaimiaolhr )及QQ群(DBA寶典)、新增小麥苗微 信, 學習最實用的資料庫技術。
........................................................................................................................ |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26736162/viewspace-2653934/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【dgmgrl】使用dgmgrl做switchover切換報錯ORA-16501, ORA-16625等
- Oracle 10g DataGuard物理主備切換-switchover與failoverOracle 10gAI
- openGauss主備切換之switchover與failoverAI
- MySQL高可用之MHA切換測試(switchover & failover)MySqlAI
- Oracle DataGuard switchover切換一例Oracle
- 【DataGuard】使用Grid Control對Oracle物理Data Guard進行Switchover切換Oracle
- Oracle DataGuard 主備切換 (switchover) oracle11gOracle
- Oracle Failover - TAF 透明應用切換OracleAI
- switchover和failover的區別AI
- 再次使用DGbroker做switchover主備切換
- 主備切換(failover)AI
- Dataguard failover切換實驗AI
- 【DATAGUARD】物理dg的switchover切換(五)
- DATA GUARD物理STANDBY的 SWITCHOVER切換
- RAC環境STANDBY的SWITCHOVER切換
- 淺談linux執行緒模型和執行緒切換Linux執行緒模型
- 【DG】DG之Switchover和Failover的區別AI
- 【DG】Data Guard主備庫Switchover切換
- DATA GUARD物理備庫的SWITCHOVER切換
- DATA GUARD物理STANDBY的 SWITCHOVER切換[zt]
- In Data Guard,choose switchover or failover?AI
- oracle 9iDATA GUARD物理STANDBY的 SWITCHOVER切換步驟Oracle
- [Android]使用ActivityGroup來切換Activity和LayoutAndroid
- 備庫的切換狀態為SWITCHOVER PENDING時進行dataguard主備庫角色切換
- dataguard之物理standby庫failover 切換AI
- RAC環境STANDBY的FAILOVER切換AI
- 物理Standby角色切換作業failoverAI
- 【DATAGUARD】物理dg的failover切換(六)AI
- DATA GUARD物理STANDBY的FAILOVER切換AI
- failover切換後恢復原來主庫為新備庫AI
- 程式執行緒篇——執行緒切換(下)執行緒
- 程式執行緒篇——執行緒切換(上)執行緒
- Oracle 12c Data guard 物理主備庫正常切換(switchover)流程Oracle
- Oracle 11g Data guard 物理主備庫正常切換(switchover)流程Oracle
- DataGuard---->物理StandBy的角色切換之switchover
- 單節點DG的switchover切換介紹
- RAC環境的物理STANDBY的 SWITCHOVER切換
- RAC環境LOGICAL STANDBY的SWITCHOVER切換