- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle datafile
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2001 07:35 PM
тАО11-07-2001 07:35 PM
Oracle datafile
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 ?
Regards,
Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2001 08:06 PM
тАО11-07-2001 08:06 PM
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.
-raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2001 09:22 PM
тАО11-07-2001 09:22 PM
Re: Oracle datafile
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2001 09:38 PM
тАО11-07-2001 09:38 PM
Re: Oracle datafile
When using raw device you need consider few things. See the link for details:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,11866,0xb1e8660142b2d5118ff10090279cd0f9,00.html
Regards
Animesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2001 12:04 AM
тАО11-08-2001 12:04 AM
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)
http://www.ixora.com.au/tips/creation/raw_datafiles.htm
good luck,
Thierry.