DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, October 24, 2016

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..