topic Re: Data Migration -- attempting vgexport/vgimport in Operating System - HP-UX

Data Migration -- attempting vgexport/vgimport

Akif_1 — Mon, 16 Nov 2009 15:11:40 GMT

Hi All,

Iam using HP-UX 11.11 on rp5470 server, recently my company bought two hdd and would like to replace the old one (73GB)Oracle DB 8i with (145 GB) each.

Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 204800 93304 110672 46% /
/dev/vg00/lvol1 298928 57288 211744 21% /stand
/dev/vg00/lvol8 4710400 397992 4279016 9% /var
/dev/vg00/lvol7 1622016 1024696 592688 63% /usr
/dev/vg00/lvol4 516096 28944 483984 6% /tmp
/dev/vg00/lvol6 1146880 750752 393072 66% /opt
/dev/vg00/lvbkp 10240000 7379608 2771054 73% /m01bkp
/dev/vg00/lvol5 24576 2360 22048 10% /home
/dev/vg03/lvol4 16367616 11874438 4352772 73% /ra09
/dev/vg03/lvol3 18432000 14604408 3767792 79% /ra08
/dev/vg03/lvol2 18432000 10541800 7766920 58% /ra07
/dev/vg03/lvol1 18432000 9880412 8417972 54% /ra06

===================
DISK DEVICES INFO:
===================
? 0/0/1/1.0.0 1 LVM vg03 70007 HP 73.4GMAX3073NC ^
? 0/0/1/1.2.0 1 LVM vg00 34732 HP 36.4GMAN3367MC
? 0/0/2/0.0.0 1 LVM vg03 70007 HP 73.4GST373454L
? 0/0/2/0.2.0 1 LVM vg00 34732 HP 36.4GMAN3367MC

My Question is :
================

As "VG00" dedicated for HP-OS and "VG03" is completely dedicated to oracle.

#Iam not sure that two hdd of 73GB is in RAID or not , if it is in RAID can i replace one hdd (145GB) to synchronise with 73.

#If above operation successful than i can smoothly replace another hdd of 73 to 145GB.

IF not:

How can i backup 73GB of disk and replace both with 145GB and restore the above Oracle Database backup possible or not .

IF YES :

"vgcfgbackup & vgcfgrestore" and "vgexport & vgimport"

which one helps me to solve this issue,

BACKUP:

Backup media is a tape of 200GB.

I appreciate all experts who help me whenever i needed ............

Rgd's

Re: Data Migration -- attempting vgexport/vgimport

Steven E. Protter — Mon, 16 Nov 2009 15:21:45 GMT

Shalom,

vgdisplay -v vg00
vgdisplay -v vg03

That will let you know which disks are occupied by what logcal volumes.

then you can plan this out.

the general procedure, running vgexport on vg03, followed by vgimport and restore of data is a good one. You need to back up that oracle database, preferably cold, with Oracle down.

SEP

Re: Data Migration -- attempting vgexport/vgimport

James R. Ferguson — Mon, 16 Nov 2009 15:42:03 GMT

Hi:

> Iam not sure that two hdd of 73GB is in RAID or not , if it is in RAID can i replace one hdd (145GB) to synchronise with 73.

I assume that your are asking if the logical volumes of vg03 are mirrored. To determine that, use 'lvdisplay' for each logical volume in 'vg03' looking for "Mirror copies". A value greater than zero indicates that the logical volume is mirrored. Adding a '-v' will show you which physical disks are involved in the mirroring:

# lvdisplay -v /dev/vg03/lvol

That said, if you simply replace one 73GB physical disk with a 146GB one, perhaps by using 'vgreduce' and 'vgextend', the new larger disk may not be fully utilizable. You need to determine the 'Max PE per PV' and 'PE Size' values of your old physical disk from:

# vgdisplay vg03

Then, calculate if the product of these two values sufficient to use all of your new disk. If not, you will need to migrate your data from the old to the new disk.

Regards!

...JRF...

Re: Data Migration -- attempting vgexport/vgimport

Aneesh Mohan — Mon, 16 Nov 2009 15:58:31 GMT

Hi,

Most probably vg03 lvols are mirrored one.

Please post the o/p of

#lvdisplay /dev/vg03/lvol* |grep -i -E "LV Name|Mirror copies|stale"

if yes you can replace one by one.

If not

a) get an database outage.
b) shutdown database (gracefully)
c) take complete backup of vg03 lvols.
4) vgcfgbackup vg03
5) umount vg03 lvols
6) pvchange -a N to the vg03 pv`s
7) replace 73 gb disks with new 146 gb disks
8) vgcfgrestore vg03 on new disks
9) mount vg03 lvols
10) restore backups
11) startup the database

For more info;-

http://docs.hp.com/en/5991-1236/When_Good_Disks_Go_Bad_WP.pdf

Aneesh

Re: Data Migration -- attempting vgexport/vgimport

D. Jackson_1 — Mon, 16 Nov 2009 23:29:36 GMT

If the planets align okay then you could just break the VG03 mirror and remirror to the bigger drive, do the same thing with the other disk once the mirrors are syncd. Really depends on how the VG was set up.

Re: Data Migration -- attempting vgexport/vgimport

Akif_1 — Wed, 18 Nov 2009 05:52:30 GMT

Hi All,

Find an enclosed detail file of above query ........

Rgd's