签到成功

知道了

CNDBA社区CNDBA社区

ASM 磁盘组管理

2017-05-06 12:40 1880 0 原创 Oracle 11g
作者： leo
本文链接：http://www.cndba.cn/leo1990/article/1904
1 创建普通磁盘组 
SQL> create diskgroup leo normal redundancy  disk '/dev/asm-diski', '/dev/asm-diskj';

Diskgroup created.

SQL> select group_number,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB NAME			   FAILGROUP			  PATH
------------ ----------- ---------- ------------------------------ ------------------------------ 
	   0	       8	  0								  /dev/asm-diskl
	   0	      10	  0								  /dev/asm-diskk
	   1	       0      10240 DATA_0000			   DATA_0000			  /dev/asm-diske
	   1	       1      10240 DATA_0001			   DATA_0001			  /dev/asm-diskf
	   2	       1      10240 FRA_0001			   FRA_0001			  /dev/asm-diskh
	   2	       0      10240 FRA_0000			   FRA_0000			  /dev/asm-diskg
	   3	       1       2048 OCRVOTING_0001		   OCRVOTING_0001		  /dev/asm-diskc
	   3	       0       2048 OCRVOTING_0000		   OCRVOTING_0000		  /dev/asm-diskb
	   3	       2       2048 OCRVOTING_0002		   OCRVOTING_0002		  /dev/asm-diskd
	   4	       1       1024 LEO_0001			   LEO_0001			  /dev/asm-diskj
	   4	       0       1024 LEO_0000			   LEO_0000			  /dev/asm-diski

11 rows selected.

2 创建指定Failgroup 的磁盘组
http://www.cndba.cn/leo1990/article/1904http://www.cndba.cn/leo1990/article/1904http://www.cndba.cn/leo1990/article/1904http://www.cndba.cn/leo1990/article/1904

SQL> create diskgroup nancy normal redundancy
  failgroup fg1 disk
'/dev/asm-diskk' name nancy_fg1
  failgroup fg2 disk
    '/dev/asm-diskl' name nancy_fg2
  attribute 'au_size'='4M',
    'compatible.asm' = '11.2', 
'compatible.rdbms' = '11.2';   

Diskgroup created.

SQL> select group_number,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB NAME			   FAILGROUP			  PATH
------------ ----------- ---------- ------------------------------ ------------------------------
	   1	       1      10240 DATA_0001			   DATA_0001			  /dev/asm-diskf
	   1	       0      10240 DATA_0000			   DATA_0000			  /dev/asm-diske
	   2	       0      10240 FRA_0000			   FRA_0000			  /dev/asm-diskg
	   2	       1      10240 FRA_0001			   FRA_0001			  /dev/asm-diskh
	   3	       2       2048 OCRVOTING_0002		   OCRVOTING_0002		  /dev/asm-diskd
	   3	       0       2048 OCRVOTING_0000		   OCRVOTING_0000		  /dev/asm-diskb
	   3	       1       2048 OCRVOTING_0001		   OCRVOTING_0001		  /dev/asm-diskc
	   4	       0       1024 LEO_0000			   LEO_0000			  /dev/asm-diski
	   4	       1       1024 LEO_0001			   LEO_0001			  /dev/asm-diskj
	   5	       0       1024 NANCY_FG1			   FG1				  /dev/asm-diskk
	   5	       1       1024 NANCY_FG2			   FG2				  /dev/asm-diskl

11 rows selected.

3 磁盘组添加disk
http://www.cndba.cn/leo1990/article/1904http://www.cndba.cn/leo1990/article/1904http://www.cndba.cn/leo1990/article/1904

http://www.cndba.cn/leo1990/article/1904http://www.cndba.cn/leo1990/article/1904http://www.cndba.cn/leo1990/article/1904

SQL> alter diskgroup nancy add disk  '/dev/asm-diski';

Diskgroup altered.

SQL> select group_number,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB NAME			   FAILGROUP			  PATH
------------ ----------- ---------- ------------------------------ ------------------------------
	   0	       1	  0								  /dev/asm-diskj
	   1	       1      10240 DATA_0001			   DATA_0001			  /dev/asm-diskf
	   1	       0      10240 DATA_0000			   DATA_0000			  /dev/asm-diske
	   2	       0      10240 FRA_0000			   FRA_0000			  /dev/asm-diskg
	   2	       1      10240 FRA_0001			   FRA_0001			  /dev/asm-diskh
	   3	       0       2048 OCRVOTING_0000		   OCRVOTING_0000		  /dev/asm-diskb
	   3	       2       2048 OCRVOTING_0002		   OCRVOTING_0002		  /dev/asm-diskd
	   3	       1       2048 OCRVOTING_0001		   OCRVOTING_0001		  /dev/asm-diskc
	   5	       2       1024 NANCY_0002			   NANCY_0002			  /dev/asm-diski
	   5	       1       1024 NANCY_FG2			   FG2				  /dev/asm-diskl
	   5	       0       1024 NANCY_FG1			   FG1				  /dev/asm-diskk

