In primary DATABASE:-
Primary DB:- orclcdb
Standby DB:- orclstd
oracle@primary flashback]$ dgmgrl sys/admin123#@orclcdb
DGMGRL for Linux: Release 19.0.0.0.0 – Production on Mon Apr 13 19:05:31 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type “help” for information.
Connected to “orclcdb”
Connected as SYSDBA.
DGMGRL> CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS orclcdb CONNECT IDENTIFIER IS orclcdb;
DGMGRL>ADD DATABASE orclstd AS CONNECT IDENTIFIER IS orclstd MAINTAINED AS PHYSICAL;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Solution:-
Step 1.Remove the DG Broker configuration .This can be done from primary/standby database server.
DGMGRL> remove configuration;
Removed configuration
DGMGRL>
Step 2. Disable log_archive_dest_2
On Primary:-
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest_2 string service=”orclstd”, ASYNC NOAFF
IRM delay=0 optional compressi
on=disable max_failure=0 reope
n=300 db_unique_name=”orclstd”
net_timeout=30, valid_for=(on
line_logfile,all_roles)
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=” scope=both;
System altered.
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest_2 string
On Standby:-
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest_2 string service=”orclstd”, ASYNC NOAFF
IRM delay=0 optional compressi
on=disable max_failure=0 reope
n=300 db_unique_name=”orclstd”
net_timeout=30, valid_for=(on
line_logfile,all_roles)
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=” scope=both;
System altered.
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest_2 string
Step 3. Disable / Enable DG Broker in primary & standby DB
SQL> alter system set dg_broker_start=false scope=both;
System altered.
SQL> alter system set dg_broker_start=true scope=both;
System altered.
Now start registering the primary and standby database again using data guard broker.
In primary DATABASE:-
.moracle@primary flashback]$ dgmgrl sys/admin123#@orclcdb
DGMGRL for Linux: Release 19.0.0.0.0 – Production on Mon Apr 13 19:05:31 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type “help” for information.
Connected to “orclcdb”
Connected as SYSDBA.
DGMGRL> CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS orclcdb CONNECT IDENTIFIER IS orclcdb;
DGMGRL>ADD DATABASE orclstd AS CONNECT IDENTIFIER IS orclstd MAINTAINED AS PHYSICAL;
Step 5. Enbale LOG_ARCHIVE_DEST_2
On Primary DB:-
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG=’DG_CONFIG=(orclcdb,orclstd)’ scope=both;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’SERVICE=orclstd LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=orclstd’ scope=both;
On Standby DB:-
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG=’DG_CONFIG=(orclcdb,orclstd)’ scope=both;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’SERVICE=orclcdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=orclcdb’ scope=both;
Step 6. Finally Enable DG Broker Configuration
DGMGRL> enable configuration;
Leave a Reply