Monday, 13 July 2015

Oracle Data Guard config ORA-16057: server not in Data Guard configuration

During Oracle Data Gaurd Configuration at the post config the logs are not shipping to the DR site.

While checking "gv$archive_dest" view getting below error.

select error from gv$archive_dest where dest_id=2;
ERROR                                                             
-------------------------------

ORA-16057: server not in Data Guard configuration                 

Diag:

I see log_archive_config was empty.

SQL> show parameter log_archive_config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string

Solution:
After updating log_archive_config the archive logs started shipping.

SQL> alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(SIDPROD,SIDSTD)'scope=both sid='*';

System altered.

SQL> show parameter log_archive_config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string      DG_CONFIG=(SIDPROD,SIDSTD)

SQL>select error,Status from gv$archive_dest where dest_id=2;

ERROR                                                             STATUS
-------------------------- ---------
                                                                  VALID

SQL>

1 comment: