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