【dgmgrl】使用dgmgrl做switchover切換報錯ORA-16501, ORA-16625等
【dgmgrl】使用dgmgrl做switchover切換報錯ORA-16501, ORA-16625, DGM-17017,DGM-17016
Database Status:
DGM-17016: failed to retrieve status for database "oradgphy"
ORA-16501: the Data Guard broker operation failed
ORA-16625: cannot reach database "oradgphy"
解決:After a Dataguard Broker switchover, the "show configuration" command returns errors ORA-16501, ORA-16625, DGM-17017 and "Fast-Start Failover: DISABLED" (文件 ID 1484542.1)
用grid使用者把oracle使用者下的tnsnames.ora檔案拷貝到grid使用者下就可以了,
cp /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora /u01/app/grid/11.2.0/network/admin/tnsnames.ora
After a Dataguard Broker switchover, the "show configuration" command returns errors ORA-16501, ORA-16625, DGM-17017 and "Fast-Start Failover: DISABLED" (文件 ID 1484542.1) |
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
SYMPTOMS
A dataguard broker is being used to manage a standby database environment. A switchover operation is performed, for example:
DGMGRL> switchover to chicago;
Performing switchover NOW, please wait...
New primary database "chicago" is opening...
Operation requires shutdown of instance "newyork" on database "newyork"
Shutting down instance "newyork"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "newyork" on database "newyork"
Starting instance "newyork"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "chicago"
Afterwards the Dataguard command "show configuration" returns errors ORA-16501, ORA-16625, DGM-17017 and "Fast-Start Failover: DISABLED", for example:
DGMGRL> show configuration
...
Fast-Start Failover: DISABLED
Configuration Status:
ORA-16501: the Data Guard broker operation failed
ORA-16625: cannot reach database "newyork"
DGM-17017: unable to determine configuration status
...
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
In SQLPlus we can see that the standby database is running. Stopping the standby database via sqlplus with "shutdown immediate" and then restarting the standby with srvctl command works around the issue.
SQL> shutdown immediate
$ srvctl start database -d newyork
CAUSE
The tnsnames.ora was not present in $GRID_HOME directory, namely in $GRID_HOME/network/admin
SOLUTION
Make sure the tnsnames.ora file is present in $GRID_HOME/network/admin directory; For example copy the tnsnames.ora file from the $ORACLE_HOME/network/admin to $GRID_HOME/network/admin
About Me
........................................................................................................................ ● 本文作者:小麥苗,部分內容整理自網路,若有侵權請聯絡小麥苗刪除 ● 本文在itpub( http://blog.itpub.net/26736162 )、部落格園( http://www.cnblogs.com/lhrbest )和個人weixin公眾號( xiaomaimiaolhr )上有同步更新 ● 本文itpub地址: http://blog.itpub.net/26736162 ● 本文部落格園地址: http://www.cnblogs.com/lhrbest ● 本文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 ● weixin 群:可加我 weixin ,我拉大家進群,非誠勿擾 ● 聯絡我請加QQ好友 ( 646634621 ) ,註明新增緣由 ● 於 2018-08-01 06:00 ~ 2018-08-31 24:00 在魔都完成 ● 最新修改時間:2018-08-01 06:00 ~ 2018-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/ ........................................................................................................................ 使用 weixin 客戶端 掃描下面的二維碼來關注小麥苗的 weixin 公眾號( xiaomaimiaolhr )及QQ群(DBA寶典)、新增小麥苗 weixin , 學習最實用的資料庫技術。
........................................................................................................................ |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26736162/viewspace-2200090/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 19c使用dgmgrl來執行switchover和failover切換OracleAI
- 6 使用DGMGRL命令列的場景命令列
- 再次使用DGbroker做switchover主備切換
- ora11_node_dg(2)ADG做(switchover)切換測試
- Oracle DataGuard switchover切換一例Oracle
- 【DATAGUARD】物理dg的switchover切換(五)
- DATA GUARD物理STANDBY的 SWITCHOVER切換
- RAC環境STANDBY的SWITCHOVER切換
- FAL_SERVER設定錯誤導致SWITCHOVER切換HANG住Server
- 【DG】Data Guard主備庫Switchover切換
- DATA GUARD物理備庫的SWITCHOVER切換
- DATA GUARD物理STANDBY的 SWITCHOVER切換[zt]
- Unable To Recreate DG Fast Start Failover Configuration With DGMGRL-454418.1ASTAI
- DataGuard---->物理StandBy的角色切換之switchover
- 單節點DG的switchover切換介紹
- RAC環境的物理STANDBY的 SWITCHOVER切換
- RAC環境LOGICAL STANDBY的SWITCHOVER切換
- [DGMGRL]ORA錯誤解決(ORA-16829: fast-start failover configuration is lagging)ASTAI
- Oracle DataGuard 主備切換 (switchover) oracle11gOracle
- DATAGUARD在做SWITCHOVER切換時遇到問題總結
- openGauss主備切換之switchover與failoverAI
- 應用dgmgrl實現fast_start failover後,客戶端tns的配置ASTAI客戶端
- MySQL高可用之MHA切換測試(switchover & failover)MySqlAI
- 9204RAC到單例項的SWITCHOVER切換單例
- 物理dataguard 正常切換 角色轉換,switchover_status 狀態改變
- 【DataGuard】使用Grid Control對Oracle物理Data Guard進行Switchover切換Oracle
- 物理dataguard 正常切換 腳色轉換,switchover_status 狀態改變
- 備庫的切換狀態為SWITCHOVER PENDING時進行dataguard主備庫角色切換
- Appium用driver.start_activity切換Activity報錯APP
- Oracle 10g DataGuard物理主備切換-switchover與failoverOracle 10gAI
- dataguard手動switchover切換步驟及注意的問題 轉
- oracle 9iDATA GUARD物理STANDBY的 SWITCHOVER切換步驟Oracle
- 【DataGuard】10g物理standby主備switchover方式切換詳述
- hexo切換主題後hexo-theme-landscape報錯Hexo
- Oracle 12c Data guard 物理主備庫正常切換(switchover)流程Oracle
- Oracle 11g Data guard 物理主備庫正常切換(switchover)流程Oracle
- dataguard角色轉換—switchover
- linux 切換使用者報Resource temporarily unavailableLinuxAI