为data盘添加磁盘(asm external)

来源:互联网 发布:黄金比例算法 编辑:程序博客网 时间:2024/04/30 08:11
1.创建盘,并两个节点皆可以访问。2.检查集群状态[grid@rac1 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.FRA.dg               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.LISTENER.lsnr               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.asm               ONLINE  ONLINE       rac1                     Started                            ONLINE  ONLINE       rac2                     Started             ora.eons               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.gsd               OFFLINE OFFLINE      rac1                                                        OFFLINE OFFLINE      rac2                                         ora.net1.network               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.ons               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.orcl.db      1        ONLINE  ONLINE       rac1                     Open                     2        ONLINE  ONLINE       rac2                     Open               ora.rac1.vip      1        ONLINE  ONLINE       rac1                                         ora.rac2.vip      1        ONLINE  ONLINE       rac2   3.检查磁盘GROUP_NUMBER GROUP_NAME NAME                 PATH                 STATE      TOTAL_MB------------ ---------- -------------------- -------------------- -------- ----------           3 FRA        FRA                  /dev/raw/raw5        NORMAL         8192           2 DATA       DATA                 /dev/raw/raw4        NORMAL         8192           1 CRS        CRS_0002             /dev/raw/raw3        NORMAL         3072           1 CRS        CRS_0001             /dev/raw/raw2        NORMAL         3072           1 CRS        CRS_0000             /dev/raw/raw1        NORMAL         30724.添加磁盘SQL> alter diskgroup data add disk '/dev/raw/raw6/' name data2;Diskgroup altered.5.查看磁盘状态GROUP_NUMBER GROUP_NAME NAME                 PATH                 STATE      TOTAL_MB------------ ---------- -------------------- -------------------- -------- ----------           0 DATA       DATA2                /dev/raw/raw6        NORMAL         8192           5 FRA        FRA                  /dev/raw/raw5        NORMAL         8192           0 DATA       DATA                 /dev/raw/raw4        NORMAL         8192           0 CRS        CRS_0002             /dev/raw/raw3        NORMAL         3072           0 CRS        CRS_0001             /dev/raw/raw2        NORMAL         3072           0 CRS        CRS_0000             /dev/raw/raw1        NORMAL         30726.集群状态[grid@rac2 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME           TARGET  STATE        SERVER                   STATE_DETAILS       --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.FRA.dg               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.LISTENER.lsnr               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.asm               ONLINE  ONLINE       rac1                     Started                            ONLINE  ONLINE       rac2                     Started             ora.eons               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.gsd               OFFLINE OFFLINE      rac1                                                        OFFLINE OFFLINE      rac2                                         ora.net1.network               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         ora.ons               ONLINE  ONLINE       rac1                                                        ONLINE  ONLINE       rac2                                         --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.orcl.db      1        ONLINE  ONLINE       rac1                     Open                     2        ONLINE  ONLINE       rac2                     Open               ora.rac1.vip      1        ONLINE  ONLINE       rac1                                         ora.rac2.vip      1        ONLINE  ONLINE       rac2                                   OK!

0 0