RE: Should Oracle SIDs for the RAC Dataguard match with the Primary Database?

Correct, db_name is same on Primary & Standby.  Db_unique name is different.  I 
use the same service name on Primary & Standby.  When I switchover, stop 
service on Primary & start service (same name) on Standby.  There is a good 
white paper on service names.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jurijs Velikanovs
Sent: Wednesday, June 03, 2009 9:39 PM
To: mjalsingh@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Should Oracle SIDs for the RAC Dataguard match with the Primary 
Database?

Hi Manmohan,

If I remember correctly SID must be the same on both side (db_name the
same in pfiles).
You distinguish between you Prim/Sdby via Service names
(db_unique_name and additional services you create according to you
requirements and an architecture chosen).

Yury

On Thu, Jun 4, 2009 at 3:10 AM, Manmohan Jalsingh <mjalsingh@xxxxxxxxx> wrote:
> Hi,
>
> I have been tasked to setup a RAC physical standby database for a RAC
> primary database. The standby will be on separate RAC servers.
> The environment will be monitored using Grind Control.  I have a question
> regarding choosing the ORACLE_SIDs for the standby database.
> What is the recommendation for choosing them ? Should they be same as
> Primary?  If I choose the same SIDs, will there be any issue
> with monitoring both primary and standby databases in OEM ?
>
> Thanks in advance
> Manmohan
>



-- 
Jurijs
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: