Oracle dg error: ORA-16057: DGID from server not in Data Guard configuration
After building the DG, it is found that the standby database has not received the logs of the main database.
Execute 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
It is obvious that log_archive_config is not configured.
But I have already configured the main library.
Alter system set log_archive_config = 'dg_config= (itrusdb,jingxiang)' scope=both
Pass through
ALTER SYSTEM SET log_archive_dest_state_3='DEFER'SCOPE=BOTH
ALTER SYSTEM SET log_archive_dest_state_3='ENABLE'SCOPE=BOTH
New activation of archive_dest in the afterlife
And found that the mistake is still the same.
It turns out. It turns out. I forgot to configure the parameter log_archive_config in the repository.
Pass through
Alter system set log_archive_config = 'dg_config= (itrusdb,jingxiang)' scope=both
After the repository has been configured, dg works normally.
I hope everyone will do things in the future, think more carefully, and don't try to be quick. Avoid these unnecessary mistakes.