Oracle 11g下asm磁盘组”REQUIRED_MIRROR_FREE_MB“大小测试

最新推荐文章于 2024-08-16 09:13:01 发布
最新推荐文章于 2024-08-16 09:13:01 发布
阅读量897 收藏 2
点赞数
分类专栏： ASM Oracle ASM测试
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kiral07/article/details/93912967
版权

Oracle 11g下asm磁盘组”REQUIRED_MIRROR_FREE_MB“大小测试

Oracle asm的参数实在太多，看了官方文档对”required_mirror_free_mb“参数还是意识模糊，所以干脆自己做测试来验证。

环境：Oracle 11.2.0.4 RAC

下面总共分6个场景，使用normal冗余在不同数量失败组、asm盘数量，测试”required_mirror_free_mb“可用空间

场景一：2个失败组，每个失败组fg一个磁盘，看大小

create diskgroup test normal redundancy 
failgroup fg1 disk '/dev/asm_1g_1' size 1g 看大小
failgroup fg2 disk '/dev/asm_1g_2' size 1g 
ATTRIBUTE 'au_size'='4M';

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE from v$asm_disk order by path;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    NAME       FAILGROUP  PATH                 FAILGRO
------------ ----------- ------- ------------ ------- -------- ---------- ---------- -------------------- -------
           4           0 CACHED  MEMBER       ONLINE  NORMAL   TEST_0000  FG1        /dev/asm_1g_1        REGULAR
           4           1 CACHED  MEMBER       ONLINE  NORMAL   TEST_0001  FG2        /dev/asm_1g_2        REGULAR

SQL> select name,state,total_mb/1024 total_gb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup where name='TEST';

NAME       STATE         TOTAL_GB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ----------- ---------- ---------- ----------------------- --------------
TEST       MOUNTED              2       1904                       0            952

REQUIRED_MIRROR_FREE_MB=0

场景二、2个失败组，每个fg 二个磁盘，看大小

create diskgroup test normal redundancy 
failgroup fg1 disk '/dev/asm_1g_1' size 1g 
failgroup fg1 disk '/dev/asm_1g_2' size 1g 
failgroup fg2 disk '/dev/asm_1g_3' size 1g  
failgroup fg2 disk '/dev/asm_1g_4' size 1g  
ATTRIBUTE 'au_size'='4M';

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE from v$asm_disk where name like 'TEST%' order by path;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    NAME       FAILGROUP  PATH                 FAILGRO
------------ ----------- ------- ------------ ------- -------- ---------- ---------- -------------------- -------
           4           0 CACHED  MEMBER       ONLINE  NORMAL   TEST_0000  FG1        /dev/asm_1g_1        REGULAR
           4           1 CACHED  MEMBER       ONLINE  NORMAL   TEST_0001  FG1        /dev/asm_1g_2        REGULAR
           4           2 CACHED  MEMBER       ONLINE  NORMAL   TEST_0002  FG2        /dev/asm_1g_3        REGULAR
           4           3 CACHED  MEMBER       ONLINE  NORMAL   TEST_0003  FG2        /dev/asm_1g_4        REGULAR

SQL> select name,state,total_mb/1024 total_gb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup where name='TEST';

NAME       STATE         TOTAL_GB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ----------- ---------- ---------- ----------------------- --------------
TEST       MOUNTED              4       3936                    1024           1456

REQUIRED_MIRROR_FREE_MB=1g

场景三：2个失败组，每个fg 三个磁盘，看大小

create diskgroup test normal redundancy 
failgroup fg1 disk '/dev/asm_1g_1' size 1g 
failgroup fg1 disk '/dev/asm_1g_2' size 1g 
failgroup fg1 disk '/dev/asm_1g_3' size 1g 
failgroup fg2 disk '/dev/asm_1g_4' size 1g  
failgroup fg2 disk '/dev/asm_1g_5' size 1g  
failgroup fg2 disk '/dev/asm_1g_6' size 1g 
ATTRIBUTE 'au_size'='4M';

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE from v$asm_disk where name like 'TEST%' order by path;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    NAME       FAILGROUP  PATH                 FAILGRO
------------ ----------- ------- ------------ ------- -------- ---------- ---------- -------------------- -------
           4           0 CACHED  MEMBER       ONLINE  NORMAL   TEST_0000  FG1        /dev/asm_1g_1        REGULAR
           4           1 CACHED  MEMBER       ONLINE  NORMAL   TEST_0001  FG1        /dev/asm_1g_2        REGULAR
           4           2 CACHED  MEMBER       ONLINE  NORMAL   TEST_0002  FG1        /dev/asm_1g_3        REGULAR
           4           3 CACHED  MEMBER       ONLINE  NORMAL   TEST_0003  FG2        /dev/asm_1g_4        REGULAR
           4           4 CACHED  MEMBER       ONLINE  NORMAL   TEST_0004  FG2        /dev/asm_1g_5        REGULAR
           4           5 CACHED  MEMBER       ONLINE  NORMAL   TEST_0005  FG2        /dev/asm_1g_6        REGULAR

