程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> 為data盤添加磁盤(asmexternal)

為data盤添加磁盤(asmexternal)

編輯:Oracle教程

為data盤添加磁盤(asmexternal)


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!

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved