Re: Raw disk or UNIX file system?

Oracle actually recommends RAW devices in the installation guides, if you read the fine print.

I use file systems for small, lightly loaded databases. For large datawarehouses and I/O intensive databases I use raw for everything except archive logs and init files - as long as the target system has an LVM and decent backup software that supports raw devices and *good UNIX people who are happy with dd, LVM, Oracle' etc.

Oh, and be careful about restores, as you might have to skip LVM control blocks, like the first 4K on IBM's AIX. Make sure you test some full recoveries, and do it periodically.

NB. For some systems (like Parallel Server on SP) you have no choice, you must use raw devices for everything.

MotoX.

Roger Tomas wrote in message <359AB39B.ED91D771_at_agcs.com>...
>Am just becoming new to Oracle. I assume Oracle lets you
>use either UNIX files or raw disk space. I had one person
>tell me Oracle recommends UNIX files.
>
>I find this hard to believe. The UNIX file system is an
>extra layer not optimized for retrieving data from a table.
>It's also a buffering mechanism that could ptentially lie
>to Oracle about commited data actually being out on disk.
>
>Which is better?
>
>Roger Tomas
>AG Communication Systems
>
>
Received on Thu Jul 02 1998 - 02:55:25 CDT