6 rows selected.

SQL> select name,state,total_mb/1024 total_gb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup where name='TEST';

NAME       STATE         TOTAL_GB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ----------- ---------- ---------- ----------------------- --------------
TEST       MOUNTED              6       5968                    1024           2472

REQUIRED_MIRROR_FREE_MB=1g

场景四：3个失败组，每个fg一个磁盘，看大小

create diskgroup test normal redundancy failgroup fg1 disk '/dev/asm_1g_1' size 1g failgroup fg2 disk '/dev/asm_1g_2' size 1g  failgroup fg3 disk '/dev/asm_1g_3' size 1g ATTRIBUTE 'au_size'='4M';

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE from v$asm_disk order by path;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    NAME       FAILGROUP  PATH                 FAILGRO
------------ ----------- ------- ------------ ------- -------- ---------- ---------- -------------------- -------
           4           0 CACHED  MEMBER       ONLINE  NORMAL   TEST_0000  FG1        /dev/asm_1g_1        REGULAR
           4           1 CACHED  MEMBER       ONLINE  NORMAL   TEST_0001  FG2        /dev/asm_1g_2        REGULAR
           4           2 CACHED  MEMBER       ONLINE  NORMAL   TEST_0002  FG3        /dev/asm_1g_3        REGULAR

SQL> select name,state,total_mb/1024 total_gb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup where name='TEST';

NAME       STATE         TOTAL_GB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ----------- ---------- ---------- ----------------------- --------------
TEST       MOUNTED              3       2856                    1024            916

REQUIRED_MIRROR_FREE_MB=1g

场景五：3个失败组，每个fg 二个磁盘，看大小

create diskgroup test normal redundancy 
failgroup fg1 disk '/dev/asm_1g_1' size 1g 
failgroup fg1 disk '/dev/asm_1g_2' size 1g 
failgroup fg2 disk '/dev/asm_1g_3' size 1g  
failgroup fg2 disk '/dev/asm_1g_4' size 1g  
failgroup fg3 disk '/dev/asm_1g_5' size 1g  
failgroup fg3 disk '/dev/asm_1g_6' size 1g 
ATTRIBUTE 'au_size'='4M';

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE from v$asm_disk where name like 'TEST%' order by path;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    NAME       FAILGROUP  PATH                 FAILGRO
------------ ----------- ------- ------------ ------- -------- ---------- ---------- -------------------- -------
           4           0 CACHED  MEMBER       ONLINE  NORMAL   TEST_0000  FG1        /dev/asm_1g_1        REGULAR
           4           1 CACHED  MEMBER       ONLINE  NORMAL   TEST_0001  FG1        /dev/asm_1g_2        REGULAR
           4           2 CACHED  MEMBER       ONLINE  NORMAL   TEST_0002  FG2        /dev/asm_1g_3        REGULAR
           4           3 CACHED  MEMBER       ONLINE  NORMAL   TEST_0003  FG2        /dev/asm_1g_4        REGULAR
           4           4 CACHED  MEMBER       ONLINE  NORMAL   TEST_0004  FG3        /dev/asm_1g_5        REGULAR
           4           5 CACHED  MEMBER       ONLINE  NORMAL   TEST_0005  FG3        /dev/asm_1g_6        REGULAR

6 rows selected.

SQL>  select name,state,total_mb/1024 total_gb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup where name='TEST';

NAME       STATE         TOTAL_GB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ----------- ---------- ---------- ----------------------- --------------
TEST       MOUNTED              6       5904                    2048           1928

REQUIRED_MIRROR_FREE_MB=2g

场景六：3个失败组，每个fg 三个磁盘，看大小

create diskgroup test normal redundancy 
failgroup fg1 disk '/dev/asm_1g_1' size 1g 
failgroup fg1 disk '/dev/asm_1g_2' size 1g 
failgroup fg1 disk '/dev/asm_1g_3' size 1g 
failgroup fg2 disk '/dev/asm_1g_4' size 1g  
failgroup fg2 disk '/dev/asm_1g_5' size 1g  
failgroup fg2 disk '/dev/asm_1g_6' size 1g 
failgroup fg3 disk '/dev/asm_1g_7' size 1g  
failgroup fg3 disk '/dev/asm_1g_8' size 1g 
failgroup fg3 disk '/dev/asm_1g_9' size 1g 
ATTRIBUTE 'au_size'='4M';

SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,NAME,FAILGROUP,PATH,FAILGROUP_TYPE from v$asm_disk where name like 'TEST%' order by path;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    NAME                 FAILGROUP  PATH                 FAILGRO
------------ ----------- ------- ------------ ------- -------- -------------------- ---------- -------------------- -------
           4           0 CACHED  MEMBER       ONLINE  NORMAL   TEST_0000            FG1        /dev/asm_1g_1        REGULAR
           4           1 CACHED  MEMBER       ONLINE  NORMAL   TEST_0001            FG1        /dev/asm_1g_2        REGULAR
           4           2 CACHED  MEMBER       ONLINE  NORMAL   TEST_0002            FG1        /dev/asm_1g_3        REGULAR
           4           3 CACHED  MEMBER       ONLINE  NORMAL   TEST_0003            FG2        /dev/asm_1g_4        REGULAR
           4           4 CACHED  MEMBER       ONLINE  NORMAL   TEST_0004            FG2        /dev/asm_1g_5        REGULAR
           4           5 CACHED  MEMBER       ONLINE  NORMAL   TEST_0005            FG2        /dev/asm_1g_6        REGULAR
           4           6 CACHED  MEMBER       ONLINE  NORMAL   TEST_0006            FG3        /dev/asm_1g_7        REGULAR
           4           7 CACHED  MEMBER       ONLINE  NORMAL   TEST_0007            FG3        /dev/asm_1g_8        REGULAR
           4           8 CACHED  MEMBER       ONLINE  NORMAL   TEST_0008            FG3        /dev/asm_1g_9        REGULAR

9 rows selected.

SQL>  select name,state,total_mb/1024 total_gb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup where name='TEST';

NAME                 STATE         TOTAL_GB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
-------------------- ----------- ---------- ---------- ----------------------- --------------
TEST                 MOUNTED              9       8952                    3072           2940

REQUIRED_MIRROR_FREE_MB=3g

总结

normal冗余下
当失败组大于2的时候，比如3个失败组，REQUIRED_MIRROR_FREE_MB大小为其中一个失败组的大小
当失败组小于3的时候，比如2个失败组，REQUIRED_MIRROR_FREE_MB大小为失败组之中一个asm磁盘的大小

