Re: Multi-instances cluster and ASM max lun numbers
From: Stefano Cislaghi <s.cislaghi_at_gmail.com>
Date: Mon, 30 Jul 2012 20:03:07 +0200
Message-ID: <CAFsgGrzTJVYBXTUr7UoByxk_4-jcbzupRhmuNtC5e4ywG6VJXg_at_mail.gmail.com>
On 30 July 2012 17:08, Robert Hanuschke <robert.hanuschke_at_gmail.com> wrote:
> Hi Stefano,
>
> have you tested and experienced performance decreases when having combined
> DATA / FRA / REDO luns for several databases?
>
> I run some clusters where up to 30 databases share the same disk groups -
> one for data, one for fra, 2 separate for redo log mirrors on faster disks -
> just separated by directories inside ASM (OMF). Not having any problems with
> it.
Date: Mon, 30 Jul 2012 20:03:07 +0200
Message-ID: <CAFsgGrzTJVYBXTUr7UoByxk_4-jcbzupRhmuNtC5e4ywG6VJXg_at_mail.gmail.com>
On 30 July 2012 17:08, Robert Hanuschke <robert.hanuschke_at_gmail.com> wrote:
> Hi Stefano,
>
> have you tested and experienced performance decreases when having combined
> DATA / FRA / REDO luns for several databases?
>
> I run some clusters where up to 30 databases share the same disk groups -
> one for data, one for fra, 2 separate for redo log mirrors on faster disks -
> just separated by directories inside ASM (OMF). Not having any problems with
> it.
Hi Robert,
yes your solution is good but what about if you have a problem with a LUN? In my case a single LUN problem or consistency issue might prevent a single database to start, in your case if you have a corruption on your ASM disk or any issue you will have offline al databases maybe.
Thanks
Ste
-- http://www.stefanocislaghi.eu The SQLServerAgent service depends on the MSSQLServer service, which has failed due to the following error: The operation completed successfully. -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 30 2012 - 13:03:07 CDT