https://doyensys.com/blogs/solved-ora-16057-server-not-in-data/
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..
