asm删除磁盘

11r2 asm和db 分离，如果想用asm 需要先安装grid。

安装grid时推荐添加 grid用户。

#su - grid

$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 24 12:41:59 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

SQL> conn /as
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where ::= [/][@]
::= [][/][@]
SQL> conn /as sysasm
Connected.

新增sysasm 角色，用于管理磁盘的增删和磁盘组的 online /offline等操作，如果使用sysdba会在alertlog中发出 警告信息。

SQL> select group_number,name,path,MOUNT_STATUS,HEADER_STATUS ,state from v$asm_disk ;
GROUP_NUMBER NAME PATH STATE HEADER_STATUS TOTAL_MB FREE_MB
------------ ----------- ----------------------------
0 /dev/rdsk/c0t0d0s6 NORMAL FORMER 0 0
0 /dev/rdsk/c0t1d0s6 NORMAL FORMER 0 0
0 /dev/rdsk/c1t0d0s6 NORMAL FORMER 0 0
0 /dev/rdsk/c1t1d0s6 NORMAL FORMER 0 0
1 DATA_0002 /dev/rdsk/c2t0d0s6 NORMAL MEMBER 102296 80665
1 DATA_0008 /dev/rdsk/c2t0d15s6 NORMAL MEMBER 102296 83777
1 DATA_0007 /dev/rdsk/c2t0d14s6 NORMAL MEMBER 102296 83772
1 DATA_0006 /dev/rdsk/c2t0d13s6 NORMAL MEMBER 102296 83773
1 DATA_0005 /dev/rdsk/c2t0d12s6 NORMAL MEMBER 102296 83770
1 DATA_0004 /dev/rdsk/c2t0d11s6 NORMAL MEMBER 102296 83775
1 DATA_0003 /dev/rdsk/c2t0d10s6 NORMAL MEMBER 102296 83772
1 DATA_0017 /dev/rdsk/c2t0d9s6 NORMAL MEMBER 102296 82405
1 DATA_0016 /dev/rdsk/c2t0d8s6 NORMAL MEMBER 102296 82163
1 DATA_0015 /dev/rdsk/c2t0d7s6 NORMAL MEMBER 102296 82165
1 DATA_0014 /dev/rdsk/c2t0d6s6 NORMAL MEMBER 102296 80670
1 DATA_0013 /dev/rdsk/c2t0d5s6 NORMAL MEMBER 102296 80670
1 DATA_0012 /dev/rdsk/c2t0d4s6 NORMAL MEMBER 102296 80675
1 DATA_0011 /dev/rdsk/c2t0d3s6 NORMAL MEMBER 102296 80670
1 DATA_0010 /dev/rdsk/c2t0d2s6 NORMAL MEMBER 102296 80671
1 DATA_0009 /dev/rdsk/c2t0d1s6 NORMAL MEMBER 102296 80669

SQL> alter diskgroup data drop disk DATA_0008;

Diskgroup altered.

SQL> c/008/007
1* alter diskgroup data drop disk DATA_0007
SQL> /

Diskgroup altered.

SQL> c/07/06
1* alter diskgroup data drop disk DATA_0006
SQL> /

Diskgroup altered.

SQL> c/06/05
1* alter diskgroup data drop disk DATA_0005
SQL> /

Diskgroup altered.

SQL> c/05/04
1* alter diskgroup data drop disk DATA_0004
SQL> /

Diskgroup altered.

SQL> c/04/03
1* alter diskgroup data drop disk DATA_0003
SQL> /

Diskgroup altered.

SQL> l
1* alter diskgroup data drop disk DATA_0003
SQL> c/03/17
1* alter diskgroup data drop disk DATA_0017
SQL> /

Diskgroup altered.

SQL> c/17/16
1* alter diskgroup data drop disk DATA_0016
SQL> /

Diskgroup altered.

SQL> c/16/15
1* alter diskgroup data drop disk DATA_0015
SQL> /

Diskgroup altered.

---查看磁盘状态

SQL> select name,path,state,total_mb,free_mb from v$asm_disk;

NAME PATH STATE TOTAL_MB FREE_MB
---------------------------------------- ---------------------------------------- ---------------- ---------- ----------
/dev/rdsk/c0t0d0s6 NORMAL 0 0
/dev/rdsk/c0t1d0s6 NORMAL 0 0
/dev/rdsk/c1t0d0s6 NORMAL 0 0
/dev/rdsk/c1t1d0s6 NORMAL 0 0
DATA_0002 /dev/rdsk/c2t0d0s6 NORMAL 102296 80665
DATA_0008 /dev/rdsk/c2t0d15s6 DROPPING 102296 83777
DATA_0007 /dev/rdsk/c2t0d14s6 DROPPING 102296 83772
DATA_0006 /dev/rdsk/c2t0d13s6 DROPPING 102296 83773
DATA_0005 /dev/rdsk/c2t0d12s6 DROPPING 102296 83770
DATA_0004 /dev/rdsk/c2t0d11s6 DROPPING 102296 83775
DATA_0003 /dev/rdsk/c2t0d10s6 DROPPING 102296 83772
DATA_0017 /dev/rdsk/c2t0d9s6 DROPPING 102296 82405
DATA_0016 /dev/rdsk/c2t0d8s6 DROPPING 102296 82163
DATA_0015 /dev/rdsk/c2t0d7s6 DROPPING 102296 82165
DATA_0014 /dev/rdsk/c2t0d6s6 NORMAL 102296 80670
DATA_0013 /dev/rdsk/c2t0d5s6 NORMAL 102296 80670
DATA_0012 /dev/rdsk/c2t0d4s6 NORMAL 102296 80675
DATA_0011 /dev/rdsk/c2t0d3s6 NORMAL 102296 80670
DATA_0010 /dev/rdsk/c2t0d2s6 NORMAL 102296 80671
DATA_0009 /dev/rdsk/c2t0d1s6 NORMAL 102296 80669

