Re: Filesystem for Linux production database server?

Hi, Gogala:

    Thanks very much for your suggestions.     some points:
1.Oracle 9i on linux 2.4 does support 64GB datafile/raw device. Linux 2.4 kernel support 2GB+ files and oracle 9i have 64bit filesystem io support.I have a rac database on raw with some datafiles 20Gb.

2.Maybe I will choose raid5, as it is dw database.Raid5 is pretty good for Read most database.Though raid10 is also good, it reduced the number of avaliable disks that are avaliable for read.

3.I think I will go for raw device. I am not familier with JFS yet.Raw make it easy when we upgrade to rac:).After all,pc server have limited power and rac is a possible solution.

4.Have anyone successfully compiled redhat as2.1 with LVM support? I tried several times and always fail with
"VGDA in kernel and lvmtab are NOT consistent" after system reboot.

Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 2:14 AM

> Linux file systems usually do not support direct I/O (bypassing the buffer
> cache), which means that you're going to have double caching with almost
> everything except raw devices. You can have up to 256 raw devices on a
Linux
> box and if your database is small enough (32-bit system, 2G limit
applies),
> that will definitely be the fastest option. My recommendation is to go
with
> IBM JFS because it is a battle tested, mature, well performing file
system. I
> would advise against XFS because nobody uses it.
> As for availability, you'll have to go with some RAID controller and
standby
> database or RAC. In case of RAC, your choice of file systems is clear
(OCFS).
> Whatever you do, do not configure your RAID as RAID-5 but RAID 1+0 (BARF).
>
> which means that
> On 2003.06.29 11:44, zhu chao wrote:
> > Hi, friends that run oracle on linux:
> > We are running some database on linux, some with UPS protection and
some
> > not, all using ext2. Currently we have a DW server running oracle
817/Redhat
> > 7.2/Ext2. When server crash because of power supply, fsck took rather
long
> > time!
> > And we are planning migrate to redhat as2.1/9.2, and I am thinking
of
> > what kind of filesystem shall I choose for the new server. The database
is
> > about 150G.I had planned to use ext3 for it is journal filesystem, But
> > according to http://www.linuxjournal.com/article.php?sid=5841, ext3 is
bad
> > for performance, and some friend said he hit filesystem crash with ext3.
> > So,what is your experience using filesystem for oracle in linux?
> > Performance and avaliability is of most important.
> > Thanks.
> >
> >
> > Regards
> > zhu chao
> > msn:[EMAIL PROTECTED]
> > www.cnoug.org
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: zhu chao
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).