Get the App
SLTechnology News&Howtos  ›  Database  › 

Oracle dg error: ORA-16057: DGID from server not in Data Guard configuration

Shulou Source: shulou.com Published: 2022-06-01 18:34:08 11月16日 Update

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.

Tags: Configuration error comprehensive obvious parameter meaning log activation work Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MySQL Microsoft Shulou Technology Linux NVidia