Re: different service names on Standby
Date: Thu, 28 Aug 2014 08:05:17 +0200
Message-ID: <CA+S=qd3NCANsaZc8BdJvEM9N6txXkt76sRp6aMZa_4iq0vaGMg_at_mail.gmail.com>
We do have a different service name on the physical standby. The reason is it is in "snapshot standby mode" during the day.
Our setup har three servers: db1, db2, db3
And three service names: dbP ("P"roduction), dbR ("R"eadonly), dbS
("S"andbox)
Normally dbP runs on db1, dbR on db2 and dbS on db3
One primary and two dataguard:
Service dbP is the primary.
Service dbR is Active DataGuard - failover as well as some queries for
reporting and extracting for dw
Service dbS is at 1AM switched to Physical Standby and at 5AM switched to
Snapshot Standby - test and training during the day, "refreshed" to a clone
of production during the night
But a DataGuard server that is Physical Standby all the time? I can't offhand think of a reason for seperate service name? Unless for management purposes?
Regards
Kim Berg Hansen
http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha
On Thu, Aug 28, 2014 at 5:38 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com> wrote:
> Just curious here ....
>
> Other than for Active DataGuard ...
>
> Would you define **different** service names on a Physical Standby ?
> (i.e. service names that are not defined on the Primary).
>
> Can you ? Why would you ?
>
> (Active DataGuard I can understand : Useful to use a different service
> name for Query sessions).
>
> Hemant K Chitale
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 28 2014 - 08:05:17 CEST