High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Physical standby - Same SID

Hi All

We have a question related to ORACLE_SID / INSTANCE_NAME  viz-a-viz standby database

As\suming that we have primary database with SID / SERVICE_NAME = ORCL , DB_NAME and DB_UNIQUE_NAME are also ORCL

The tnsnames entry for this database wold have SERVICE_NAME=ORCL and all is fine

Now, if we create a physical standby database on a different server, we know that DB_UNIQUE_NAME cannot be ORCL

so we will call it ORCLDR. DB_NAME would be ORCL but the question is, that can we use the same SERVICE_NAME as production?

I mean when we do the ps-ef|grep smon on primary and standby.. it shows us the same values (e.g smon_orcl)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center