目前的现状:
tms2006的表空间 147240MB 已使用 114051 MB
索引数据和业务数据都存放于此表空间上。
使用的数据文件如下:
SQL>select * from v$datafile;
/dev/vgora/rlvora_4g_001 至 rlvora_4g_039
逻辑卷组 vgora 的信息如下:
tmsdb1[/]# vgdisplay -v vgora
LV Name /dev/vgora/lvora_4g_001
LV Status available/syncd
LV Size (Mbytes) 4096
Current LE 128
Allocated PE 128
Used PV 1
......
......
......
......
LV Name /dev/vgora/lvora_4g_149
LV Status available/syncd
LV Size (Mbytes) 4096
Current LE 128
Allocated PE 128
Used PV 1
--- Physical volumes ---
PV Name /dev/dsk/c6t0d2
PV Name /dev/dsk/c8t0d2 Alternate Link
PV Name /dev/dsk/c10t0d2 Alternate Link
PV Name /dev/dsk/c12t0d2 Alternate Link
PV Status available
Total PE 6399
Free PE 0
Autoswitch On
PV Name /dev/dsk/c6t0d3
PV Name /dev/dsk/c8t0d3 Alternate Link
PV Name /dev/dsk/c10t0d3 Alternate Link
PV Name /dev/dsk/c12t0d3 Alternate Link
PV Status available
Total PE 6399
Free PE 0
Autoswitch On
PV Name /dev/dsk/c6t0d4
PV Name /dev/dsk/c8t0d4 Alternate Link
PV Name /dev/dsk/c10t0d4 Alternate Link
PV Name /dev/dsk/c12t0d4 Alternate Link
PV Status available
Total PE 6399
Free PE 125
Autoswitch On
物理卷组
/dev/dsk/c6t0d2
/dev/dsk/c6t0d3
/dev/dsk/c6t0d4
的信息如下:
tmsdb1[/]#pvdisplay -v /dev/dsk/c6t0d2 |more
--- Physical volumes ---
PV Name /dev/dsk/c6t0d2
PV Name /dev/dsk/c8t0d2 Alternate Link
PV Name /dev/dsk/c10t0d2 Alternate Link
PV Name /dev/dsk/c12t0d2 Alternate Link
VG Name /dev/vgora
PV Status available
Allocatable yes
VGDA 2
Cur LV 50
PE Size (Mbytes) 32
Total PE 6399
Free PE 0
Allocated PE 6399
Stale PE 0
IO Timeout (Seconds) default
Autoswitch On
--- Distribution of physical volume ---
LV Name LE of LV PE for LV
/dev/vgora/lvora_4g_001 128 128
/dev/vgora/lvora_4g_002 128 128
/dev/vgora/lvora_4g_003 128 128
......
......
......
/dev/vgora/lvora_4g_048 128 128
/dev/vgora/lvora_4g_049 128 128
/dev/vgora/lvora_4g_050 127 127
--- Physical extents ---
PE Status LV LE
0000 current /dev/vgora/lvora_4g_001 0000
0001 current /dev/vgora/lvora_4g_001 0001
......
......
......
6395 current /dev/vgora/lvora_4g_050 0123
6396 current /dev/vgora/lvora_4g_050 0124
6397 current /dev/vgora/lvora_4g_050 0125
6398 current /dev/vgora/lvora_4g_050 0126
tmsdb1[/]#pvdisplay -v /dev/dsk/c6t0d3 |more
--- Physical volumes ---
PV Name /dev/dsk/c6t0d3
PV Name /dev/dsk/c8t0d3 Alternate Link
PV Name /dev/dsk/c10t0d3 Alternate Link
PV Name /dev/dsk/c12t0d3 Alternate Link
VG Name /dev/vgora
PV Status available
Allocatable yes
VGDA 2
Cur LV 51
PE Size (Mbytes) 32
Total PE 6399
Free PE 0
Allocated PE 6399
Stale PE 0
IO Timeout (Seconds) default
Autoswitch On
--- Distribution of physical volume ---
LV Name LE of LV PE for LV
/dev/vgora/lvora_4g_050 1 1
/dev/vgora/lvora_4g_051 128 128
/dev/vgora/lvora_4g_052 128 128
......
......
......
/dev/vgora/lvora_4g_098 128 128
/dev/vgora/lvora_4g_099 128 128
/dev/vgora/lvora_4g_100 126 126
--- Physical extents ---
PE Status LV LE
0000 current /dev/vgora/lvora_4g_050 0127
0001 current /dev/vgora/lvora_4g_051 0000
0002 current /dev/vgora/lvora_4g_051 0001
......
......
......
6396 current /dev/vgora/lvora_4g_100 0123
6397 current /dev/vgora/lvora_4g_100 0124
6398 current /dev/vgora/lvora_4g_100 0125
tmsdb1[/]#pvdisplay -v /dev/dsk/c6t0d4 |more
--- Physical volumes ---
PV Name /dev/dsk/c6t0d4
PV Name /dev/dsk/c8t0d4 Alternate Link
PV Name /dev/dsk/c10t0d4 Alternate Link
PV Name /dev/dsk/c12t0d4 Alternate Link
VG Name /dev/vgora
PV Status available
Allocatable yes
VGDA