首页 > 代码库 > 为data盘加入磁盘(asm external)

为data盘加入磁盘(asm external)

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         3072

4.加入磁盘
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         3072

6.集群状态
[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!



为data盘加入磁盘(asm external)