Skip to Main Content
  • Questions

  • ORACLE_SID setting for databases in standby configuration

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Dejan.

Asked: December 04, 2024 - 1:01 pm UTC

Last updated: December 09, 2024 - 1:43 pm UTC

Version: EE 19.23

Viewed 1000+ times

You Asked

Kindly ask for Your opinion regarding ORACLE_SID setting of databases in standby configuration ..

We have different settings in our standby databases and both configurations are working without any complains.

• ORACLE_SID = db_unique_name ( ORACLE_SID in primary is different from ORACLE_SID in standby database )
• ORACLE_SID = db_name ( ORACLE_SID in primary is equal to ORACLE_SID in standby database )

What would be the advatage or downside of one or another configuraation .. ?


Regards Dejan

and Connor said...

Go with the latter, because that is the support (modern) way of doing so.

In particular, for graceful switchover, then you want primary/standby database names to be the same (and thus only differentiated by db_unique_name)


https://docs.oracle.com/en/database/oracle/oracle-database/23/sbydb/creating-oracle-data-guard-physical-standby.html#GUID-A86D403B-B3F5-4B05-9255-5BADD513F9CF

Rating

  (1 rating)

Comments

A reader, December 09, 2024 - 7:22 am UTC

Thank You !!
Connor McDonald
December 09, 2024 - 1:43 pm UTC

glad we could help
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.