Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.