11 rows selected.
4 磁盘组删除disk 

SQL> alter diskgroup nancy drop disk NANCY_0002;

Diskgroup altered.

SQL> select group_number,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB NAME			   FAILGROUP			  PATH
------------ ----------- ---------- ------------------------------ ------------------------------
	   0	       1	  0								  /dev/asm-diskj
	   0	       0	  0								  /dev/asm-diski
	   1	       1      10240 DATA_0001			   DATA_0001			  /dev/asm-diskf
	   1	       0      10240 DATA_0000			   DATA_0000			  /dev/asm-diske
	   2	       0      10240 FRA_0000			   FRA_0000			  /dev/asm-diskg
	   2	       1      10240 FRA_0001			   FRA_0001			  /dev/asm-diskh
	   3	       2       2048 OCRVOTING_0002		   OCRVOTING_0002		  /dev/asm-diskd
	   3	       1       2048 OCRVOTING_0001		   OCRVOTING_0001		  /dev/asm-diskc
	   3	       0       2048 OCRVOTING_0000		   OCRVOTING_0000		  /dev/asm-diskb
	   5	       0       1024 NANCY_FG1			   FG1				  /dev/asm-diskk
	   5	       1       1024 NANCY_FG2			   FG2				  /dev/asm-diskl

11 rows selected.
5 修改磁盘组属性 

ASMCMD>  lsattr -l -G nancy                                                  
Name                     Value       
access_control.enabled   FALSE       
access_control.umask     066         
au_size                  4194304     
cell.smart_scan_capable  FALSE       
compatible.asm           11.2.0.0.0  
compatible.rdbms         11.2.0.0.0  
disk_repair_time         3.6h        
sector_size              512         
ASMCMD> setattr -G nancy disk_repair_time 20m
ASMCMD> lsattr -l -G nancy 
Name                     Value       
access_control.enabled   FALSE       
access_control.umask     066         
au_size                  4194304     
cell.smart_scan_capable  FALSE       
compatible.asm           11.2.0.0.0  
compatible.rdbms         11.2.0.0.0  
disk_repair_time         20m         
sector_size              512
6 修改磁盘组rebalance级别 

SQL> ALTER DISKGROUP nancy REBALANCE POWER 5 WAIT;

Diskgroup altered.

SQL> select group_number,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB NAME			   FAILGROUP			  PATH
------------ ----------- ---------- ------------------------------ ------------------------------ 
	   0	       0	  0								  /dev/asm-diskl
	   0	       1	  0								  /dev/asm-diskj
	   1	       0      10240 DATA_0000			   DATA_0000			  /dev/asm-diske
	   1	       1      10240 DATA_0001			   DATA_0001			  /dev/asm-diskf
	   2	       1      10240 FRA_0001			   FRA_0001			  /dev/asm-diskh
	   2	       0      10240 FRA_0000			   FRA_0000			  /dev/asm-diskg
	   3	       2       2048 OCRVOTING_0002		   OCRVOTING_0002		  /dev/asm-diskd
	   3	       0       2048 OCRVOTING_0000		   OCRVOTING_0000		  /dev/asm-diskb
	   3	       1       2048 OCRVOTING_0001		   OCRVOTING_0001		  /dev/asm-diskc
	   5	       0       1024 NANCY_FG1			   FG1				  /dev/asm-diskk
	   5	       2       1024 NANCY_0002			   NANCY_0002			  /dev/asm-diski

11 rows selected.
7 磁盘组挂载卸载 

1)第一种方法
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     20480    16834                0            8417              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  1048576     20480    20290                0           10145              0             N  FRA/
MOUNTED  NORMAL  N         512   4096  4194304      2048     1888                0             944              0             N  NANCY/
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  OCRVOTING/

SQL> alter diskgroup nancy dismount;

Diskgroup altered.

ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     20480    16834                0            8417              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  1048576     20480    20290                0           10145              0             N  FRA/
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  OCRVOTING/

SQL> alter diskgroup nancy mount;               

Diskgroup altered.

ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     20480    16834                0            8417              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  1048576     20480    20290                0           10145              0             N  FRA/
MOUNTED  NORMAL  N         512   4096  4194304      2048     1888                0             944              0             N  NANCY/
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  OCRVOTING/

