Requirement:-
------------------
One of the database
mount point /u02/oradata needs more space.
Current size of
/u02/oradata:200 GB
Free space available
on the server:255 GB
Do the following to
accomplish the requirement.
---------------------------------------------------------------
1.Setup an LVM volume
with the available free space .ie;255 GB.
2.Shut down application and DB , backup the mount
point.
3.Mount the lvm volume
as /u02/oradata.
4.Restore the backup.
5.Verify the data.
6.Destroy the old
/u02/oradata volume and add to LVM and extend the same online.
New volume be /dev/sda11 ---255 GB
/u02/oradata be /dev/sda8
---200 GB
1.Setup LVM with
/dev/sda11
--------------------------------------
Change partition id to
8e
# pvcreate /dev/sda11
# pvdisplay
# vgcreate vg0
/dev/sda11
# vgscan
# vgdisplay vg0
# lvcreate -l
PE vg0 --name
lv0
# lvdisplay /dev/vg0/lv0
# mkfs.ext3 /dev/vg0/lv0
# mount
/dev/vg0/lv0 /bkp_u02_oradata
2.Backup the data
----------------------------
Shutdown DB then
Backup data from /u02/oradata
(/dev/sda8) to /bkp_u02_oradata(/dev/vg0/lv0)
# tar -cvpf /bkp_u02_oradata/u02_oradata.tar /u02/oradata
# umount /dev/sda8
# mount /dev/vg0/lv0
/u02/oradata
3.Restore data
-----------------------
# tar -xvpf /bkp_u02_oradata/u02_oradata.tar
4.Entry in fstab
---------------------
Copy the current file
# cp /etc/fstab
/etc/fstab.02May12
# vi /etc/fstab and add the following entry.
/dev/vg0/lv0 /u02/oradata ext3 defaults 0 0
5.Verify the data by
starting the DB.
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Add /dev/sda8 to
LVM and grow /dev/vg0/lv0 online.
# pvcreate /dev/sda8
# pvdisplay
# vgextend vg0
/dev/sda8
# vgdisplay vg0
# lvdisplay /dev/vg0/lv0
# lvextend -L+size
vg0 /dev/vg0/lv0
# resize2fs /dev/vg0/lv0
# lvdisplay /dev/vg0/lv0
