Oracle DG ERROR: Ora-16057:dgid from server not in Data Guard configuration

After the DG is set up, it is found that the repository does not accept logs from the main library.

Executing in the main library

Select dest_id,status,error from V$archive_dest where dest_id=3;

Report: Ora-16057:dgid from server not in Data Guard configuration

The meaning of the error is obvious, Log_archive_config is not configured

But I've configured it in the main library.

alter system set Log_archive_config = ' dg_config= (itrusdb,jingxiang) ' Scope=both;

Pass

ALTER SYSTEM SET log_archive_dest_state_3= ' DEFER ' Scope=both;

ALTER SYSTEM SET log_archive_dest_state_3= ' ENABLE ' Scope=both;

New activating archive_dest in the afterlife;

Errors are still found.

Originally.. Originally... I forgot to configure log_archive_config this parameter in the standby library.

Pass

alter system set Log_archive_config = ' dg_config= (itrusdb,jingxiang) ' Scope=both;

After the standby is configured, the DG works correctly.

Hope that we will work, think of a more comprehensive, don't figure fast. Avoid these unnecessary errors.

This article is from the "Li_weikang" blog, make sure to keep this source http://liweikang.blog.51cto.com/3246878/1589405

Oracle DG ERROR: Ora-16057:dgid from server not in Data Guard configuration