Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

move the oracle db from hp san to new storage

SOLVED
Go to solution
DnD_1
Regular Advisor

move the oracle db from hp san to new storage

currently we have one hp box that run oracle constantly and store the db via fiber in hp san.

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!!!!






13 REPLIES
Sajjad Sahir
Honored Contributor
Solution

Re: move the oracle db from hp san to new storage

Dear Friend

I see a similar link

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1037979

thanks and regards

Sajjad Sahir
sujit kumar singh
Honored Contributor

Re: move the oracle db from hp san to new storage

1) if you mirrirdisk/UX installed you can tale advantage of the same.

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 to extend the LV mirror copiesd to the new storage LUns, once over,start DB to check,if all is fine all LEs have got synced,reduce the mirrors from LUNS of the old storage,lvreduce -m 0

Besure to have Valid and Reliable data backup prior to this.
regards
sujit

Matti_Kurkela
Honored Contributor

Re: move the oracle db from hp san to new storage

The "best" way depends on at least these factors:
- 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
MK
Bill Costigan
Honored Contributor

Re: move the oracle db from hp san to new storage

I've done this a number of times using mirroring. You don't need OnlineJFS for mirroring only MirrorUX or it might be included in the version of the OS [e.g. HPUX-EOE includes MirrorUX]

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.
DnD_1
Regular Advisor

Re: move the oracle db from hp san to new storage

thanks for the suggestion

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

Sunny123_1
Esteemed Contributor

Re: move the oracle db from hp san to new storage

Hi

The steps have already given by Bill Costigan.Follow those steps.

Regards
Sunny
sujit kumar singh
Honored Contributor

Re: move the oracle db from hp san to new storage

hi


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
Bill Costigan
Honored Contributor

Re: move the oracle db from hp san to new storage

You don't give the pvnames so I cannot give you the exact commands.

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
DnD_1
Regular Advisor

Re: move the oracle db from hp san to new storage

one more question.

if the migration does not work..and i am in the middle of mirroring.

what are the steps for fallback or rollback ?

thanks !!
James R. Ferguson
Acclaimed Contributor

Re: move the oracle db from hp san to new storage

Hi:

> if the migration does not work..and i am in the middle of mirroring. what are the steps for fallback or rollback?

Simply 'lvreduce -m 0 ' any logical volume that you don't want.

Regards!

...JRF...
DnD_1
Regular Advisor

Re: move the oracle db from hp san to new storage

thanks james...

only lvreduce that simple :) ?
Steven E. Protter
Exalted Contributor

Re: move the oracle db from hp san to new storage

Shalom,

Few things to watch here.

1.) Have a cold back up before you start.
2.) It might be faster to shut the database down and do an scp -rp or cp -rp between the two disks. This assumes you are not using raw disk.

But it seems you are in progress, too late to change.

I would also want some advice from Oracle on acceptable migration procedures.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
James R. Ferguson
Acclaimed Contributor

Re: move the oracle db from hp san to new storage

Hi (again) DnD:

> only lvreduce that simple :) ?

Yes, the mirror operation is non-destructive and when complete you have two (or more) copies of the same data. As noted by Matti, if you don't have MirrorDisk/UX you might consider using the poor-man's mirror --- 'pvmove'. Be very careful if you ever use this. An interruption in 'pvmove' can leave the logical volume(s) with stale extents in an unusable mode. Using MirrorDisk/UX is safe, quick and painless.

Regards!

...JRF...