Shulou(Shulou.com)06/01 Report--

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)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.