RAC 增加4块 asm 磁盘

增加磁盘之前的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
已标记关键词 清除标记
相关推荐
<p> <b><span style="background-color:#FFE500;">【超实用课程内容】</span></b> </p> <p> <br /> </p> <p> <br /> </p> <p> 本课程内容包含讲解<span>解读Nginx的基础知识,</span><span>解读Nginx的核心知识、带领学员进行</span>高并发环境下的Nginx性能优化实战,让学生能够快速将所学融合到企业应用中。 </p> <p> <br /> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><br /> </b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><span style="background-color:#FFE500;">【课程如何观看?】</span></b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> PC端:<a href="https://edu.csdn.net/course/detail/26277"><span id="__kindeditor_bookmark_start_21__"></span></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 移动端:CSDN 学院APP(注意不是CSDN APP哦) </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 本课程为录播课,课程永久有效观看时长,大家可以抓紧时间学习后一起讨论哦~ </p> <p style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <br /> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <strong><span style="background-color:#FFE500;">【学员专享增值服务】</span></strong> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b>源码开放</b> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 课件、课程案例代码完全开放给你,你可以根据所学知识,自行修改、优化 </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 下载方式:电脑登录<a href="https://edu.csdn.net/course/detail/26277"></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a>,播放页面右侧点击课件进行资料打包下载 </p> <p> <br /> </p> <p> <br /> </p> <p> <br /> </p>
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页