ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Problem:
data guard configuration throws error
on primary
DGMGRL> ADD DATABASE stby AS CONNECT IDENTIFIER IS stby MAINTAINED AS PHYSICAL;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Failed.
Solution:
Save log_Archive_dest_2 old value and reset on both Primary and Standby
alter system set log_archive_dest_2=” scope=both sid=’*’;
## Add database again in dgmgrl
DGMGRL> ADD DATABASE stby AS CONNECT IDENTIFIER IS stby MAINTAINED AS PHYSICAL;
## put old value back on log_archive_dest_2 both primary and standby
#on primary
alter system set log_Archive_dest_2=’SERVICE=stby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stby REOPEN=60′ scope=both sid=’*’;
#on standby
alter system set log_Archive_dest_2=’SERVICE=prmy LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prmy REOPEN=60′ scope=both sid=’*’;