Re: Oracle on Linux. File layout and disc distribution.

"Alejandro Bibiano González" <informatica_at_laubat.com> schrieb im Newsbeitrag news:bo85j9$onb$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> I have acquired a new server for my Oracle database. Te server is a Sun Fire
> V65x with RedHat Enterprise Linux 2.1 WS and 2Gb RAM.
> Actually my database is installed on a Windows 200 Server, and the
> approximated size is: INDEX and USR TABLESPACE about 3Gb, SYSTEM and RBS
> 1Gb, and the rest 200Mb.
> It will be my first Oracle installation on a Linux computer and I have few
> questions:
> My Server has 2Gb Ram and 6x36Gb SCSI discs with a hardware RAID controller.
> What is the best RAID and disk distribution to install Oracle with this
> hardware?
> What is the best file layout in Linux (partitions)?
> All recommendations are welcome.
> I will also appreciate any suggest for the Oracle installation in my new
> computer. It will arrive in 2 days.
> A lot of thanks,
> Alex Bibiano
>
> informatica_at_laubat.com

Hi!
The linux installation isn't that hard. Just be sure you have read carefully the platform-independent instructions regarding the kernel parameters. How many processors do you have on this?

As for layout, that depends on the type of load. If it's mostly read-only then it's less critical. If not, then the redos quickly become the bottleneck.

So, my first suggestion would be for a write-intensive db: RAID1 (mirroring) two disks, giving you a 36G volume for the OS, oracle SW, datafiles and one or two controlfiles. Make sure the big datafiles get allocated in one piece. I have heard that there are defragmenters available for Linux. RAID0+1 the other four disks (striping and mirroring), giving you another 36G volume for the redos and one more controlfile. Maybe you could put the archivelogs there as well so the space is not wholly wasted.

If it's read only, you could put the OS/SW on one volume, datafiles and archivelogs on another and the redos on the third.

Btw, what amount of cache does your RAID controller have and can you assign a part of this cache specially to the redo volume?

Also, what's your backup strategy? Do you back up to a local disk, a nfs volume or directly to a tape?

Lots of Greetings!
Volker Received on Tue Nov 04 2003 - 09:42:33 CST