IBM-AIX裸设备添加表空间数据文
IBM-AIX裸设备添加表空间数据文
数据迁移的一些测试，在imp的时候遇到了IMP-00058、ORA-01653、IMP-00028错误，查看了下是表空间慢了，增加了几个数据文件。# lsvg
rootvg
oravg
arch
# lsvg oravg
VOLUME GROUP: oravg VG IDENTIFIER: 00036fea0000d400000001236d98af5f
VG STATE: active PP SIZE: 512 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 3537 (1810944 megabytes)
MAX LVs: 256 FREE PPs: 3228 (1652736 megabytes)
LVs: 78 USED PPs: 309 (158208 megabytes)
OPEN LVs: 54 QUORUM: 3 (Enabled)
TOTAL PVs: 4 VG DESCRIPTORS: 4
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 4 AUTO ON: no
Concurrent: Enhanced-Capable Auto-Concurrent: Disabled
VG Mode: Concurrent
Node ID: 3 Active Nodes: 4
MAX PPs per VG: 32768 MAX PVs: 1024
LTG size (Dynamic): 1024 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
# lsvg -l
0516-992 lsvg: Illegal combination of command line options.
Usage: lsvg [-o] [[-L] -n PVname]
lsvg [-L] [-i] [-M | -l | -p] VGname...
Lists the characteristics of a volume group.
# lsvg -l oravg
oravg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
ora_data001 raw 2 2 1 open/syncd N/A
ora_data002 raw 2 2 1 closed/syncd N/A
ora_data003 raw 2 2 1 closed/syncd N/A
ora_data004 raw 2 2 1 closed/syncd N/A
ora_data005 raw 2 2 1 closed/syncd N/A
ora_data006 raw 2 2 1 closed/syncd N/A
ora_data007 raw 2 2 1 closed/syncd N/A
ora_data008 raw 4 4 1 open/syncd N/A
ora_data009 raw 4 4 1 closed/syncd N/A
ora_data010 raw 4 4 1 closed/syncd N/A
ora_data011 raw 4 4 1 closed/syncd N/A
ora_data012 raw 4 4 1 open/syncd N/A
ora_data013 raw 4 4 1 open/syncd N/A
ora_data014 raw 4 4 1 open/syncd N/A
ora_data015 raw 4 4 1 closed/syncd N/A
ora_data016 raw 8 8 1 open/syncd N/A
ora_data017 raw 8 8 1 open/syncd N/A
ora_data018 raw 8 8 1 open/syncd N/A
ora_data019 raw 8 8 1 open/syncd N/A
ora_data020 raw 8 8 1 open/syncd N/A
ora_data021 raw 8 8 1 closed/syncd N/A
ora_data022 raw 8 8 1 closed/syncd N/A
ora_data023 raw 8 8 1 closed/syncd N/A
ora_data024 raw 8 8 1 open/syncd N/A
ora_data025 raw 8 8 1 open/syncd N/A
ora_data026 raw 8 8 1 open/syncd N/A
ora_data027 raw 8 8 1 open/syncd N/A
ora_data028 raw 8 8 1 open/syncd N/A
ora_data029 raw 8 8 1 open/syncd N/A
ora_data030 raw 8 8 1 open/syncd N/A
ora_data031 raw 8 8 1 closed/syncd N/A
ora_data032 raw 8 8 1 closed/syncd N/A
ora_data033 raw 8 8 1 closed/syncd N/A
lv_mndhb1 jfs 1 1 1 open/syncd N/A
lv_mndhb2 jfs 1 1 1 open/syncd N/A
lv_mndhb3 jfs 1 1 1 open/syncd N/A
lv_temp1_2046m raw 4 4 1 open/syncd N/A
lv_system_2046m raw 4 4 1 open/syncd N/A
lv_pwdfile_128m raw 1 1 1 closed/syncd N/A
lv_sysaux_2046m raw 4 4 1 open/syncd N/A
lv_temp2_2046m raw 4 4 1 closed/syncd N/A
lv_ocr1_320m raw 1 1 1 open/syncd N/A
lv_ocr2_320m raw 1 1 1 open/syncd N/A
lv_voting1_260m raw 1 1 1 open/syncd N/A
lv_voting2_260m raw 1 1 1 open/syncd N/A
lv_voting3_260m raw 1 1 1 open/syncd N/A
lv_undo1_4094m raw 8 8 1 open/syncd N/A
lv_undo2_4094m raw 8 8 1 open/syncd N/A
lv_temp_4094m raw 8 8 1 open/syncd N/A
lv_users_1022m raw 2 2 1 open/syncd N/A
lv_redo1_1_1022 raw 2 2 1 open/syncd N/A
lv_redo1_2_1022 raw 2 2 1 open/syncd N/A
lv_redo1_3_1022 raw 2 2 1 open/syncd N/A
lv_redo1_4_1022 raw 2 2 1 open/syncd N/A
lv_redo2_1_1022 raw 2 2 1 open/syncd N/A
lv_redo2_2_1022 raw 2 2 1 open/syncd N/A
lv_redo2_3_1022 raw 2 2 1 open/syncd N/A
lv_redo2_4_1022 raw 2 2 1 open/syncd N/A
lv_ctl1_320m raw 1 1 1 open/syncd N/A
lv_ctl2_320m raw 1 1 1 open/syncd N/A
lv_ctl3_320m raw 1 1 1 open/syncd N/A
lv_spfile_128m raw 1 1 1 closed/syncd N/A
lv_temp3_2046m raw 4 4 1 closed/syncd N/A
lv_undo1a_2046m raw 4 4 1 open/syncd N/A
lv_undo1b_2046m raw 4 4 1 closed/syncd N/A
lv_redo1_1a_1g raw 2 2 1 open/syncd N/A
lv_redo1_2a_1g raw 2 2 1 open/syncd N/A
lv_redo1_3a_1g raw 2 2 1 open/syncd N/A
lv_redo1_4a_1g raw 2 2 1 open/syncd N/A
lv_redo2_1a_1g raw 2 2 1 open/syncd N/A
lv_redo2_2a_1g raw 2 2 1 open/syncd N/A
lv_redo2_3a_1g raw 2 2 1 open/syncd N/A
lv_redo2_4a_1g raw 2 2 1 open/syncd N/A
lv_undo1c_2046m raw 4 4 1 closed/syncd N/A
lv_undo2a_2046m raw 4 4 1 open/syncd N/A
lv_undo2b_2046m raw 4 4 1 closed/syncd N/A
lv_undo2c_2046m raw 4 4 1 closed/syncd N/A
lv_system_2g raw 4 4 1 open/syncd N/A
# lslv ora_data021
LOGICAL VOLUME: ora_data021 VOLUME GROUP: oravg
LV IDENTIFIER: 00036fea0000d400000001236d98af5f.21 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: raw WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 512 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 8 PPs: 8
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 1024
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: NO
DEVICESUBTYPE : DS_LVZ
alter tablespace fc add datafile '/dev/rora_data021' size 4090m autoextend off;
alter tablespace fc add datafile '/dev/rora_data022' size 4090m autoextend off;
-The End-
评论暂时关闭