PING[ARC1]: Heartbeat failed to connect to standby ‘teststby’. Error is 16057.

Melek Durdu

2 years ago

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.

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

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.

SQL> alter system set log_archive_config='dg_config=
(TESTDB,TESTSTBY)';

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.

SQL> alter system set log_archive_dest_state_2=defer;
SQL> alter system set log_archive_dest_state_2=enable;

1 2	SQL> alter system set log_archive_dest_state_2=defer; SQL> alter system set log_archive_dest_state_2=enable;