ORA-16057: server not in Data Guard configuration

Error:  ORA-16057: server not in Data Guard configuration

Solution:  Make sure your log_archive_config and log_archive_dest_2 parameters are set on both Primary and Standby Databases.

In my case:

  1. alter system set log_archive_config=’dg_config=(PROD,PROD_stby)’;
  2. alter system set log_archive_dest_2=’service=PROD_stby lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=PROD_stby’;

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)