20 rows selected.

---查看rebalance的并行粒度

SQL> show parameter power

NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
asm_power_limit integer 1

SQL> select SOFAR/EST_WORK ,EST_MINUTES from v$asm_operation;

SOFAR/EST_WORK EST_MINUTES
-------------- -----------
.11663194 18

---修改并行为5

SQL> alter diskgroup data rebalance power 5;


Diskgroup altered.

--估算 rebalance花费时间
SQL> select SOFAR/EST_WORK ,EST_MINUTES,power from v$asm_operation;

SOFAR/EST_WORK EST_MINUTES POWER
-------------- ----------- ----------
.028088422 15 5

SQL> alter diskgroup data rebalance power 2;

Diskgroup altered.

SQL> select round(100*SOFAR/EST_WORK ,2),EST_MINUTES,power from v$asm_operation;

ROUND(100*SOFAR/EST_WORK,2) EST_MINUTES POWER
--------------------------- ----------- ----------
.56 13 2

SQL> set pages 999 lines 170

---查看asm实例的 后台进程
SQL> select name,description from v$bgprocess where paddr <>'00';

NAME DESCRIPTION
---------- --------------------------------------------------
PMON process cleanup
VKTM Virtual Keeper of TiMe process
GEN0 generic0
DIAG diagnosibility process
PSP0 process spawner 0
DIA0 diagnosibility process 0
MMAN Memory Manager
DBW0 db writer process 0
LGWR Redo etc.
CKPT checkpoint
SMON System Monitor Process
RBAL ASM Rebalance master
ARB0 ASM Rebalance 0
ARB1 ASM Rebalance 1
ARB2 ASM Rebalance 2
ARB3 ASM Rebalance 3
ARB4 ASM Rebalance 4
ASMB ASM Background
GMON diskgroup monitor
MMON Manageability Monitor Process
MMNL Manageability Monitor Process 2

21 rows selected.

---查看操作系统的进程

--可以看到 power5 时 RBAL 开启了5个进程 ARB0-4，但从从新power 2 时 ,arb 0 2 3 4 ,在操作系统中已经看不到。

SQL> host ps -ef | grep -i asm
grid 10808 10807 0 12:58:54 ? 0:01 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 1206 1 0 14:25:01 ? 0:13 asm_pmon_+ASM
grid 1212 1 0 14:25:01 ? 0:02 asm_gen0_+ASM
grid 10795 1 0 12:57:51 ? 0:03 asm_arb1_+ASM
grid 1208 1 0 14:25:01 ? 0:25 asm_vktm_+ASM
grid 1214 1 0 14:25:01 ? 0:02 asm_diag_+ASM
grid 1216 1 0 14:25:01 ? 0:02 asm_psp0_+ASM
grid 1218 1 0 14:25:01 ? 0:34 asm_dia0_+ASM
grid 1220 1 0 14:25:01 ? 0:02 asm_mman_+ASM
grid 1222 1 0 14:25:01 ? 0:03 asm_dbw0_+ASM
grid 1224 1 0 14:25:01 ? 0:09 asm_lgwr_+ASM
grid 1226 1 0 14:25:01 ? 0:02 asm_ckpt_+ASM
grid 1228 1 0 14:25:01 ? 0:01 asm_smon_+ASM
grid 1230 1 0 14:25:01 ? 0:13 asm_rbal_+ASM
grid 1232 1 0 14:25:01 ? 0:07 asm_gmon_+ASM
grid 1234 1 0 14:25:01 ? 0:03 asm_mmon_+ASM
grid 1236 1 0 14:25:01 ? 0:07 asm_mmnl_+ASM
oracle 1313 1 0 14:25:28 ? 0:08 ora_asmb_wcdma
grid 1317 1 0 14:25:28 ? 0:19 oracle+ASM_asmb_xxxx(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 10821 10820 0 13:00:38 pts/1 0:00 grep -i asm
grid 10793 1 0 12:57:50 ? 0:03 asm_arb0_+ASM

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25093763/viewspace-1043592/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25093763/viewspace-1043592/