Re: Separating online redo logs from database files
- From: William Muriithi <william.muriithi@xxxxxxxxxxxxxxxxxxx>
- To: "'pioro1@xxxxxxxxx'" <pioro1@xxxxxxxxx>, "'vbarac@xxxxxxxxxxxx'" <vbarac@xxxxxxxxxxxx>
- Date: Thu, 8 Apr 2010 18:26:13 -0500
Marcin,
I doubt dedicating a controller to redo logs would help the overall through
put. Remember redo logs and data files traffic is asymmetric, so you would be
under using one controller. Plus, you do not have redundancy in that setup.
I always leave it to multipath service to balance the traffic, as it can
dynamically detect when one controller is clogging up.
----- Original Message -----
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
To: vbarac@xxxxxxxxxxxx <vbarac@xxxxxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
Sent: Thu Apr 08 06:31:40 2010
Subject: Re: Separating online redo logs from database files
Hi,
If you have more than one HBA adapter and more cables between server
and storage
and you don't have a enabled multi pathing on driver level it can help
- if you are be able to use different HBA controller to mount other
LUN and use this controller for redo log traffic only.
regards,
Marcin Przepiorowski
http://oracleprof.blogspot.com/
On Thu, Apr 8, 2010 at 10:02 AM, Vladimir Barac <vbarac@xxxxxxxxxxxx> wrote:
> Hello, listers
>
>
>
> What are general pros and cons on separating redo logs from database files?
> Both database and redologs are already residing on RAID1 volumes. So this
> separation would only mean – move redo logs to separate mount point (RAID1,
> still).
>
>
>
> We have EMC consultant insisting that it is in line with best practices. Why
> exactly is it a good thing, what "best practice" actually means – he can't
> say.
>
>
>
> Our systems are moderately used OLTP databases. I we had lots of waits on
> redo log writes (and we don’t), I would understand moving redo logs to flash
> drives (for example). Or, as I have seen previously, database goes to RAID5
> and redo logs to RAID1 – depends a lot on database usage, etc. etc.
>
>
>
> Actual real life inputs are welcome.
>
>
>
> Regards,
>
> Vladimir Barac
>
> ______________________________________________________________________
> This e-mail message and any attachments to it are for the sole use of the
> intended recipients and may contain confidential and privileged information.
> This e-mail message and any attachments are the property of Yusuf A.
> Alghanim & Sons w.l.l. or any of its subsidiaries or affiliates (“Alghanim
> Industries”). Any unauthorized review, use, disclosure, or distribution of
> this e-mail message or its attachments is prohibited. Any opinions expressed
> in this message are those of the author and do not necessarily reflect the
> opinion of Alghanim Industries. If you are not an intended recipient, please
> notify the sender by reply e-mail and destroy all copies of the original
> message and any attachments.
> ______________________________________________________________________
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
