Friday, December 7, 2018

ORA-16053: DB_UNIQUE_NAME ORCL_STBY is not in the Data Guard Configuration with ORA-02097 error

The ORA-02097 is very generic error you need to check following error message to understand the issue.

ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16053: DB_UNIQUE_NAME ORCL _STBY is not in the Data Guard Configuration
In my case I am trying to update DB_UNIQUE_NAME but it is failed, because the specified DB_UNIQUE_NAME is not in the Data Guard Configuration.

Before you update DB_UNIQUE_NAME parameter make sure LOG_ARCHIVE_CONFIG is enabled and it has valid DB_UNIQUE_NAME.

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORCL,ORCL_STDBY)'

You can find list of valid DB_UNIQUE_NAMEs in V$DATAGUARD_CONFIG view

Thanks,
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com
Posted by at
Labels: , , , , , , , ,

4 comments:

  1. 10th textbooksJune 7, 2022 at 3:15 AM

    Telangana Intermediate Model Question Papers 2023 will be released by the Telangana Board of Education on April 20, 2023, and will be available on the board's official website. Students may obtain Telangana Intermediate 12th Model Question Paper 2023 by going to the board's official website. TS 12th Blueprint 2023 TS Intermediate Exam Paper The TSBIE Telangana 2nd Intermediate Model Question Paper 2023 has been published on the official website of the board. Students may get their Telangana Intermediate Model Question Paper 2023 by going to the official website. 2023 TS 12th Blueprint 2023 TS Inter Model Paper Exam Pattern for TS Inter 2023.

    ReplyDelete
  2. keven johnAugust 1, 2022 at 6:35 AM

    I have learned alot of things in this blog.This is really helpful and informative for me.If you are looking to buy an online thesis topics in economics service.You can easily make a call and easily contact with our team.

    ReplyDelete
  3. jamesFebruary 7, 2023 at 9:31 AM

    I have learned alot of things in this blog.This is really helpful and informative for me.If you are looking to buy an online polo men tshirts latest collection at an affordable and reasonble price.

    ReplyDelete
  4. will59_cruiseMay 23, 2023 at 3:49 AM

    When you buy Cenforce 150mg, you will receive an oral medication that is effective in treating erectile dysfunction. It contains sildenafil citrate, which is the same active ingredient as Viagra. It is manufactured by Centurion Laboratories, an Indian pharmaceutical company that specializes in producing generic drugs. It is a phosphodiesterase type 5 inhibitor and can be purchased from online pharmacies.
    Read More: Cenforce 100mg

    ReplyDelete

Subscribe to: Post Comments (Atom)