- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: move the oracle db from hp san to new storage
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
тАО06-17-2009 12:44 AM
тАО06-17-2009 12:44 AM
now we got a new storage, and need to move all the data from hp san to the new storage.
can anyone suggest the best way to doing it ?
many thanks!!!!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-17-2009 02:14 AM
тАО06-17-2009 02:14 AM
SolutionI see a similar link
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1037979
thanks and regards
Sajjad Sahir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-17-2009 02:18 AM
тАО06-17-2009 02:18 AM
Re: move the oracle db from hp san to new storage
create LUNs on the new storage, assign those to the server, extend the Data VG tp include these disks. Shutdown oracle and do lvextend -m 1
Besure to have Valid and Reliable data backup prior to this.
regards
sujit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-17-2009 02:35 AM
тАО06-17-2009 02:35 AM
Re: move the oracle db from hp san to new storage
- are you using VxVM, LVM or raw disks?
- do you have OnlineJFS installed?
- is it possible (and/or worthwhile) to mirror the data between the storages at the storage configuration level?
The best approach is generally to mirror the database to the new storage (using OnlineJFS or whatever), then delete the "old" half of the mirror. This way the migration can be achieved without a service outage. Remember that a migration using OS-level mirroring is going to double the I/O load on your database server temporarily, so you might want to run the migration at a quiet time.
If both the new storage and the old one come from the same manufacturer, you may even be able to mirror the DB disks between the storages at the storage hardware level, with no extra I/O load to the server. In this case, switching to the new storage may require a short service break (for e.g. vgexporting the VG, changing the SAN configuration, and re-importing the VG from the new storage).
If LVM is used but you don't have OnlineJFS, you can still move the data to the new storage using the pvmove command. Definitely take a backup first, though: pvmove attempts to make the transfer as carefully as possible, but there is still a small but non-zero risk that you may end up with two broken halves of a database if something goes seriously wrong.
MK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-17-2009 04:33 PM
тАО06-17-2009 04:33 PM
Re: move the oracle db from hp san to new storage
Add the new LUN to the VG and 'lvextend -m 1' the lvol to the new LUN. When its done 'lvreduce -m 0' the lvol removing using the original PV in the command (e.g. remove the mirror from this PV)
Once there is not Lvols left on the old PV you can use vgreduce to remove the old PV from the VG altogether. This can be used to more from direct attached drives to SAN drives or from one SAN drive to another SAN drive. Same SAN vendor or different SAN vendors.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2009 01:58 AM
тАО06-18-2009 01:58 AM
Re: move the oracle db from hp san to new storage
we dont have JFS installed :( and i dont really get what you've explained. sorry for my lack of knowledge of hp ux...
anyway, i got the information wrong....we have our oracle install in HP SAN as well
but, please can you suggest/explain the procedure step by step ?
we have the following,
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 212992 138544 74072 65% /
/dev/vg00/lvol1 298928 64216 204816 24% /stand
/dev/vg00/lvol8 4718592 1481912 3211600 32% /var
/dev/vg00/lvol7 2244608 1320808 916632 59% /usr
/dev/vg00/lvol4 3080192 625440 2439544 20% /tmp
/dev/vg00/lvol6 2736128 1561984 1165032 57% /opt
/dev/vg00/lvol5 32768 7736 24888 24% /home
/dev/vgdb1/lv_db1
5120000 3545377 1476237 71% /dbank/oracle
/dev/vgdb2/lv_db2
64012288 35738929 26537631 57% /dbank/opt
/dev/vgdb3/lv_db3
269484032 20562543 233363902 8% /dbank/db3
/dev/vgedb4/lv_db4
182157312 167247804 13977666 92% /dbank/db2
/dev/vgedb5/lv_db5
455065600 454075173 928582 100% /dbank/db1
/dev/vgdb6/lv_db6 536862720 536463040 396616 100% /dbank/db
/dev/vgdb7/lv_db7 269484032 140263825 121144000 54% /dbank/account
what we have to move is from /dev/vgdb onward
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2009 02:29 AM
тАО06-18-2009 02:29 AM
Re: move the oracle db from hp san to new storage
The steps have already given by Bill Costigan.Follow those steps.
Regards
Sunny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2009 02:53 AM
тАО06-18-2009 02:53 AM
Re: move the oracle db from hp san to new storage
Please see the question :
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1340282
your answer is there in the question itself.
But for this there should be HP MirrorDisk/UX Software as well as the license installed on your system.
#swlist -l bundle | grep -i mirror
If you have the mirror disk license installed you can proceed as given in the question.
regards
sujit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-18-2009 06:12 AM
тАО06-18-2009 06:12 AM
Re: move the oracle db from hp san to new storage
Let's assume the old pv name is /dev/dsk/c15t0d4 and the new LUN is c17t1d5
1. pvcreate /dev/rdsk/c17t1d5
2. vgextend /dev/vgdb1 /dev/dsk/c17t1d5
3. lvextend -m 1 /dev/vgdb1/lv_db1 /dev/dsk/c17t1d5
4. lvreduce -m 0 /dev/vgdb1/lv_db1 /dev/dsk/c15t0d4
5. vgreduce /dev/vgdb1 /dev/dsk/c15t0d4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-02-2009 02:32 PM
тАО07-02-2009 02:32 PM
Re: move the oracle db from hp san to new storage
if the migration does not work..and i am in the middle of mirroring.
what are the steps for fallback or rollback ?
thanks !!