Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article we will talk about the PING[ARC1]: Heartbeat failed to connect to standby ‘teststby’. Error is 16057.
Error:
PING[ARC1]: Heartbeat failed to connect to standby ‘teststby’. Error is 16057.
Solution:
When querying the primary database as follows, it shows an error related to the Data Guard configuration.
1 2 3 4 5 | 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 | 0| 0 |
It gives an error because the log_archive_config parameter is not set. In the primary database, the log_archive_config parameter is set as follows.
1 2 | SQL> alter system set log_archive_config='dg_config= (TESTDB,TESTSTBY)'; |
We enable the log_archive_dest_state_x parameter so that the primary database can perform redo transfer to Standby.
1 2 | SQL> alter system set log_archive_dest_state_2=defer; SQL> alter system set log_archive_dest_state_2=enable; |
