Re: Do we need multiple REDOLOG member if it is already on SAN box?
From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Fri, 29 Apr 2011 17:29:50 -0700 (PDT)
Message-ID: <1b29b89e-9aa6-495c-90ed-8e401d832b54_at_26g2000yqa.googlegroups.com>
On 29 apr, 21:12, charles <dshprope..._at_gmail.com> wrote:
> > This is not exactly a new type question. Various people will have
> > different answers here.
>
> > On most of my dev/test databases ... no I don't use it multiple
> > members in a redolog group usually.
>
> > Production databases I will go case by case. Highly critical systems
> > sure why not.
>
> > Have I ever lost a redolog group or just one member of a group? Not
> > so far ...
>
> Here is our SA's comment
>
> I'm NOT fine with this but please remember that I HIGHLY recommend
> against this. It is a best practice to never do software raid which
> is what you are basically doing. This is very old practice when you
> don't have the infrastructure that we have.
Date: Fri, 29 Apr 2011 17:29:50 -0700 (PDT)
Message-ID: <1b29b89e-9aa6-495c-90ed-8e401d832b54_at_26g2000yqa.googlegroups.com>
On 29 apr, 21:12, charles <dshprope..._at_gmail.com> wrote:
> > This is not exactly a new type question. Various people will have
> > different answers here.
>
> > On most of my dev/test databases ... no I don't use it multiple
> > members in a redolog group usually.
>
> > Production databases I will go case by case. Highly critical systems
> > sure why not.
>
> > Have I ever lost a redolog group or just one member of a group? Not
> > so far ...
>
> Here is our SA's comment
>
> I'm NOT fine with this but please remember that I HIGHLY recommend
> against this. It is a best practice to never do software raid which
> is what you are basically doing. This is very old practice when you
> don't have the infrastructure that we have.
Hardware mirroring will not protect you against redo log corruption,
the corrupted log will just be happily mirrored.
Have your SA read up on what Oracle calls a "redundancy set"; a good
start would be:
http://www.google.com/search?q=oracle+%22redundancy+set%22&tbm=bks
HTH
-- JeroenReceived on Fri Apr 29 2011 - 19:29:50 CDT