ORA-16057 DGID from server not in Data Guard configuration

Solution:

Make sure log_archive_config parameter have correct db_unique_name for both primary and standby in both primary and standby database.

 

Example:

1.      In primary database db_unique_name is tsm1_dg and in standby database db_unique_name is tsm2_dg then log_archive_config should be

log_archive_config='dg_config=(tsm1_dg,tsm2_dg)'

set it if it’s not set or if you have wrong value there . I got this error in primary database so describe here how I fixed that in primary database.

SQL> alter system set log_archive_config='dg_config=(tsm1_dg,tsm2_dg)';

 

2.      Make sure your log_archive_dest_x is enable and have proper value

alter system set log_archive_dest_3='service="(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = stagedb6.ipx.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = tsm2_dg_DGMGRL.ipx.com)(SERVER = DEDICATED)))"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="tsm2_dg"','valid_for=(all_logfiles,primary_role)';

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_3=ENABLE;

3.      Execute following query before check:

SQL> alter system log switch;

 or

SQL> alter system archive log current;

4.      Check error is clear or not

SELECT DEST_ID "ID",

STATUS "DB_status",

DESTINATION "Archive_dest",

ERROR "Error"

FROM V$ARCHIVE_DEST WHERE DEST_ID <=5;

Comments