Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle datafile

Patrick Chim
Trusted Contributor

Oracle datafile

Hi all,

Many of my friends and former colleagues like to use UNIX filesystem to store the oracle datafile. Is it difficult to use raw device to hold the database ? What is the advantage and disadvantage between them ?

Roger Baptiste
Honored Contributor

Re: Oracle datafile


Each has its advantage/disadvantages and i don't think there will be a clear-cut choice
of one over another.

From a unix admin point of view, i would happy to have just a raw-volume database and
leave the whole business of tuning, tweaking, backing up etc to the DBA. ;-) and that i
think is a key difference.

Performance wise, Raw volumes are supposed to be faster because they unlike filesystems they do not go through an additonal layer. But, with advanced JFS and tweaking FS mount options that gap is narrowed.

On the backup front, raw volumes would need
backup tools , unlike filesystem which can be accessed/backed up as any other file. But, given the complexity and size of databases, a backup tool (omniback, Rman etc..) is anyway guaranteed to be there.


Take it easy.
Scott Van Kalken
Esteemed Contributor

Re: Oracle datafile

I would agree with Raj, it's a matter fo speed. From another admin point of view, it's easy. We don't need to worry about them.

Raj is right, the filesystem option is slower because it communicates directly with the raw device.

I have seen to occasional problem if / when firmware is loaded and oracle is not patched approriately, but this is rare.
Animesh Chakraborty
Honored Contributor

Re: Oracle datafile

When using raw device you need consider few things. See the link for details:,11866,0xb1e8660142b2d5118ff10090279cd0f9,00.html

Did you take a backup?
Thierry Poels_1
Honored Contributor

Re: Oracle datafile


the discussion about raw device files or filesystem datafiles has been going on for ages. They both have theire advantages and disadvantages.
Raw device files are theoretically faster, but in the last years the difference has become much smaller (vxfs, Veritas Oracle filesystems!!).
Filesystem datafiles are much easier to handle, you can play around with them just like plain files.
Your choice should probably depend on the size of database, speed of disksystem, type of server, experience of DBA & sysadmin, ...

Have a look at Ixora (pro raw devices)

good luck,
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.