Home » RDBMS Server » Server Administration » Oracle 10.2.0.4 on SAN Storage. (Oracle 10.2.0.4, HP_UX)
Oracle 10.2.0.4 on SAN Storage. [message #397468] Fri, 10 April 2009 23:37 Go to next message
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 #397469 is a reply to message #397468] Fri, 10 April 2009 23:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
do not cross/multi-post
Re: Oracle 10.2.0.4 on SAN Storage. [message #397470 is a reply to message #397468] Fri, 10 April 2009 23:43 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Tempoary tablespace
Next Topic: How do I generate a SQL script file for creation of existing DB Objects (merged 4)
Goto Forum:
  


Current Time: Tue Dec 03 00:51:07 CST 2024