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)