iverycd
关注
专栏目录
ASM中required_mirror_free_mb和usable_file_mb具体定义
tyrion的博客
07-27 3015
客户经常针对REQUIRED_MIRROR_FREE_MB和USABLE_FILE_MB混淆，每次跟客户讲解都很费力 下面用实际例子来验证该问题 首先根据官网文档v$asm_diskgroup视图定义 简单来说，视图V$ASM_DISKGROUP中的FREE_MB就是未使用的剩余空间(MB),REQUIRED_MIRROR_FREE_MB值代表了如果ASM
ASM 翻译系列第四十弹：理解ASM中 REQUIRED_MIRROR_FREE_MB和USABLE_FILE_MB的含义
woqutechteam的博客
03-15 1108
在我的课上一个经常被问到的问题是ASM如何计算磁盘组REQUIRED_MIRROR_FREE_MB和USABLE_FILE_MB的值，这个问题的答案跟很多复杂问题的答案一样：要看情况。
Oracle ASM REQUIRED_MIRROR_FREE_MB
02-03 203
REQUIRED_MIRROR_FREE_MB与USABLE_FILE_MB是V$ASM_DISKGROUP[_STAT]视图中两个非常有意义的列。关于这两个字段有很多问题与及如何计算它们。 How much ...
Oracle+ASM+High冗余详解及空间计算
最新发布
听雪楼主
08-16 505
Oracle+ASM+High冗余详解及空间计算
oracle asm在线镜像,Oracle ASM REQUIRED_MIRROR_FREE_MB
weixin_31516001的博客
04-03 284
REQUIRED_MIRROR_FREE_MB与USABLE_FILE_MB是V$ASM_DISKGROUP[_STAT]视图中两个非常有意义的列。关于这两个字段有很多问题与及如何计算它们。How much space can I useASM不能阻止你使用外部冗余磁盘组的所有可用空间，normal冗余磁盘组总空间的一半，high冗余磁盘组总空间的三分之一。但如果你想填满磁盘组直到溢出，使它没有足...
ASM 翻译系列第三十三弹：REQUIRED_MIRROR_FREE_MB的含义
02-24 213
ASM 翻译系列第三十三弹：ASM 高级知识 REQUIREDMIRRORFREE_MB 原文：REQUIREDMIRRORFREE_MB作者：Bane Radulovic译者：陈亚军，沃趣科技数...
Demystifying ASM REQUIRED_MIRROR_FREE_MB and USABLE_FILE_MB
loryliu的专栏
10-01 1198
Demystifying ASM REQUIRED_MIRROR_FREE_MB and USABLE_FILE_MB Posted by Harald van Breederode on January 3, 2013 A recurring question in my classes is how Oracle Automatic Storage Management (ASM) c
oracle 安装 挂载磁盘组_Oracle ASM磁盘组的常用操作
weixin_31056947的博客
12-23 846
1.查看现有磁盘组信息select group_number gno,name,state,type,total_mb,free_mb,required_mirror_free_mb rmfmb,usable_file_mb ufmb from v$asm_diskgroup;2.查看磁盘信息select group_number gno,name,failgroup fgno,state,tot...
#ASM 翻译系列第三十三弹：ASM 高级知识 REQUIRED_MIRROR_FREE_MB
woqutechteam的博客
02-24 536
原文： REQUIRED_MIRROR_FREE_MB 作者： Bane Radulovic 译者：陈亚军，沃趣科技数据库技术工程师，主要参与公司产品实施、测试、维护以及优化。 审校：魏兴华 责编：仲培艺 REQUIRED_MIRROR_FREE_MB和USABLE_FILE_MB是V$ASM_DISKGROUP[_STAT]视图中非常有趣的两列。Oracle Support
oracle 19c rac替换asm磁盘组
hbhe0316的专栏
04-05 1073
1、添加新磁盘： 两个节点都操作,使用root用户 for i in j k; do echo "KERNEL==\"sd*\",ENV{DEVTYPE}==\"disk\",SUBSYSTEM==\"block\",PROGRAM==\"/usr/lib/udev/scsi_id -g -u -d \$devnode\",RESULT==\"`/usr/lib/udev/scsi_id -g -u /dev/sd$i`\", RUN+=\"/bin/sh -c 'mknod /dev/asm-dis.
Oracle-11g-R2-RAC-with-ASM存储迁移-手记.docx
10-29
本文详细介绍如何讲oracle rac的数据库数据进行迁移备份，配有图文，适合做做实验在再去实践
受困于v$asm_dksigroup里的字段REQUIRED_MIRROR_FREE_MB！
clt3617的博客
02-12 133
这个字段困扰了我很久，现在理解的也是稀里糊涂的，记录一个测试过程和大致的结论。[@more@]SQL> select total_mb,free_mb,name,failgroup,path from v$asm_disk...
ASM DG Usable_file_MB和Req_mir_free_MB的含义
cj990133的博客
03-08 1216
REQUIRED_MIRROR_FREE_MB的值代表了ASM用来重新满足磁盘组定义的冗余度所需要的空间，这个值的大小依赖于磁盘组的冗余度和FailGroup失败组的数量。 如果有n>2个failgroup的no...
Oracle11g学习笔记_20170508_Oracle安装的硬件需求和占用磁盘空间明细
zhudauy的博客
05-08 2267
1、Oracle安装的硬件需求 物理内存：至少1G 虚拟内存：物理内存的2倍 硬盘空间：全部安装需要5.1G 显示器是配色：256色 处理器：主频最少550MHZ 2、Oracle安装占用磁盘空间明细 Temp空间   125MB C:\ProgramFile\Oracle    2MB Oracle根目录（Oracle Home）   3.5GB 数据文件     1.6GB
Oracle集群ASM磁盘扩容
冥净的博客
03-11 451
查看自己两边磁盘UUID是否相同(for i in 后面为磁盘sd后字母名)检查所加diskgroup名称，diskstring形式。ASM磁盘rebalance后检看ASM磁盘空间情况。ASM磁盘rebalance后检查数据库集群状态。先通过lsblk来查看集群两端磁盘是否扩容成功。mpath查看自己两边磁盘UUID是否相同。两边编辑绑定文件后，依次执行以下命令。查看ASM磁盘rebalance情况。执行后检查两边的磁盘权限属组情况。添加磁盘到DATA磁盘组中。
oracle asm块大小,oracle 11.2.0.3 rac 的ASM磁盘组中每个lun的最大尺寸是多少
weixin_35784728的博客
04-03 694
对于 ASM，每个磁盘的的大小限制是 2T。 对于外部冗余的磁盘组，数据在磁盘组层面是没有冗余的。如果已经存在一个500g的磁盘，那么在增加一块2T的磁盘的话，这个磁盘组的容量就是2.5T.另外，关于ASM的限制，你可以查看以下的联机文档。Oracle® Automatic Storage Management Administrator's Guide====> 4 Administeri...
oracle10g_asm_v$asm_disk之total_mb_free_mb_required_mirror_free_mb相互关系
11-26 241
select name,type,total_mb,free_mb,required_mirror_free_mb,usable_file_mb 2 from v$asm_diskgroup 3* where type='...
Linux_5上Oracle_11gR2_ASM安装配置指南
在Linux 5环境下安装Oracle 11g R2的Automatic Storage Management (ASM)是一项涉及多个系统层面的技术任务，包括硬件环境检查、内存配置以及操作系统兼容性等关键环节。 首先，硬件环境是Oracle数据库稳定运行的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值