Re: SRDF and Oracle Rac 11gR2
Date: Mon, 27 Jan 2014 16:18:09 -0500
Message-ID: <CAJ7936yDsN9o2jZBpCW_Ck42gYgi3zD0KWhEMwPR_ZXJT-3fTg_at_mail.gmail.com>
Well, so, this is the eternal debate, yeah? Data Guard offers infinite flexibility, the DBA can control everything, it's storage agnostic, you have lots of knobs to twiddle, so on some levels that's perfect.
On the flip side though, SRDF is application/OS agnostic. Anything that gets written to any SRDF'ed LUN, regardless of database, filesystem, OS, version, etc. ends up on the far side. Like magic.
And SRDF is freakishly stable and mature. It's been baked and stable for 15 years.
So SRDF is often best when you might have different database technologies, or different OSes, and you care about 100% reliability. It also removes responsibility from managing storage replication from the DBA team to some degree, since the array is responsible for pushing the bits around.
With regards to the complexity - once you've done a reference architecture, gotten it working once, you just repeat it over and over again. So that's a little bit of upfront effort, but I don't think in the long run it counts for much, especially compared with the care and feeding of DG.
So I don't see it as an easy call either way - if you have a lot of strong oracle skills in-house and want the flexibility, DG is the way to go. If you want to not have to deal with data protection and care about bulletproof reliability, or have a heterogenous environment, SRDF is great.
Matt
On Mon, Jan 27, 2014 at 4:08 PM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
> Yes, that makes sense. I've been looking at the EMC web site, and haven't
> really found anything definitive one way or another. It really sounds kind
> of tricky from what you are describing though, not sure I see a real
> advantage over dataguard at that point.
>
>
>
>> On Mon, Jan 27, 2014 at 3:44 PM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
>>
>>> Has anyone used EMC's SRDF with Oracle RAC 11gR2? Any issues? Does it
>>> work with RAC?
>>>
>>>
>>>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 27 2014 - 22:18:09 CET