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.
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:
Thank you, it helped me.
Post a Comment