甜橘子，专注成都网站制作网站设计与营销型网站建设与优化

QQ :532337155
电话：028-86922220
 
成都网站建设设计

将想法与焦点和您一起共享

ASM平衡问题

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)


新闻标题：ASM平衡问题
网页URL：http://chengdu.cdxwcx.cn/article/jpdgcs.html

其他资讯