Useful shortcuts for vi editor

Thursday, 8 January 2015

How to define logic volume for oracle server?

1st step: Define physical volume (pv)
# pvcreate -f /dev/sda4

to check it;

# pvdisplay

2nd step: Define volume group (vg)

# vgcreate -s 16 /dev/my_vg_ora /dev/sda4
s; 
-s 16 (--physicalextentsize; 16 mb physical extent size)

to activate it;

# vgchange -a y /dev/my_vg_ora

to check it;

# vgdisplay

3rd step: Define logic volume (lv)

lvcreate -L 1024 -n example01 /dev/my_vg_ora

to check it;
# lvdisplay

4th step: Assign data file to tablespace

to do this step please refer to this entry

to check it;
# select * from dba_data_files;