Exadata下新建Asm Diskgroup

Exadata下新建Asm Diskgroup 的步骤大致如下:
 
 
1.使用dcli -g /home/oracle/cell_group -l root cellcli -e list griddisk 命令找出active的griddisk
[
[root@dm01db01 ~]# dcli -g /home/oracle/cell_group -l root cellcli -e list griddisk
d
dm01cel01: DATA_DM01_CD_00_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_01_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_02_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_03_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_04_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_05_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_06_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_07_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_08_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_09_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_10_dm01cel01     active
d
dm01cel01: DATA_DM01_CD_11_dm01cel01     active
d
dm01cel01: DBFS_DG_CD_02_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_03_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_04_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_05_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_06_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_07_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_08_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_09_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_10_dm01cel01       active
d
dm01cel01: DBFS_DG_CD_11_dm01cel01       active
d
dm01cel01: RECO_DM01_CD_00_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_01_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_02_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_03_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_04_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_05_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_06_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_07_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_08_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_09_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_10_dm01cel01     active
d
dm01cel01: RECO_DM01_CD_11_dm01cel01     active
d
dm01cel02: DATA_DM01_CD_00_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_01_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_02_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_03_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_04_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_05_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_06_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_07_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_08_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_09_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_10_dm01cel02     active
d
dm01cel02: DATA_DM01_CD_11_dm01cel02     active
d
dm01cel02: DBFS_DG_CD_02_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_03_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_04_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_05_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_06_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_07_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_08_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_09_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_10_dm01cel02       active
d
dm01cel02: DBFS_DG_CD_11_dm01cel02       active
d
dm01cel02: RECO_DM01_CD_00_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_01_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_02_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_03_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_04_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_05_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_06_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_07_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_08_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_09_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_10_dm01cel02     active
d
dm01cel02: RECO_DM01_CD_11_dm01cel02     active
d
dm01cel03: DATA_DM01_CD_00_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_01_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_02_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_03_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_04_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_05_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_06_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_07_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_08_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_09_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_10_dm01cel03     active
d
dm01cel03: DATA_DM01_CD_11_dm01cel03     active
d
dm01cel03: DBFS_DG_CD_02_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_03_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_04_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_05_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_06_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_07_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_08_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_09_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_10_dm01cel03       active
d
dm01cel03: DBFS_DG_CD_11_dm01cel03       active
d
dm01cel03: RECO_DM01_CD_00_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_01_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_02_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_03_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_04_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_05_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_06_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_07_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_08_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_09_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_10_dm01cel03     active
d
dm01cel03: RECO_DM01_CD_11_dm01cel03     active

d


注意若没有符合要求的griddisk, 你可以使用’cellcli -e drop griddisk’ 和’cellcli -e create griddisk’命令重建griddisk ,但是不要轻易drop DBFS_DG开头的griddisk
2.登陆ASM实例后create disk group
如果不知道CELL的IP,可以从下面的配置文件中找到
[
[root@dm01db02 ~]# cat /etc/oracle/cell/network-config/cellip.ora 
c
cell="192.168.64.131"
c
cell="192.168.64.132"
c
cell="192.168.64.133"

S
SQL> create diskgroup DATA_MAC normal  redundancy 
 
  2  DISK
 
  3  'o/192.168.64.131/RECO_DM01_CD_*_dm01cel01'
 
  4  ,'o/192.168.64.132/RECO_DM01_CD_*_dm01cel02'
 
  5  ,'o/192.168.64.133/RECO_DM01_CD_*_dm01cel03'
 
  6  attribute
 
  7  'AU_SIZE'='4M',
 
  8  'CELL.SMART_SCAN_CAPABLE'='TRUE',
 
  9  'compatible.rdbms'='11.2.0.2',
 
 10  'compatible.asm'='11.2.0.2'
 
 11  /


3. MOUNT 新建的DISKGROUP
ALTER DISKGROUP DATA_MAC mount ;
4.或使用crsctl start/stop resource ora.DATA_MAC.dg 控制该资源

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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

黑山老腰断了

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值