Re: Separating online redo logs from database files

  • From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
  • To: vbarac@xxxxxxxxxxxx
  • Date: Thu, 8 Apr 2010 12:31:40 +0100

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: