Solved ” ORA-16057: server not in Data Guard configuration ” , in oracle dataguard environment

We faced the error ORA-16057 while building a standby database.archives were not shipping to the DR site

Now in the production database,

Select dest_id,error from v$archive_dest;

   DEST_ID ERROR
———- ————————————————————————–
         1
         2
         3
         4  ORA-16057: server not in Data Guard configuration
         5
         6
         7
         8
         9
        10
        11

In our case ,this error is due to wrong configuration in “log_archive_config” parameter in the DR side .
Once we the fixed the parameter “log_archive_config”

sql > alter system set LOG_ARCHIVE_CONFIG=’DG_CONFIG=(prod,standby)’ scope=both;

Now defer and enable the “log_archive_dest_state_4” paramter in production DB.and the logs started shipping to DR without any issues

sql > alter system set log_archive_dest_state_4=DEFER;

sql > alter system set log_archive_dest_state_4=ENABLE;

Now checking again for the error,

Select dest_id,error from v$archive_dest;

   DEST_ID ERROR
———- ————————————————————————-
         1
         2
         3
         4
         5
         6
         7
         8
         9
        10
        11

Hope this helps.. 

  • October 24, 2016 | 33 views