RE: Separating online redo logs from database files
- From: "Michael Dinh" <mdinh@xxxxxxxxx>
- To: <vbarac@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Apr 2010 08:56:22 -0700
We use SAME and all files are located under /oracle/orarata/sid
However, we are contemplating on moving archived logs to a less
expensive HW.
NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
individual or entity to which it is addressed, and may contain
information that is privileged, confidential and exempt from disclosure
under applicable laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN
PROTECTED HEALTH INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU
ACKNOWLEDGE THE FOREGOING, AND AGREE AS FOLLOWS: YOU AGREE TO NOT
DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, EXCEPT AS
EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR
OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of
this email (and attachments) is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. Please notify the sender of the
error and delete the e-mail you received. Thank you.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Vladimir Barac
Sent: Thursday, April 08, 2010 2:02 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Separating online redo logs from database files
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.
______________________________________________________________________
Other related posts:
