PROVIDING INNOVATIVE
SOLUTIONS AROUND
ORACLE PLATFORM

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco lab

PROVIDING INNOVATIVE
SOLUTIONS AROUND
ORACLE PLATFORM

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco lab

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