Re: SAME(stripe an mirror everything) - where to put binaries and redos?

From: <sybrandb_at_hccnet.nl>
Date: Fri, 13 Jul 2007 00:01:21 +0200
Message-ID: <619d939d4k6ac7ru25p29k037rjk7uu92i@4ax.com>

On Thu, 12 Jul 2007 13:23:42 -0700, JAGA <james.gabe_at_gmail.com> wrote:

>I am planning on migrating our db to a new server on using diskspace
>on our SAN and have been thinking of using SAME methodology but have
>questions. I initialy wanted to just 1 mount point for everything
>(oracle install and all datafiles control files,.....) Now I am
>thinking that it may be better to have 2 filesystems for oracle, 1 for
>the binaries and one for all datafiles but I am still not sure where
>to put the redo's?
>
>Thanks in advance,
>Jaga

The filesystem issue is irrelevant if all filesystems live on one single device.
Obviously redo's need to be separated fronm data, as redo's are written before the datafiles are written, and insufficien performance in the redo department will have negative impact on the entire database.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Thu Jul 12 2007 - 17:01:21 CDT