Re: Physical Layout of disk to use Oracle

Hari Om wrote:

> Thanks Howard again!
>
> Here is my final draft...after brain stromming for 6 hrs......
>
> Basically, I am first MIRRORING (Hardware RAID 1) and then stripping
> (RAID 0) thereby implementing RAID 1+0.
>
> hdisk0 + hdisk 1 --> aix --> RAID 1 and then RAID 0 --> AIX OS +
> Oracle SW
>
> hdisk2 + hdisk 3 --> datadict -->RAID 1 and then RAID 0 --> SYSTEM
> Tablespace
> If one of this disk crashes I have another mirrored redundant disk !
>
> hdisk4 + hdisk 5 --> redo1 --> RAID 1 and then RAID 0 --> REDO LOGS
> GROUP 1 + ARCHIEVE Destination.
>
> hdisk6 + hdisk 7 --> redo2 --> RAID 1 and then RAID 0 --> REDO LOGS
> GROUP 2 + ARCHIEVE Destination.
>
> In this I am using MULTIPLEXING and MIRRORING. MIRRORING is achieved
> with disk 4&5 and with disk 5&6 and Multiplexing is achieved with
> redo1 and redo2.
>
> hdisk8 + hdisk 9 + hdisk10 + hdisk11+ hdisk12 + hdisk 13 --> data -->
> RAID 1 and then RAID 0 --> DATA Files
>
> NOTE: aix,datadict,redo1,redo2,data are the names to my RAID Arrays
> respectively.......
>
> Also, hdisk0 and hdisk1 each are 18 GB and others are 36GB each.
>
> Can I have REDO Logs and ARCHIEVE at same place...?
>
> Any comments/issues on above plan...?
>
> THANKS!
Sorry, Hari. I give up. You still insist on putting SYSTEM separate from everything else, despite my having told you three times now not to bother doing so. You also appear to have acquired about half-a-dozen new hard disks that I didn't know about before.

And you're still talking 'redo1' and 'redo2' when you mean 'member A' and 'member B". No-one is insisting that you change the way you think, but if you and I are talking a different language, we're going to get confused in the cross-talk.

So I'm bowing out with just one final appeal:

Stop separating out SYSTEM. Put all log groups on hdisk4+5 and put their B members on hdisk 6+7.

Take hdisk13 out of the RAID array, and give it over to archive logs. Because no, you don't want the onlines and the archives on the same hard disk (one's being read from whilst one is being read to).

Apart from that, you're on your own now. Unless some other kind soul would like to step in. It's not that I'm right and you're wrong or anything like that, but I've given you my advice, you don't seem to want to take it, and that's just fine... but then it's daft asking m for further advice isn't it? You need someone else to mull it over with, I think.

Regards
HJR Received on Sun Sep 21 2003 - 00:09:41 CDT