RE: Should Oracle SIDs for the RAC Dataguard match with the Primary Database?
- From: "Sais, Gene" <Gsais@xxxxxxxxxxxxxxxxxxxx>
- To: "'j.velikanovs@xxxxxxxxx'" <j.velikanovs@xxxxxxxxx>, "'mjalsingh@xxxxxxxxx'" <mjalsingh@xxxxxxxxx>
- Date: Thu, 4 Jun 2009 08:21:41 -0400
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
