- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Using LVM to migrate data for Oracle
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
тАО09-01-2010 04:55 AM
тАО09-01-2010 04:55 AM
We have a HP-UX server with oracle8 database hosted on it with SAN storage coming from CLARiiON. We are planning a tech refresh and wanto to remove the CLARiiON storage and migrate the data to NetApp storage. Our requirement is for online data copy with downtime only for cuting over.
We plan to use LVM based mirroring for this purpose
Any pointers on this would be helpful, how we can achieve this?
Solved! Go to Solution.
- Tags:
- Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2010 10:31 AM
тАО09-01-2010 10:31 AM
Re: Using LVM to migrate data for Oracle
present equally sized luns from new array
add to volume group
extend mirror
reduce old from vg
remove old from server
cleanup old device paths.
there will be io contention while the mirror sync is in process, but I had never had any end user complaints.
schedule for off peak usage hours.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2010 10:33 AM
тАО09-01-2010 10:33 AM
Re: Using LVM to migrate data for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2010 11:11 AM
тАО09-01-2010 11:11 AM
Re: Using LVM to migrate data for Oracle
If you can provide any documentation for this process then that would be great.....for this process the only requirement would be disk of the same size....
I just want to be sure on the process so that I dont go wrong for database especially.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2010 11:52 AM
тАО09-01-2010 11:52 AM
Solutionpvmove basically mirrors each extent and then reduces the old extent but acts on the entire disk device vs lvextend/lvreduce which only acts on lvols.
create lun of equal size on new disk array and present to server ( cannot give you instructions for this)
on hpux server:
ioscan (to scan for new storage)
insf -e (to create device files for new storage)
ioscan -kfnC disk (to identify new storage)
pvcreate /dev/rdsk/cxtxdx (device file of new storage)
vgextend /dev/vgname /dev/dsk/cxtxdx (add to vg)
pvmove /dev/dsk/old_lun /dev/dsk/new_lun
or
lvexend -m 1 /dev/vgname/lvolx /dev/dsk/new_lun
lvreduce -m 0 /dev/vgname/lvolx /dev/dsk/old_lun
(repeat lvextend/lvreduce for each lvol)
when complete
vgreduce /dev/dsk/old_lun
unpresent old lun
rmsf -H HW_PATH_OF_OLD_LUN (cleans up old device file)
repeat for each
for best results so you know what you are doing.
add lun from old array and create a new vg with it, add lun from new array and practice the above procedures. understand what you are doing before you do it ;)
best of luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2010 05:28 AM
тАО09-02-2010 05:28 AM
Re: Using LVM to migrate data for Oracle
>It is my understanding that NetApp storage is an NFS mount to UNIX.
Not exactly. Netapp supports several protocols for storage provisioning. It's name is mostly associated with file-based protocols like NFS or CIFS, but keep in mind that it supports also block-based storage provisioning over FC or iSCSI.
Unix operates with beer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2010 05:31 AM
тАО09-02-2010 05:31 AM
Re: Using LVM to migrate data for Oracle
As an addition to Tim's procedure: if you have a clustered environment with LVM, don't forget to vgexport and vgimport the VG on the inactive node.
Regards,
Viktor
Unix operates with beer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2010 06:22 AM
тАО09-07-2010 06:22 AM
Re: Using LVM to migrate data for Oracle
Regards