2）第二种方法
[grid@rac1 ~]$ asmcmd umount fra
[grid@rac1 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     20480    16834                0            8417              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  4194304      2048     1888                0             944              0             N  NANCY/
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  OCRVOTING/
[grid@rac1 ~]$ asmcmd mount fra
[grid@rac1 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     20480    16834                0            8417              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  1048576     20480    20290                0           10145              0             N  FRA/
MOUNTED  NORMAL  N         512   4096  4194304      2048     1888                0             944              0             N  NANCY/
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  OCRVOTING/
8 disk online和offline 

具体使用方法可以查看help：

asmcmd help offline
asmcmd help online

[grid@rac1 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  1048576     20480    16814                0            8407              0             N  DATA/
MOUNTED  NORMAL  N         512   4096  1048576     20480    20290                0           10145              0             N  FRA/
MOUNTED  NORMAL  N         512   4096  4194304      2048     1888                0             944              0             N  NANCY/
MOUNTED  NORMAL  N         512   4096  1048576      6144     5218             2048            1585              0             Y  OCRVOTING/

[grid@rac1 ~]$ asmcmd offline -G nancy -D NANCY_0002
Diskgroup altered.

[grid@rac1 ~]$ asmcmd lsdsk -p -G nancy
Group_Num  Disk_Num      Incarn  Mount_Stat  Header_Stat  Mode_Stat  State   Path
        4         2  3916010949  MISSING     MEMBER       OFFLINE    NORMAL  
        4         0  3916010950  CACHED      MEMBER       ONLINE     NORMAL  /dev/asm-diskk
		
[grid@rac1 ~]$ asmcmd online -G nancy -D NANCY_0002
Diskgroup altered.

[grid@rac1 ~]$ asmcmd lsdsk -p -G nancy
Group_Num  Disk_Num      Incarn  Mount_Stat  Header_Stat  Mode_Stat  State   Path
        4         2  3916010949  CACHED      MEMBER       ONLINE     NORMAL  /dev/asm-diski
        4         0  3916010950  CACHED      MEMBER       ONLINE     NORMAL  /dev/asm-diskk
9 同时加盘和减盘： 

SQL> alter diskgroup nancy add disk '/dev/asm-diski' drop disk NANCY_FG2;

Diskgroup altered.

SQL> select group_number,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB NAME			   FAILGROUP			  PATH
------------ ----------- ---------- ------------------------------ ------------------------------ 
	   0	       0	  0								  /dev/asm-diskl
	   0	       1	  0								  /dev/asm-diskj
	   1	       0      10240 DATA_0000			   DATA_0000			  /dev/asm-diske
	   1	       1      10240 DATA_0001			   DATA_0001			  /dev/asm-diskf
	   2	       1      10240 FRA_0001			   FRA_0001			  /dev/asm-diskh
	   2	       0      10240 FRA_0000			   FRA_0000			  /dev/asm-diskg
	   3	       2       2048 OCRVOTING_0002		   OCRVOTING_0002		  /dev/asm-diskd
	   3	       0       2048 OCRVOTING_0000		   OCRVOTING_0000		  /dev/asm-diskb
	   3	       1       2048 OCRVOTING_0001		   OCRVOTING_0001		  /dev/asm-diskc
	   5	       0       1024 NANCY_FG1			   FG1				  /dev/asm-diskk
	   5	       2       1024 NANCY_0002			   NANCY_0002			  /dev/asm-diski

11 rows selected.
10 删除磁盘组 

SQL> drop diskgroup leo including contents;

Diskgroup dropped.

SQL>  select group_number,disk_number,total_mb,name,failgroup,path from v$asm_disk order by 1;

GROUP_NUMBER DISK_NUMBER   TOTAL_MB NAME			   FAILGROUP			  PATH
------------ ----------- ---------- ------------------------------ ------------------------------
	   0	       1	  0								  /dev/asm-diskj
	   0	       0	  0								  /dev/asm-diski
	   1	       1      10240 DATA_0001			   DATA_0001			  /dev/asm-diskf
	   1	       0      10240 DATA_0000			   DATA_0000			  /dev/asm-diske
	   2	       0      10240 FRA_0000			   FRA_0000			  /dev/asm-diskg
	   2	       1      10240 FRA_0001			   FRA_0001			  /dev/asm-diskh
	   3	       2       2048 OCRVOTING_0002		   OCRVOTING_0002		  /dev/asm-diskd
	   3	       1       2048 OCRVOTING_0001		   OCRVOTING_0001		  /dev/asm-diskc
	   3	       0       2048 OCRVOTING_0000		   OCRVOTING_0000		  /dev/asm-diskb
	   5	       0       1024 NANCY_FG1			   FG1				  /dev/asm-diskk
	   5	       1       1024 NANCY_FG2			   FG2				  /dev/asm-diskl

11 rows selected.

版权声明：本文为博主原创文章，未经博主允许不得转载。

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
leo

leo

关注

坚持你的坚持

  • 202
    原创
  • 0
    翻译
  • 39
    转载
  • 16
    评论
  • 访问：766488次
  • 积分：1270
  • 等级：核心会员
  • 排名：第8名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