Re: Oracle configuration on Enterprise E450

We run e450's and currently have a RAID 0 configuratuion. I keep all my datafiles on the RAID 0, and Redologs on a seperate drive. ALTHOUGH, I'd set it up differently next time.

Keep two drives for redo logs, not mirrored, for mulitplexing.

2 OS
2 Redo logs / archive
3 data disks (striped -> /oradata01 (data, temp) 3 data disks (striped -> /oradata02 (indexes, undo, system)

From my experince, the LOGS really need to be away from the stripped disk.

Cheers,

grjohnson

Birger Blixt <Birger.Blixt_at_uab.ericsson.se> wrote in message news:<3DE60844.44649503_at_uab.ericsson.se>...
> Darren Dunham wrote:
> >
>
> >
> > 2 OS disks (mirrored) -> / (root)
> > 8 data disks (4 way stripe + mirroring) -> /oradata1 (db, index, logs..)
>
> Even a mirror can be broken.
> I'm no oracle guru, but I should make another device for logs,
> so the db can be restored and rollback'ed to a proper state
> in a time that is acceptable.
>
> Plan for the worst case first ,, recover , backup , then the other.
>
> Also, logs and data mey have different mount options,
> example forcedirectio,noatime for the db filesys.
>
> /bb
Received on Thu Nov 28 2002 - 17:13:24 CST