How To Create ASM Diskgroups using NFS/NAS Files

 

 ASM is completely supported on NAS (e.g. NFS filesystem on NetApps).

 

步骤如下:
1)  As Oracle OS user, create the disk devices on your NFS directory:

oracle>dd if=/dev/zero of=/oracle/asm/disks/nfsdisk2 bs=8192 count=100000
100000+0 records in
100000+0 records out


oracle>dd if=/dev/zero of=/oracle/asm/disks/nfsdisk1 bs=8192 count=100000
100000+0 records in
100000+0 records out


oracle>ls -l
total 3201600
-rw-r--r-- 1 oracle dba 819200000 Aug 11 14:10 nfsdisk1
-rw-r--r-- 1 oracle dba 819200000 Aug 11 14:09 nfsdisk2



2)  Connect to your ASM instance and set the NFS directory in the discovery path:

SQL> alter system set asm_diskstring = '/oracle/asm/disks/*' scope=both;

System altered.

SQL> show parameter asm

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string
asm_diskstring string /oracle/asm/disks/*
asm_power_limit integer 11


Note: If spfile is not being used then you will need to update the pfile (init+ASM.ora) with the next values to preserve the changes during the shutdown/startup:

asm_diskstring = '/oracle/asm/disks/*'

Where: “/oracle/asm/disks/*” is the NFS directory associated with the NAS disk devices.


3)  Verify the NFS disks are now discovered thru the v$asm_disk view:

SQL> select path from v$asm_disk;

PATH
----------------------------------------------------
/oracle/asm/disks/nfsdisk1
/oracle/asm/disks/nfsdisk2



4)  Finally, create the diskgroup on the NFS disks:

SQL> create diskgroup test external redundancy disk
'/oracle/asm/disks/nfsdisk1',
'/oracle/asm/disks/nfsdisk2';

Diskgroup created.

 

 

 

 

 

From Oracle

-------------------------------------------------------------------------------------------------------

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

DBA1 群:62697716();   DBA2 群:62697977()   DBA3 群:62697850()  

DBA 超级群:63306533();  DBA4 群: 83829929  DBA5群: 142216823   

聊天 群:40132017   聊天2群:69087192

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值