环境:PC 虚拟机 RAC ,本地硬盘,两个磁盘(500G和200G
ASMCMD> lsdsk -k
Total_MB Free_MB OS_MB Name Failgroup Failgroup_Type Library Label UDID Product Redund Path511997 355123 511997 DATADG_0002 DATADG_0002 REGULAR System UNKNOWN \\.\ORCLDISKDATA1
204797 141943 204797 DATADG_0000 DATADG_0000 REGULAR System UNKNOWN \\.\ORCLDISKDATA2
1021 763 1021 OCR_0000 OCR_0000 REGULAR System UNKNOWN \\.\ORCLDISKOCR0
2045 1711 2045 OCR_0001 OCR_0001 REGULAR System UNKNOWN \\.\ORCLDISKOCR1
2045 1711 2045 OCR_0002 OCR_0002 REGULAR System UNKNOWN \\.\ORCLDISKOCR2
ASMCMD>
SQL> alter diskgroup datadg drop disk DATADG_0000 rebalance power 22;
Diskgroup altered.
SQL> select * from gv$asm_operation;
INST_ID GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR
---------- ------------ ---------- -------- ---------- ---------- ----------
EST_WORK EST_RATE EST_MINUTES
---------- ---------- -----------
ERROR_CODE
--------------------------------------------------------------------------------
1 2 REBAL WAIT 22
2 2 REBAL RUN 22 22 537
62838 1585 39
INST_ID GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR
---------- ------------ ---------- -------- ---------- ---------- ----------
EST_WORK EST_RATE EST_MINUTES
---------- ---------- -----------
ERROR_CODE
--------------------------------------------------------------------------------
SQL> select * from gv$asm_operation;
INST_ID GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR
---------- ------------ ---------- -------- ---------- ---------- ----------
EST_WORK EST_RATE EST_MINUTES
---------- ---------- -----------
ERROR_CODE
--------------------------------------------------------------------------------
1 2 REBAL WAIT 22
2 2 REBAL RUN 22 22 1017
62842 1670 37
|
选择 | 名称 | 已分配的大小 (MB) | 已用空间 (MB) | 已用的已分配空间 (%)![]() | 自动扩展 | 空闲的已分配空间 (MB) | 状态 | 数据文件 | 类型 | 区管理 | 段管理 |
---|---|---|---|---|---|---|---|---|---|---|---|
UNDOTBS2 | 32,768.0 | 23.3 | ![]() ![]() | YES | 32,744.7 | ![]() | 1 | UNDO | LOCAL | MANUAL | |
MIS | 152,400.0 | 21,889.0 | ![]() ![]() ![]() | NO | 130,511.0 | ![]() | 1 | PERMANENT | LOCAL | AUTO | |
USERS | 5.0 | 1.3 | ![]() ![]() ![]() | YES | 3.7 | ![]() | 1 | PERMANENT | LOCAL | AUTO | |
TEMP | 48.0 | 15.0 | ![]() ![]() ![]() | YES | 33.0 | ![]() | 1 | TEMPORARY | LOCAL | MANUAL | |
SYSAUX | 670.0 | 633.1 | ![]() ![]() ![]() | YES | 36.9 | ![]() | 1 | PERMANENT | LOCAL | AUTO | |
SYSTEM | 720.0 | 710.6 | ![]() ![]() ![]() | YES | 9.4 | ![]() | 1 | PERMANENT | LOCAL | MANUAL | |
UNDOTBS1 | 32,768.0 | 32,766.9 | ![]() ![]() | YES | 1.0 | ![]() | 1 | UNDO | LOCAL | MANUAL |
![]() | ||||||||||||||||||||
| ![]() |
|