RAC 增加4块 asm 磁盘

姚远ACE 2020-11-23 20:14:10

125

分类专栏： oracle # RAC

本文链接：https://blog.csdn.net/weixin_43424368/article/details/110005847

版权

增加磁盘之前的asm状态

ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512             512   4096  4194304   8388592  4669376          2097148         1286114              0             Y  DATA/
ASMCMD> lsdsk
Path
/dev/asm-disk1
/dev/asm-disk2
/dev/asm-disk3
/dev/asm-disk4


Col path form a20;
set linesize 200
SQL>  select name,STATE,FAILGROUP,PATH,MOUNT_STATUS from v$asm_disk;

NAME			       STATE	FAILGROUP		       PATH		    MOUNT_S
------------------------------ -------- ------------------------------ -------------------- -------
			       NORMAL				       /dev/asm-disk7	    CLOSED
			       NORMAL				       /dev/asm-disk6	    CLOSED
			       NORMAL				       /dev/asm-disk8	    CLOSED
			       NORMAL				       /dev/asm-disk5	    CLOSED
DATA_0003		       NORMAL	DATA_0003		       /dev/asm-disk4	    CACHED
DATA_0002		       NORMAL	DATA_0002		       /dev/asm-disk3	    CACHED
DATA_0001		       NORMAL	DATA_0001		       /dev/asm-disk2	    CACHED
DATA_0000		       NORMAL	DATA_0000		       /dev/asm-disk1	    CACHED

SQL>  show parameter power

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

把ASM_POWER_LIMIT 这个参数改到最大

SQL> Alter SYSTEM set ASM_POWER_LIMIT =11;

System altered.

增加4块磁盘

SQL> 
alter diskgroup data add disk
 '/dev/asm-disk5' name DATA_0004,
  '/dev/asm-disk6' name DATA_0005,
   '/dev/asm-disk7' name DATA_0006,
    '/dev/asm-disk8' name DATA_0007;

增加之后的磁盘空间，可以看到增加了一倍。

ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB   Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  Y         512             512   4096  4194304  16777184  13057720          2097148         5480286              0             Y  DATA/
ASMCMD>

查看操作需要的时间

SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;

   INST_ID OPERA STAT	   POWER      SOFAR   EST_WORK	 EST_RATE EST_MINUTES
---------- ----- ---- ---------- ---------- ---------- ---------- -----------
	 1 REBAL WAIT	      11	  0	     0		0	    0
	 1 REBAL RUN	      11      12447	498551	     5419	   89
	 1 REBAL DONE	      11	  0	     0		0	    0
	 1 REBAL DONE	      11	  0	     0		0	    0
	 2 REBAL WAIT	      11
	 2 REBAL WAIT	      11
	 2 REBAL WAIT	      11
	 2 REBAL WAIT	      11

8 rows selected.

SQL> !date;
Mon Nov 23 20:04:42 CST 2020

SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;

   INST_ID OPERA STAT	   POWER      SOFAR   EST_WORK	 EST_RATE EST_MINUTES
---------- ----- ---- ---------- ---------- ---------- ---------- -----------
	 1 REBAL WAIT	      11	  0	     0		0	    0
	 1 REBAL RUN	      11      48285	498551	     4983	   90
	 1 REBAL DONE	      11	  0	     0		0	    0
	 1 REBAL DONE	      11	  0	     0		0	    0
	 2 REBAL WAIT	      11
	 2 REBAL WAIT	      11
	 2 REBAL WAIT	      11
	 2 REBAL WAIT	      11

8 rows selected.

SQL> !date;
Mon Nov 23 20:11:44 CST 2020

姚远ACE

CSDN认证博客专家 ACE 华为云 MVP

Oracle ACE，华为云 MVP，Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890；获得过两次国家部级科技进步奖；发明过两项计算机专利。微信：yaoyuanace 邮箱：yaoyuanace（at）qq.com