- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Raw Partitions
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
тАО02-27-2004 09:59 PM
тАО02-27-2004 09:59 PM
Raw Partitions
I have worked with file systems and volume managers for Oracle on HP UX11.11.
Now I have been proposed to use 'RAW PARTITIONS' for oracle rac.
Could some one tell me how I could manage Raw partitions? Increase size / decrease size online etc. How complicated is this etc....Instead of Raw partitions can I still use file system concept.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2004 10:25 PM
тАО02-27-2004 10:25 PM
Re: Raw Partitions
You can use either and may find this discussion interesting
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=98869
raw volumes are managed using the lv commands
man lvcreate
man lvreduce
man lvextend
HTH
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2004 08:26 AM
тАО02-28-2004 08:26 AM
Re: Raw Partitions
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2004 05:04 PM
тАО02-28-2004 05:04 PM
Re: Raw Partitions
If you drop the *fs* commands on LVM, then they are raw logical volumes. For ex., to create a raw logical volume only do until 'lvcreate' command. Don't run newfs on it. Similarly for increasing the size 'lvextend' alone is sufficient. I wouldn't suggest decreasing the sizes. To copy data from one raw partition to another, you can use 'dd' command. Make sure to change the permissions of your /dev/vgxx/r* files to oracle:dba and keep track of the permissions. Unlike filesystems, you cannot see data on raw logical volumes as it is directly managed by oracle. So, be extra careful while managing these volumes.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2004 07:52 PM
тАО02-28-2004 07:52 PM
Re: Raw Partitions
I think the "ease of administration" for filesystembased oracle DBs is a myth.
Beside a Sandbox, where everything is mixed up in the same filesystems, you will not like to have i.e. a Webserver-Home-Directory on a disk where Oracle-datafiles reside. So you need to organize your disks in any way, no matter if you use raw or fs. May be raw devices force you a bit more to stay to it.
So instead of putting datafiles to filesystems, create a directory, where you create symlinks to the raw-devices as needed.
like
lvcreate -n lvdata2 /dev/vgdb1
lvextend -L 500 -n lvdata2 /dev/vgdb1 /dev/dsk/disk_to_be_used
ln -s /dev/vgdb1/rlvdata2 /oracle/DB1/rawlinks/data2
chown oracle:dba /dev/vgdb1/rlvdata2
chmod 600 /dev/vgdb1/rlvdata2
Now the symlink is ready to be used for a 500M datafile.
alter tablespace data add datafile '/oracle/DB1/rawlinks/data2' size 500M;
In case you want to resize, you need to extend the lvol first and resize the datafile after that. So autoextend features are a bit limited.
Hope this gives you an overview on how to handle it.
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2004 08:04 PM
тАО02-28-2004 08:04 PM
Re: Raw Partitions
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=198966
-Karthik S S
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-28-2004 08:41 PM
тАО02-28-2004 08:41 PM
Re: Raw Partitions
A. Clay Stephenson actually took the time to do performance testing raw versus filesystems.
Back on 10.20 and 11.00 there was a substantial boost going raw. Not enough to convince me to bother under 11.11 though.
For what its worth. The thread is on the first or second page of my itrc profile.
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
тАО02-29-2004 10:39 AM
тАО02-29-2004 10:39 AM
Re: Raw Partitions
However! When you are using RAC, the volume groups are set in a shared mode. So, any changes made to the volume groups have to be replicated to the other systems using vgexport/vgimport. Also, the volume group cannot be modified in a shared mode, it can only be done in exclusive (which requires the volume group to be deactivated and reactivated, so the DB has to be down for the volume group).
My recommendation is to use ALL of the space in a volume group when adding it to the database. Any space that is not used in a volume group will not be available for use in the database without downtime for the database.
There are some cooked filesystems that can be used with RAC. Veritas Cluster is one, and I believe there are a few others. The LVM partitions with HP-UX need to be raw to be used.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-29-2004 08:10 PM
тАО02-29-2004 08:10 PM
Re: Raw Partitions
We did some performance tests recently, and these are the results. Keep in mind that this IS a test done with Sybase on HP-UX 11.11, rp5470 machine with a DS2300 disk system. These results won't be the definitive answer to your question as there's Sybase involved, but they can be used as an indication.
Blocksize raw fs
4096k 2,53 2,31
1024k 2,55 2,48
512k 2,08 3,55
256k 2,16 4,67
128k 2,63 0,32
64k 4,46 0,32
32k 8,12 0,32
16k 15,41 0,33
2k 117,67 0,71
HTH,
Robert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-01-2004 05:33 PM
тАО03-01-2004 05:33 PM
Re: Raw Partitions
Faizer,
Thanks to lvm (the lv/vg tools) Raw partitions are just about as easy to manage as files. Everything except Oracle's autoextent to grow datafiles automatically. You solve that by manually adding datafiles (pointing to raw devices) to tablespace where needed.
I woudl not think in terms of growing/shrinking. More adding/deleting.
If at all possible I like to do an initial load/setup with autoextent filesystems and then move (export/import, or dd copies) to reasonably sized raw devices when most data is available for ultimate performance or RAC needs. In such process I tend to retain the filesstem 'addresses' for the datafiles and just softlink them to the new underlying raw devices. This gives me a level of indirection I find useful, but which also can be obtained through smart/clean logical volume name choices.
Robert,
Please explain a little more about your test output to allow us to appreciate the data provided. Is more better or worse? What is your conclusion for the specific test? filesystems mostly better? How would you characterize the test reported? Like a copy? Like and OLTP taks? Like a BI report task?
What are the units reported (seconds elapsed!?). Was there anything else worhth observing (like cpu/system time versus wallclock time).