Wednesday, March 25, 2020

ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set

I have come across issue when adding Standby Database during Data Guard broker config

DGMGRL> create configuration 'ORCLT' as primary database is 'ORCLT' connect identifier is ORCLT;
Configuration "ORCLT" created with primary database "ORCLT"
DGMGRL> add database 'ORCLT_STDBY' as connect identifier is ORCLT_STDBY maintained as physical;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set

I have not seen this issue on older versions, after research found that there are few changes from Oracle 12c. We have to unset LOG_ARCHIVE_DEST_2 parameter as DGMGRL will take care of updating this parameter.

I have followed below steps

1. Disable and Remove Data Guard configuration

DGMGRL> disable configuration;
DGMGRL> remove configuration;

2. Disable/Enable Data Guard broker on both Primary/standby

SQL> alter system set dg_broker_start=false scope=both;
SQL> alter system set dg_broker_start=true scope=both;

3. Disable log_archive_dest_2 on both Primary/standby
SQL> alter system set log_archive_dest_2'' scope=both;

4. Configure Data Guard Broker

DGMGRL> create configuration ‘orclt_dg’ as primary database is 'ORCLT' connect identifier is ORCLT;
Configuration "ORCLT" created with primary database "ORCLT"
DGMGRL> add database 'ORCLT_STDBY' as connect identifier is ORCLT_STDBY maintained as physical;
DGMGRL> Database 'ORCLT_STDBY' added
DGMGRL> enable configuration;
Enabled.

DGMGRL> show configuration;
Configuration – orclt_dg
Protection Mode: MaxPerformance
Members:
orclt - Primary database
orclt_stdby - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:

SUCCESS (status updated 46 seconds ago)

Regards,
Satishbabu Gunukula, Oracle ACE

4 comments:

  1. With ourEscorts Service in Ahmedabadand escorts services, you may really improve stage of fun by its quality services different. Sure! This assists its people to victory over all the gloom and depressive disorders from your lifestyle and appeases your delicate wishes specifically.So, you may do a trip at web page and can get your wish suggested with an outstanding woman escort. Check our other services also...
    Escorts Service in Ahmedabad
    Escorts service in Ahmedabad
    Escorts Service in Ahmedabad
    Escorts Service in Ahmedabad, Gujarat
    Escorts Service in Aishbagh, Lucknow
    Escorts Service in Ajmer
    Escorts Service in Alamnagar, Lucknow
    Escorts Service in Aliganj, Lucknow

    ReplyDelete
  2. MSBSHSE will release the Important Question Paper 2023 for the 2023 Maharashtra Board HSC Exam. The MSBSHSE 12th Board Model Question Paper 2023 will be available on the Maharashtra State Board of Secondary and Higher Secondary Education's official website,Maha HSC Question Paper 2023 The HSC Model Question Paper 2023 for the Exam will be released by MSBSHSE in the month of May 2023. It is advised that students wait till May to get the Maharashtra HSC Model Question Paper 2023 from March. The Board will formally declare the 2023 Maharashtra Board HSC Model Question Paper.

    ReplyDelete