- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: File Striping for Oracle Database
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
тАО04-10-2007 12:47 AM
тАО04-10-2007 12:47 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 12:51 AM
тАО04-10-2007 12:51 AM
Re: File Striping for Oracle Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 12:56 AM
тАО04-10-2007 12:56 AM
Re: File Striping for Oracle Database
She may have been telling you that you don't have intelligent disk arrays in your environment then striping over multiple disks makes sense. Mirroring is just writing to 2 or more physical disks at once.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 01:08 AM
тАО04-10-2007 01:08 AM
Re: File Striping for Oracle Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 01:17 AM
тАО04-10-2007 01:17 AM
Re: File Striping for Oracle Database
INSIST that you as a DBA knows the storage infrastructure -- i.e. your Storage Arrays and how the "LUNS/Disks" are RAIDed. Also, whan a storage/system admin refer to a LUN/disk as mirrored -- it's just another level of RAIDing -- but does that not neccessarily mean you have striped LUNs.
Depending on your Storage Array -- it is always best to know its architecture as sometimes teh BEST I/O performance and scalability can be achieved by HOST BASED STRIPING (via LVM/VxVM, etc) of these already RAIDed LUNs/disks from yout array.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 01:22 AM
тАО04-10-2007 01:22 AM
Re: File Striping for Oracle Database
You are right, the goal of mirrorring is just that, mirror the data to keep it available in case a drive fails. It also tends to have performance benefits as reads (which tend to dominate the IO pattern) can come from the nearest, or least busy, disk. Writes may slow down, as both disks need to be written, but caches can take care of that.
The system administrator may have focussed on the mirrored aspect of a lun, while it offers striping at the same time. This combination is often refererred to as raid-01 or raid-10. It offers the best of both worlds.
Ask you question in simple terms... how many physical disks are behind my luns?
2 would be mirroring only and not good enough. 8 would be nice. 40+ would be the 'SAME' architecture Tom referred to.
>> I can go back to her and find out what kind of storage is ours. But I doublt if I get any response which will make sense to me.
How can that be? The SA is there to serve the DBA, which is there to serve the application no? If the SA can not communicate with the DBA then you can not run an optimal business solution.
Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 01:34 AM
тАО04-10-2007 01:34 AM
Re: File Striping for Oracle Database
RAID, striping, mirroring are not just about HP systems - they are general concepts.
The following URL answers many of the questions people are asking about RAID for an Oracle database:
http://technet.oracle.com/deploy/availability/pdf/oow2000_sane.pdf
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 01:34 AM
тАО04-10-2007 01:34 AM
Re: File Striping for Oracle Database
It is much better to handle this on a disk array and merely present a well configured LUN to the HP system.
The disk array is designed for this, the system is not as good at making the i/o most efficient.
Striping such that it is with the OS is not very effective and not even considered true striping.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 01:36 AM
тАО04-10-2007 01:36 AM
Solutionif you don't feel inclined to ask your Unix sysadmin who should know.
First add /usr/sbin to your path to abbreviate typing.
(assuming your dba account has a Bourne-like shell)
$ PATH=/usr/sbin:$PATH
With sqlplus you should be able to find out $ with an SQL query the paths to the *dbf files (if you don't know already, anyway).
Sorry, I would have to look up the correct SQL statement as I am no DBA.
Then bdf should show you the logical volume (LV) of the mount that bears the filesystem.
$ bdf /path/to/some/file.dbf
The LV path of the bdf will contain the volume group (VG) that LV belongs to.
To find out what disks are contained in that VG you can run verbose vgdisplay.
$ vgdisplay -v vgXX | more
At the end will be listed the physical volumes (PV) aka disks.
$ vgdisplay -v vgDat1|awk '/PV Name/&&!/lternate/{print$NF}'
You also can pipe this to lssf which should disclose the HW paths of the disks
$ vgdisplay -v vgDat1|awk '/PV Name/&&!/lternate/{print$NF}'|xargs lssf
By the HW paths you are likely to discover how the used disks are attached.
Compare the beginning of HW paths to output of
$ ioscan -knfCext_bus
to find out the controllers the disks are attached to.
You may also follow a whole HW path by
e.g. (replace with your HW path)
$ ioscan -knf -H 1/0/6/1/0.114.4.19.0
To find out if any of the LVs are striped you can do this.
$ $ vgdisplay -v vgXX|awk '/LV Name/{print$NF}'|xargs lvdisplay|grep -E 'LV Name|Stripes'
HTH
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2007 06:01 AM
тАО04-10-2007 06:01 AM