ASM equilibrium problem
1. The following operations are performed in ASM:
SQL > show parameter power;NAME TYPE VALUE---asm_power_limit integer 1SQL > alter system set asm_power_limit=8;System altered. SQL > show parameter power;NAME TYPE VALUE---asm_power_limit integer 8SQL > select name,group_number from v$asm_diskgroup NAME GROUP_NUMBER---DATA 2CRS 1Elapsed: 00VOUL00UR 00.01
There is no record for querying v$asm_operation before adding disks:
SQL > select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=2;no rows selectedElapsed: 0015 0015 00.04
Perform the operation of adding a disk:
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 00 0 0Elapsed: 00:00:00.01
You can see that the oracle estimate is completed in 16 minutes.
View the process:
[root@rac12c2 ~] # ps-fu grid | grep arbgrid 7130 1 0 13:19? 00:00:01 asm_arb0_+ASM2
At the same time, check ASM's alert log: (delete disk)
SUCCESS: ALTER DISKGROUP DATA DROP DISK 'DATA_0002' / * ASMCA * / NOTE: Attempting voting file refresh on diskgroup DATANOTE: Refresh completed on diskgroup DATA. No voting file found.Mon Aug 31 14:47:56 2015NOTE: starting rebalance of group 2/0x8b529360 (DATA) at power 4Starting background process ARB0Mon Aug 31 14:47:56 2015ARB0 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 2015SUCCESS: ALTER DISKGROUP DATA DROP DISK 'DATA_0002' / * ASMCA * / NOTE: Attempting voting file refresh on diskgroup DATANOTE: Refresh completed on diskgroup DATA. No voting file found.Mon Aug 31 14:47:56 2015NOTE: starting rebalance of group 2/0x8b529360 (DATA) at power 4Starting background process ARB0Mon Aug 31 14:47:56 2015ARB0 started with pid=36, OS id=19042 NOTE: assigning ARB0 to group 2/0x8b529360 (DATA) with 4 parallel I/OsMon Aug 31 15:07:57 2015NOTE: GroupBlock outside rolling migration privileged regionNOTE: requesting all-instance membership refresh for group=2Mon Aug 31 15:07:57 2015GMON updating for reconfiguration, group 2 at 8 for pid 38 Osid 26808Mon Aug 31 15:07:57 2015NOTE: group 2 PST updated.SUCCESS: grp 2 disk DATA_0002 emptiedNOTE: erasing header (replicated) on grp 2 disk DATA_0002NOTE: erasing header on grp 2 disk DATA_0002NOTE: process _ x000_+asm1 (26808) initiating offline of disk 2.3986842548 (DATA_0002) with mask 0x7e in group 2 (DATA) without client assistingNOTE: initiating PST update: grp 2 (DATA), dsk = 2/0xeda263b4, mask = 0x6a, op = clearMon Aug 31 15:07:58 2015GMON updating disk modes for group 2 at 9 for pid 38 Osid 26808Mon Aug 31 15:07:58 2015NOTE: stopping process ARB0Mon Aug 31 15:07:58 2015NOTE: PST update grp = 2 completed successfully NOTE: initiating PST update: grp 2 (DATA), dsk = 2/0xeda263b4, mask = 0x7e, op = clearMon Aug 31 15:07:58 2015GMON updating disk modes for group 2 at 10 for pid 38, osid 26808Mon Aug 31 15:07:58 2015NOTE: cache closing disk 2 of grp 2: DATA_0002Mon Aug 31 15:07:58 2015NOTE: PST update grp = 2 completed successfully Mon Aug 31 15:07:58 2015GMON updating for reconfiguration Group 2 at 11 for pid 38, osid 26808Mon Aug 31 15:07:58 2015NOTE: cache closing disk 2 of grp 2: (not open) DATA_0002Mon Aug 31 15:07:58 2015NOTE: group 2 PST updated.Mon Aug 31 15:07:59 2015NOTE: membership refresh pending for group 2/0x8b529360 (DATA) Mon Aug 31 15:07:59 2015SUCCESS: rebalance completed for group 2/0x8b529360 (DATA) Mon Aug 31 15:07:59 2015GMON querying group 2 at 12 for pid 22, osid 12971GMON querying group 2 at 13 for pid 22 Osid 12971Mon Aug 31 15:07:59 2015NOTE: Disk DATA_0002 in mode 0x0 marked for de-assignmentSUCCESS: refreshed membership for 2/0x8b529360 (DATA) NOTE: Attempting voting file refresh on diskgroup DATANOTE: Refresh completed on diskgroup DATA. No voting file found.
Add disk: change asm_power_limit to 2
If the head_status status of the added disk is FORMER, clear the disk head with the following command:
Dd if=/dev/zero of=/dev/oracleasm/disks/DATA3 bs=1024k count=200
You can then discover the standby disk status CANDIDATE before performing the ADD operation.
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) 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)
