oracle数据库增加表空间

1、查看vg_data的空间是否可用
A3A-GLDB1:~ # vgdisplay vg_data
  --- Volume group ---
  VG Name               vg_data
  System ID            
  Format                lvm2
  Metadata Areas        1
  Metadata Sequence No  44
  VG Access             read/write
  VG Status             resizable
  MAX LV                0
  Cur LV                33
  Open LV               33
  Max PV                0
  Cur PV                1
  Act PV                1
  VG Size               1.50 TB
  PE Size               4.00 MB
  Total PE              394275
  Alloc PE / Size       89358 / 349.05 GB
  Free  PE / Size       304917 / 1.16 TB
  VG UUID               6TsbqL-MdEp-KcHz-kB0z-RGsO-j0bB-o2OrF8
2、创建LV
lvcreate -L 11000 -n  lv_imp_data100 /dev/vg_data

lvcreate -L 11000 -n  lv_imp_data67 /dev/vg_data

lvcreate -L 11000 -n  lv_imp_data68 /dev/vg_data


lrwxrwxrwx 1 root root 33 2011-12-23 02:10 lv_tmp_data11 -> /dev/mapper/vg_data-lv_tmp_data11
lrwxrwxrwx 1 root root 33 2011-12-23 02:10 lv_tmp_data12 -> /dev/mapper/vg_data-lv_tmp_data12
lrwxrwxrwx 1 root root 33 2011-12-23 02:10 lv_tmp_data13 -> /dev/mapper/vg_data-lv_tmp_data13


lvcreate -L 11000 -n  lv_tmp_data14 /dev/vg_data

lvcreate -L 11000 -n  lv_tmp_data15 /dev/vg_data

lvcreate -L 11000 -n  lv_tmp_data16 /dev/vg_data

3、赋予权限

chown oracle:dba /dev/mapper/vg_data-lv_imp_data100

chmod 660 /dev/mapper/vg_data-lv_imp_data100

chown oracle:dba /dev/mapper/vg_data-lv_imp_data67

chmod 660 /dev/mapper/vg_data-lv_imp_data67

chown oracle:dba /dev/mapper/vg_data-lv_imp_data68

chmod 660 /dev/mapper/vg_data-lv_imp_data68


chown oracle:dba /dev/mapper/vg_data-lv_tmp_data14

chmod 660 /dev/mapper/vg_data-lv_tmp_data14

chown oracle:dba /dev/mapper/vg_data-lv_tmp_data15

chmod 660 /dev/mapper/vg_data-lv_tmp_data15

chown oracle:dba /dev/mapper/vg_data-lv_tmp_data16

chmod 660 /dev/mapper/vg_data-lv_tmp_data16

4、扩展表空间
alter tablespace MTV_NEWTEMP add datafile '/dev/vg_data/lv_imp_data100' size 10240M;

alter system MTV_NEWTEMP add tempfile '/dev/vg_data/lv_tmp_data14' size 10240M;

alter tablespace MTV_NEWTEMP add tempfile '/dev/vg_data/lv_tmp_data14' size 10240M autoextend off;

alter tablespace MTV_NEWTEMP add tempfile '/dev/vg_data/lv_tmp_data15' size 10240M autoextend off;

alter tablespace MTV_NEWTEMP add tempfile '/dev/vg_data/lv_tmp_data16' size 10240M autoextend off;



alter tablespace MTV_SOURCE add datafile '/dev/vg_data/lv_imp_data67' size 10240M;

alter tablespace MTV_SOURCE add datafile '/dev/vg_data/lv_imp_data68' size 10240M;

5、查看表空间文件
select * from DBA_DATA_FILES where tablespace_name = 'IMAP_DB';