Oracle 10.2.0.4 on SAN Storage. [message #397468] |
Fri, 10 April 2009 23:37 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
Hi Experts,
I am in the process of installing new Oracle 10g database for my
production database which is a part of upgrade, on HP SAN storage with RAID5.
We run oracle apps 11i and this is also going to upgrade to R12.
My concern is how shall i put the different oracle database files on the filesystem with different mount points in order to get the maximum benefit. (like which file shoud be on same mount point, how many points should be there etc..)
Kindly suggest me the best practice for this.
Thanks in advance.
|
|
|
|
Re: Oracle 10.2.0.4 on SAN Storage. [message #397470 is a reply to message #397468] |
Fri, 10 April 2009 23:43 |
IBNHUSSAIN
Messages: 39 Registered: December 2007 Location: INDIA
|
Member |
|
|
I am sorry for this duplications.
I do not know what was the problem when i try to create the topic. It was just hanging( and the page displayed shows server busy message) and i tried several time in order to make sure that i created it.
I am sorry for this.
Hope to see a helpful reply.
|
|
|
Re: Oracle 10.2.0.4 on SAN Storage. [message #397475 is a reply to message #397470] |
Sat, 11 April 2009 00:22 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Depends on the SAN setup basically.
When you say that the entire SAN already is a RAID5, then there would be not much benefit in spreading the data files themselves over different mount points, since those different mount points will most likely wind up being on the same physical drives again anyway.
With a SAN in the background, I usually just go for one file system for the binaries, one file system for database files, and one file system for the backup logs. Not so much for performance reasons, but more to keep it a little organized.
|
|
|