查看lv信息,与用户沟通,增加5个lv,每个lv留2M不创建
# lslv lv_xyy161_12g (查看lv_xyy161_12g为例子)
LOGICAL VOLUME: lv_xyy161_12g VOLUME GROUP: xyyvg
LV IDENTIFIER: 00c82ca000004c0000000127838b7269.203 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: raw WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 256 megabyte(s)
COPIES: 1 SCHED POLICY: striped
LPs: 48 PPs: 48
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: maximum RELOCATABLE: no
INTRA-POLICY: middle UPPER BOUND: 12
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes (superstrict)
Serialize IO ?: NO
STRIPE WIDTH: 12
STRIPE SIZE: 1m
DEVICESUBTYPE : DS_LVZ
lslv lv_xyy162_12g
lslv lv_xyy163_12g
lslv lv_xyy164_12g
lslv lv_xyy165_12g
增加temp表空间temp_file
alter tablespace temp add tempfile '/dev/rlv_xyy161_12g' size 12286m autoextend off;
alter tablespace temp add tempfile '/dev/rlv_xyy162_12g' size 12286m autoextend off;
alter tablespace temp add tempfile '/dev/rlv_xyy163_12g' size 12286m autoextend off;
alter tablespace temp add tempfile '/dev/rlv_xyy164_12g' size 12286m autoextend off;
alter tablespace temp add tempfile '/dev/rlv_xyy165_12g' size 12286m autoextend off;
增加完毕后,查看temp表空间使用情况