PING[ARC2]: Heartbeat failed to connect to standby ' GQTZDB_DG '. Error is 16047

After the Data guard is set up, the Open Archive path 2 is executed, and the results are found to be out of sync

Sql> alter system set log_archive_dest_state_2=enable;

Check the error log and find Ping[arc2]: Heartbeat failed to connect to standby ' GQTZDB_DG '. Error is 16047. Error:

[Email protected] trace]$ tail-100f alert_gqtzdb.log Mon Jul 18:19:10Using standby_archive_dest paramete R default Value as/oradata/gqtzdb/archivelogalter SYSTEM SET log_archive_dest_state_2= ' ENABLE ' scope=BOTH; Mon Jul 18:19:10Ping[arc2]: Heartbeat failed to connect to standby ' GQTZDB_DG '. Error is 16047.    

Then look at the V$archive_dest view to see if you can find the cause and find the following error:

Sql> Select Dest_id,error from v$archive_dest;   dest_id ERROR---------------------------------------------------------------------------         1         2 ORA-16047: Dgid mismatch between destination setting and target           database 

Obviously, Dgid is not the same, go to the library. View parameter Db_unique_name parameters:

sql> Show parameter db_unique_namename                                 TYPE        VALUE------------------------------------------------- ----------------------------db_unique_name                       string      gqtzdb

found that the Db_unique_name parameter is not modified, is still the value of the main library, speed change, and restart the library:

Sql> alter system set Db_unique_name= ' GQTZDB_DG ' scope=both;alter system set db_unique_name= ' GQTZDB_DG ' scope=both< C0/>*error at line 1:ora-02095:specified initialization parameter cannot be modifiedsql> alter system set DB_UNIQUE_NA Me= ' GQTZDB_DG ' scope=spfile; System altered.

Then open Archive path 2 in the main library, run the command in the standby to view the synchronization status:

sql> ALTER DATABASE recover managed standby database using current logfile disconnect from session;database alt Ered. Sql> Select Process,client_process,sequence#,status from v$managed_standby; PROCESS   client_p  sequence# STATUS---------------------------------------Arch      arch              0  Connectedarch      Arch              0 connectedarch      arch              0 connectedarch Arch 0 Connectedrfs UNKNOWN 0 idlerfs lgwr idlerfs UNKNOWN 0 idlerfs UNKNOWN 0 IDLEMRP0 N/a applying_log9 rows selected .

PING[ARC2]: Heartbeat failed to connect to standby ' GQTZDB_DG '. Error is 16047