- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Moving datafiles from non-stripped to stripped...
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
тАО10-22-2008 09:04 AM
тАО10-22-2008 09:04 AM
We are in the process of moving the Oracle datafiles from non-stripped logical volumes to stripped volumes. I need to know which will be the best way to do this. If we do just the copy cp and dd command, will that helps in performance and will that the data move as per the stripe unit? Or do we require any Oracle way of re-creating the data files in the new stripped volumes?
Thanks,
Srini
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2008 10:27 AM
тАО10-22-2008 10:27 AM
Re: Moving datafiles from non-stripped to stripped logical volumes
You are using LVM and the physical devices are either striped on a disk array or LVM striping is used. You are also using vxfs filesystems and not raw disk.
This that said, simply copy the data or restore from a backup means of your choice(certainly while the application is down).
Using LVM and vxfs you do not have any real control of the data layout.
If you are NOT using LVM and/or vxfs then please fill provide some more specifics.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2008 01:39 AM
тАО10-23-2008 01:39 AM
Re: Moving datafiles from non-stripped to stripped logical volumes
Thanks,
Srini
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2008 03:34 AM
тАО10-23-2008 03:34 AM
Re: Moving datafiles from non-stripped to stripped logical volumes
Local copy:
tar cf - * | ( cd /target; tar xfp -)
( cd SOURCEDIR && tar cf - . ) | (cd DESTDIR && tar xvpf - )
find . -print -depth | cpio -pvdum /data/my_data
Remote:
( cd SOURCEDIR && tar cf - . ) | ssh target_address "(cd DESTDIR && tar xvpf - )"
For local copy i would use the find command it seems to be a little bit faster (in some cases).
Links:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=778077
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1115722
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1082336
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1065155
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=81120
This link is fun reading:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=850008
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2008 04:03 AM
тАО10-23-2008 04:03 AM
Re: Moving datafiles from non-stripped to stripped logical volumes
dd is the easy way to go, if you can tolerate the down time on that part of the db, no need to shut down oracle or hpux.
Eventually you'll need to tell Oracle where the new datafile lives directly (alter database...), or with smoke and mirrors... soft link from old location.
Speaking of mirroring, with the right tools and lvm command you can potential turn the original LV into a mirror, adding the new LVM striped disks. This will transparently make a copy. You can then reduce or split away the original and have no downtime (but a lot of homework and testing!).
Best i know, you used to be able only to mirror on exetend-based stripes (which may well be optimal), not on 'block striped. But there are patches ( PHCO_36746 ) which can make this happen also, for hpux 11.23.
Carefully read: http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1197798
Other topics describe these suggestion in various levels of detail. Google for +lvm +strip +mirror. Toss in 'pvg' or 'split' as needed.
Hope this helps some,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2008 06:48 AM
тАО10-23-2008 06:48 AM
Re: Moving datafiles from non-stripped to stripped logical volumes
cd olddir
find . -depth -print | cpio newdir
Just keep in mind to if you are planning to change your mount names then you will need to rename your datafiles in Oracle.
You can mount the new striped mount points to a temporary name, copy the data, unmount the old mount points and then remount the new mount using the old name.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2008 08:18 AM
тАО10-23-2008 08:18 AM
Re: Moving datafiles from non-stripped to stripped logical volumes
Note:HP-UX version 11i v2
Thanks,
Srini
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2008 08:26 AM
тАО10-23-2008 08:26 AM
SolutionIf you are striping a stripe ( I call it plaiding ). Then the stripe size and data layout is controlled by how you created the lvol ( e.g. -i 8,16,64 etc.. )
The method of copy does not matter.
Please post your results, there has been great debate on "plaiding".
In some instances LVM striping an array stripe may disable or hinder the array's ability to optimize prefetch and cache.
In other cases people have experienced benefits.
The current word is "test it in your environment and use what works best for you"
I think it would be great to hear your results.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2008 01:00 AM
тАО10-24-2008 01:00 AM
Re: Moving datafiles from non-stripped to stripped logical volumes
Surely I will give the updates after the change.
Thanks,
Srini