PING[ARC2]: Heartbeat failed to connect to standby 'xyxdbs'. Error is 1605
今天重啟了一臺測試庫備庫,發現備庫資料庫歸檔無法接收,主庫的日誌報以以錯誤
PING[ARC2]: Heartbeat failed to connect to standby 'xyxdbs'. Error is 1605
查詢主庫
SQL> select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;
DEST_ID ERROR
---------- -----------------------------------------------------------------
STATUS LOG_SEQUENCE APPLIED_SCN
--------- ------------ -----------
2 ORA-16057: server not in Data Guard configuration
ERROR 211 5446747
透過metlink(文件 ID 827954.1)查詢到可能原因是db_unique_name或者是 log_archive_config配置錯誤
查詢備庫引數
SQL> sho parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(xyxdbp,xyxdbs)
這裡指定的是主庫備庫的db_unique_name
備庫操作
SQL> alter system set log_archive_config='DG_CONFIG=(xyxdb,xyxdbs)';
修改後
主庫操作
SQL> alter system set log_archive_dest_state_2=defer;
System altered.
SQL> alter system set log_archive_dest_state_2=enable;
System altered.
SQL> select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;
DEST_ID ERROR
---------- -----------------------------------------------------------------
STATUS LOG_SEQUENCE APPLIED_SCN
--------- ------------ -----------
2
VALID 215 5447429
總結:這次是由於修改引數的時候未儲存到spfile重啟的的時候直接從spfile導致此錯誤,配置一定要仔細
PING[ARC2]: Heartbeat failed to connect to standby 'xyxdbs'. Error is 1605
查詢主庫
SQL> select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;
DEST_ID ERROR
---------- -----------------------------------------------------------------
STATUS LOG_SEQUENCE APPLIED_SCN
--------- ------------ -----------
2 ORA-16057: server not in Data Guard configuration
ERROR 211 5446747
透過metlink(文件 ID 827954.1)查詢到可能原因是db_unique_name或者是 log_archive_config配置錯誤
查詢備庫引數
SQL> sho parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string DG_CONFIG=(xyxdbp,xyxdbs)
LOG_ARCHIVE_CONFIG
Property | Description |
---|---|
Parameter type |
String |
Syntax |
{ [ SEND | NOSEND ] [ RECEIVE | NORECEIVE ] [ DG_CONFIG=(remote_db_unique_name1 [, ... remote_db_unique_name30) | NODG_CONFIG ] } |
Default value |
|
Modifiable |
|
Basic |
No |
LOG_ARCHIVE_CONFIG
enables or disables the sending of redo logs to remote destinations and the receipt of remote redo logs, and specifies the unique database names (DB_UNIQUE_NAME
) for each database in the Data Guard configuration.
備庫操作
SQL> alter system set log_archive_config='DG_CONFIG=(xyxdb,xyxdbs)';
修改後
主庫操作
SQL> alter system set log_archive_dest_state_2=defer;
System altered.
SQL> alter system set log_archive_dest_state_2=enable;
System altered.
SQL> select dest_id,error,status,log_sequence,applied_scn from v$archive_dest where dest_id=2;
DEST_ID ERROR
---------- -----------------------------------------------------------------
STATUS LOG_SEQUENCE APPLIED_SCN
--------- ------------ -----------
2
VALID 215 5447429
總結:這次是由於修改引數的時候未儲存到spfile重啟的的時候直接從spfile導致此錯誤,配置一定要仔細
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24486203/viewspace-1801948/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 12541AIError
- PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.AIError
- PING[ARC5]: Heartbeat failed to connect to standby 'dghq'. Error is 12154.AIError
- 一天兩次,PING[ARC1]: Heartbeat failed to connect to standbyAI
- Oracle ADG Heartbeat failed to connect to standby故障案例OracleAI
- 主庫報 Error 12154 received logging on to the standby PING[ARC2]Error
- Ping:Transmit Failed, Error Code 65問題解決MITAIError
- 【ERROR】OPatch failed with error code 73ErrorAI
- [ERROR] Failed to open logErrorAI
- OPatch failed with error code 73AIError
- 【遠端除錯】Failed to connect to remote VM除錯AIREM
- [ CSSCLNT][1]clsssInitNative: connect failed, rc 9CSSAI
- Fatal NI connect error 12170Error
- Error: failed PB timebomb checkErrorAI
- Starting HEARTBEAT with WARNING: string2msg_ll: node [... ] failed authenticationAI
- Xtrabackup備份報錯Failed to connect to MySQL serverAIMySqlServer
- Fatal NI connect error 12170.Error
- 虛擬機器之間能夠ping通,但是建立tcp連線時卻顯示Failed in connect to TCP server: No route to host虛擬機TCPAIServer
- maridb Error 'Operation DROP USER failed forErrorAI
- Opiino: Attach Failed! Error=-1 Ifvp=0AIError
- Failed to connect to raw.githubusercontent.com port 443AIGithub
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Fatal NI connect error 12170 錯誤Error
- FATAL - Fatal error: Target Interaction Manager failed at StartupErrorAI
- Android 3.0 DELETE_FAILED_INTERNAL_ERRORAndroiddeleteAIError
- pod update -- Failed to connect to GitHub to update the CocoaPods/Specs specs repoAIGithub
- ubuntu gedit出錯:Failed to connect to the session manager的問題UbuntuAISession
- 執行flutter run命令報錯::ERROR: Could not connect to lockdownd, error code -17FlutterError
- Error: Connection activation failed: Device not managed by NetworkManagerErrorAIdev
- ERROR: Failed to resolve: org.greenrobot:eventbus:2.4.0ErrorAI
- weblogic報錯: OPatch failed with error code 73WebAIError
- OPatch failed with error code 73(OracleHomeInventory gets null oracleHomeInfo)AIErrorOracleNull
- LOGIN:ERROR-Failed to initialize policy manager(轉)ErrorAI
- "OPatch failed with error code 73"故障一例AIError
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- git error: RPC failed; HTTP 500 curl 22 The requested URL returned error: 500GitErrorRPCAIHTTP
- AS編譯不通過,提示Error:Connection refused: connect編譯Error
- ORA-00257: archiver error. Connect internal onlyHiveError