ORA-16191: Primary log shipping client not logged on standby
Oracle 11gR2 . 多節點主RAC DB, 多節點rac standby . 在做switchover後發現一個例項的redo傳輸有問題,報錯 :
ORA-16191: Primary log shipping client not logged on standby
需要檢查主庫與備庫之前的密碼檔案是否一致(或密碼檔案根本沒有複製到standby其他節點) , 還有就是remote_login_
passwordfile必須是 exclusive .
經過診斷,發現是原standby節點2 沒有被複製主節點的 orapwSID 檔案,導致sys不一致而不能使用,報錯。
ORA-16191: Primary log shipping client not logged on standby
需要檢查主庫與備庫之前的密碼檔案是否一致(或密碼檔案根本沒有複製到standby其他節點) , 還有就是remote_login_
passwordfile必須是 exclusive .
經過診斷,發現是原standby節點2 沒有被複製主節點的 orapwSID 檔案,導致sys不一致而不能使用,報錯。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-2123102/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle DG ORA-16191: Primary log shipping client not logged on standbyOracleclient
- [Dataguard]ORA-16191: Primary log shipping client not logged on standby問題解決client
- SQL Server實現Standby --日誌傳送(Log Shipping)SQLServer
- 配置 Oracle 10g RAC primary + RAC logical standbyOracle 10g
- oracle10g R2 logical standby switchover to primaryOracle
- standby database to primary database.Database
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Case One -- Recover a datafile in primary site from the backup taken in standby site using catalog d
- 判斷standby日誌是否同步primary
- GoldenGate的Primary-Standby切換Go
- Creating a physical standby from ASM primaryASM
- How to Perform SQL Server Log ShippingORMSQLServer
- standby缺失primary歸檔,手工同步恢復
- [轉載]Log Shipping Operations GuideGUIIDE
- 【DATAGUARD 學習】監控primary庫和standby庫
- Creating a physical standby from ASM primary [ID 787793.1]ASM
- DG物理standby,Failover之後原primary重回DGAI
- 配置 Oracle 10g RAC primary + RAC physical standby dataguardOracle 10g
- Oracle 12C RAC的單機Standby returning error ORA-16191OracleError
- Sskgxp_ip: Primary Interface Down In Alert Log
- dataguard 搭建 oracle_sid不同 2節點 primary+standbyOracle
- dataguard 搭建 oracle_sid相同 2節點 primary+standbyOracle
- 【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之一ASM
- standby redo log的理解
- 建立 Logical Standby DatabaseDatabase
- manage logical standby databaseDatabase
- DataGuard:Logical Standby Switchover
- 認識SQL Server2000 Log Shipping 【zt】SQLServer
- log shipping配置的時候碰到Error 3201Error
- 物理Standby資料庫及邏輯Standby資料庫(Physical Standby & Logical Standby)資料庫
- sqlserver關於日誌傳輸log shipping的總結SQLServer
- ORA-01012: not logged on 解決辦法
- Scripts to resize standby redolog files
- DataGuard:Logical Standby FailoverAI
- 監控Logical standby databaseDatabase