13518219792
1.以下操作均在ASM里面进行：
让客户满意是我们工作的目标，不断超越客户的期望值来自于我们对这个行业的热爱。我们立志把好的技术通过有效、简单的方式提供给客户，将通过不懈努力成为客户在信息化领域值得信任、有价值的长期合作伙伴，公司提供的服务项目有：空间域名、网络空间、营销软件、网站建设、广州网站维护、网站推广。
SQL> show parameter power; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ asm_power_limit integer 1 SQL> alter system set asm_power_limit=8; System altered. SQL> show parameter power; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ asm_power_limit integer 8 SQL> select name,group_number from v$asm_diskgroup; NAME GROUP_NUMBER ------------------------------ ------------ DATA 2 CRS 1 Elapsed: 00:00:00.01
添加磁盘以前查询v$asm_operation ,是没有记录的：
SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=2; no rows selected Elapsed: 00:00:00.04
执行添加磁盘的操作：
SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=2; INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES ---------- ----- ---- ---------- ---------- ---------- ---------- ----------- 1 REBAL WAIT 8 1 REBAL WAIT 8 2 REBAL RUN 8 52 4407 266 16 2 REBAL WAIT 8 0 0 0 0 Elapsed: 00:00:00.01
可以看到oracle 估算16分钟完成
查看进程：
[root@rac12c2 ~]# ps -fu grid | grep arb grid 7130 1 0 13:19 ? 00:00:01 asm_arb0_+ASM2
同时看ASM 的alert日志：（删除磁盘）
SUCCESS: ALTER DISKGROUP DATA DROP DISK 'DATA_0002' /* ASMCA */ NOTE: Attempting voting file refresh on diskgroup DATA NOTE: Refresh completed on diskgroup DATA. No voting file found. Mon Aug 31 14:47:56 2015 NOTE: starting rebalance of group 2/0x8b529360 (DATA) at power 4 Starting background process ARB0 Mon Aug 31 14:47:56 2015 ARB0 started with pid=36, OS id=19042 NOTE: assigning ARB0 to group 2/0x8b529360 (DATA) with 4 parallel I/Os [grid@rac12c1 trace]$ tail -f alert_+ASM1.log Mon Aug 31 14:47:55 2015 SUCCESS: ALTER DISKGROUP DATA DROP DISK 'DATA_0002' /* ASMCA */ NOTE: Attempting voting file refresh on diskgroup DATA NOTE: Refresh completed on diskgroup DATA. No voting file found. Mon Aug 31 14:47:56 2015 NOTE: starting rebalance of group 2/0x8b529360 (DATA) at power 4 Starting background process ARB0 Mon Aug 31 14:47:56 2015 ARB0 started with pid=36, OS id=19042 NOTE: assigning ARB0 to group 2/0x8b529360 (DATA) with 4 parallel I/Os Mon Aug 31 15:07:57 2015 NOTE: GroupBlock outside rolling migration privileged region NOTE: requesting all-instance membership refresh for group=2 Mon Aug 31 15:07:57 2015 GMON updating for reconfiguration, group 2 at 8 for pid 38, osid 26808 Mon Aug 31 15:07:57 2015 NOTE: group 2 PST updated. SUCCESS: grp 2 disk DATA_0002 emptied NOTE: erasing header (replicated) on grp 2 disk DATA_0002 NOTE: erasing header on grp 2 disk DATA_0002 NOTE: process _x000_+asm1 (26808) initiating offline of disk 2.3986842548 (DATA_0002) with mask 0x7e in group 2 (DATA) without client assisting NOTE: initiating PST update: grp 2 (DATA), dsk = 2/0xeda263b4, mask = 0x6a, op = clear Mon Aug 31 15:07:58 2015 GMON updating disk modes for group 2 at 9 for pid 38, osid 26808 Mon Aug 31 15:07:58 2015 NOTE: stopping process ARB0 Mon Aug 31 15:07:58 2015 NOTE: PST update grp = 2 completed successfully NOTE: initiating PST update: grp 2 (DATA), dsk = 2/0xeda263b4, mask = 0x7e, op = clear Mon Aug 31 15:07:58 2015 GMON updating disk modes for group 2 at 10 for pid 38, osid 26808 Mon Aug 31 15:07:58 2015 NOTE: cache closing disk 2 of grp 2: DATA_0002 Mon Aug 31 15:07:58 2015 NOTE: PST update grp = 2 completed successfully Mon Aug 31 15:07:58 2015 GMON updating for reconfiguration, group 2 at 11 for pid 38, osid 26808 Mon Aug 31 15:07:58 2015 NOTE: cache closing disk 2 of grp 2: (not open) DATA_0002 Mon Aug 31 15:07:58 2015 NOTE: group 2 PST updated. Mon Aug 31 15:07:59 2015 NOTE: membership refresh pending for group 2/0x8b529360 (DATA) Mon Aug 31 15:07:59 2015 SUCCESS: rebalance completed for group 2/0x8b529360 (DATA) Mon Aug 31 15:07:59 2015 GMON querying group 2 at 12 for pid 22, osid 12971 GMON querying group 2 at 13 for pid 22, osid 12971 Mon Aug 31 15:07:59 2015 NOTE: Disk DATA_0002 in mode 0x0 marked for de-assignment SUCCESS: refreshed membership for 2/0x8b529360 (DATA) NOTE: Attempting voting file refresh on diskgroup DATA NOTE: Refresh completed on diskgroup DATA. No voting file found.
添加磁盘：把asm_power_limit 改成2；
如果被添加磁盘的head_status 状态为FORMER ,用以下命令清除磁盘头：
dd if=/dev/zero of=/dev/oracleasm/disks/DATA3 bs=1024k count=200
然后可以发现备用磁盘状态CANDIDATE，再执行ADD操作。
SQL> ALTER DISKGROUP DATA ADD DISK '/dev/oracleasm/disks/DATA3' SIZE 30719M /* ASMCA */
Mon Aug 31 15:20:07 2015
NOTE: GroupBlock outside rolling migration privileged region
NOTE: Assigning number (2,2) to disk (/dev/oracleasm/disks/DATA3)
NOTE: requesting all-instance membership refresh for group=2
NOTE: Disk 2 in group 2 is assigned fgnum=3
NOTE: discarding redo for group 2 disk 2
NOTE: initializing header (replicated) on grp 2 disk DATA_0002
NOTE: initializing header on grp 2 disk DATA_0002
NOTE: requesting all-instance disk validation for group=2
Mon Aug 31 15:20:07 2015
NOTE: skipping rediscovery for group 2/0x8b529360 (DATA) on local instance.
Mon Aug 31 15:20:08 2015
NOTE: requesting all-instance disk validation for group=2
Mon Aug 31 15:20:08 2015
NOTE: skipping rediscovery for group 2/0x8b529360 (DATA) on local instance.
Mon Aug 31 15:20:08 2015
GMON updating for reconfiguration, group 2 at 14 for pid 31, osid 17642
Mon Aug 31 15:20:08 2015
NOTE: group 2 PST updated.
Mon Aug 31 15:20:08 2015
NOTE: membership refresh pending for group 2/0x8b529360 (DATA)
Mon Aug 31 15:20:08 2015
GMON querying group 2 at 15 for pid 22, osid 12971
NOTE: cache opening disk 2 of grp 2: DATA_0002 path:/dev/oracleasm/disks/DATA3
Mon Aug 31 15:20:09 2015
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
Mon Aug 31 15:20:09 2015
GMON querying group 2 at 16 for pid 22, osid 12971
Mon Aug 31 15:20:09 2015
SUCCESS: refreshed membership for 2/0x8b529360 (DATA)
Mon Aug 31 15:20:09 2015
SUCCESS: ALTER DISKGROUP DATA ADD DISK '/dev/oracleasm/disks/DATA3' SIZE 30719M /* ASMCA */
Mon Aug 31 15:20:09 2015
NOTE: starting rebalance of group 2/0x8b529360 (DATA) at power 2
Starting background process ARB0
Mon Aug 31 15:20:09 2015
ARB0 started with pid=36, OS id=30834
NOTE: assigning ARB0 to group 2/0x8b529360 (DATA) with 2 parallel I/Os
Mon Aug 31 15:20:24 2015
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
Mon Aug 31 15:37:16 2015
NOTE: GroupBlock outside rolling migration privileged region
NOTE: requesting all-instance membership refresh for group=2
Mon Aug 31 15:37:16 2015
NOTE: membership refresh pending for group 2/0x8b529360 (DATA)
Mon Aug 31 15:37:16 2015
GMON querying group 2 at 17 for pid 22, osid 12971
Mon Aug 31 15:37:16 2015
SUCCESS: refreshed membership for 2/0x8b529360 (DATA)
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA. No voting file found.
Mon Aug 31 15:42:24 2015
NOTE: stopping process ARB0
Mon Aug 31 15:42:25 2015
SUCCESS: rebalance completed for group 2/0x8b529360 (DATA)
