一、项目背景描述1、OSS现网测试数据库因大量小事物频繁提交运行非常缓慢。经分析为DS3950存储所在磁盘I/O存在瓶颈，大量等待事件，性能受限。另外，开发同事没有优化意识，没将小事物做成批量提交方式。2、在DS3950上，9块600G硬盘(8块+1块热备)做了RAID5阵列，lun01，lun02，lun03，lun04，均为200G，映射给OSS数据库服务器使用。3、在操作系统上，lun01，lun02构成了vg_ossdb卷组，vg_ossdb下只有一个LV－－lvoradata挂载在/oradata上。最近因数据增长过快，又将lun03，lun04以vgextend方式扩到了vg_ossdb卷组中去，但尚未扩大lvoradata。4、在数据库上，Oracle软件安装在本地磁盘/oracle上，数据库安装在/oradata上。

二、项目改造计划及步骤1、停掉数据库，将/oradata目录全备份到另一台备用PC机器上。2、由于DS3950存储空闲空很大，可修改其阵列级别从RAID5变为RAID10。3、由于lun03，lun04尚未使用，领导要求先从vg_ossdb中移除lun03，lun04，并在存储上unmap掉，便于阵列级别变更。4、由DBA优化SQL，将小事物尽量做到批量提交方式。

三、系统环境及数据版本说明[root@ol64 /]# cat /etc/issueOracle Linux Server release 6.4Kernel on an m

[root@ol64 /]# uname -aLinux ol64.com 2.6.39-400.17.1.el6uek.x86_64 #1 SMP Fri Feb 22 18:16:18 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS for Linux: Version 11.2.0.4.0 - ProductionNLSRTL Version 11.2.0.4.0 - Production

四、改造过程中因误用vgremove将vg_ossdb卷组删除，而其本意是想用vgreduce移除/dev/sdd，/dev/sde的。[root@ol64 /]# umount /oradata/ #卸载文件系统[root@ol64 /]# vgchange -an /dev/vg_ossdb #将卷组置于非激活状态0 logical volume(s) in volume group "vg_ossdb" now active[root@ol64 /]# vgremove vg_ossdb /dev/sdb /dev/sdc /dev/sdd /dev/sde #误用vgremove命令删除了vg_ossdbDo you really want to remove volume group "vg_ossdb" containing 1 logical volumes? [y/n]: yDo you really want to remove active logical volume lvoradata? [y/n]: yLogical volume "lvoradata" successfully removedVolume group "vg_ossdb" successfully removedVolume group "sdb" not foundVolume group "sdc" not foundVolume group "sdd" not foundVolume group "sde" not found##################################################################正确的操作应该是用vgreduce命令从vg_ossdb中移除/dev/sdd和/dev/sde[root@ol64 /]# vgreduce vg_ossdb /dev/sddRemoved "/dev/sdd" from volume group "vg_ossdb"[root@ol64 /]# vgreduce vg_ossdb /dev/sdeRemoved "/dev/sde" from volume group "vg_ossdb"#################################################################再用pvremove命令移除/dev/sdd和/dev/sde[root@ol64 ~]# pvremove /dev/sddLabels on physical volume "/dev/sdd" successfully wiped[root@ol64 ~]# pvremove /dev/sdeLabels on physical volume "/dev/sde" successfully wiped

[root@ol64 ~]# pvdisplay #发现/dev/sdb和/dev/sdc所在VG Name为空，冒汗ing.--- Physical volume ---PV Name /dev/sda2VG Name vg_ol64PV Size 199.51 GiB / not usable 3.00 MiBAllocatable yes PE Size 4.00 MiBTotal PE 51074Free PE 33660Allocated PE 17414PV UUID 0dyB8L-p7ZM-Mkcw-76ae-DXPh-U6zg-9kIQ8z

"/dev/sdb" is a new physical volume of "200.00 GiB"--- NEW Physical volume ---PV Name /dev/sdbVG Name PV Size 200.00 GiBAllocatable NOPE Size 0 Total PE 0Free PE 0Allocated PE 0PV UUID Ui9wea-II1q-KOx0-96pA-4epf-9hlc-4NFDJF

"/dev/sdc" is a new physical volume of "200.00 GiB"--- NEW Physical volume ---PV Name /dev/sdcVG Name PV Size 200.00 GiBAllocatable NOPE Size 0 Total PE 0Free PE 0Allocated PE 0PV UUID 4VKCJ9-G6kL-QJgg-Titf-UNA8-d3QZ-ZTES3P

[root@ol64 ~]# vgscan #vgscan时找不到vg_ossdb信息，心跳加速，冒汗ing.Reading all physical volumes. This may take a while...Found volume group "vg_ol64" using metadata type lvm2

[root@ol64 ~]# lvscan #lvscan时找不到lvoradata信息，大脑一片空白，快要晕倒.ACTIVE '/dev/vg_ol64/lvopt' [10.01 GiB] inheritACTIVE '/dev/vg_ol64/lvroot' [40.01 GiB] inheritACTIVE '/dev/vg_ol64/lvswap' [8.00 GiB] inheritACTIVE '/dev/vg_ol64/lvhome' [10.01 GiB] inherit

我怎么会用vgremove命令？？完了！！！vg_ossdb被我误删除了。赶紧google和baidu上搜索vg被删除后如何恢复，可压根找不到相关资料。冷静下来后开始思考/etc/lvm/目录下各文件用途。