Oracle 11.2.0.3管理ASM的方法是什么

本篇內(nèi)容主要講解“Oracle 11.2.0.3管理ASM的方法是什么”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學(xué)習(xí)“Oracle 11.2.0.3管理ASM的方法是什么”吧!

一：查看ASM磁盤及磁盤組狀態(tài)
SQL> select * from v$asm_disk;
SQL> select * from v$asm_diskgroup;

二：創(chuàng)建external 冗余磁盤組,添加，刪除磁盤，刪除磁盤的時候需要指定磁盤的name而不是path

   SQL> create diskgroup FRA external redundancy disk '/dev/asm-disk4';   
    Diskgroup created.   
      
    SQL> alter diskgroup fra add disk '/dev/asm-disk5' rebalance power 10;   
    Diskgroup altered.   
      
    SQL> select name,failgroup,path from v$asm_disk;   
      
    NAME                 FAILGROUP            PATH   
    -------------------- -------------------- --------------------   
    DATA_0000            DATA_0000            /dev/asm-disk1   
    DATA_0001            DATA_0001            /dev/asm-disk3   
    DATA_0002            DATA_0002            /dev/asm-disk2   
    FRA_0000             FRA_0000             /dev/asm-disk4   
    FRA_0001             FRA_0001             /dev/asm-disk5   
                                              /dev/asm-disk6   
                                              /dev/asm-disk7   
      
    SQL> alter diskgroup fra drop disk '/dev/asm-disk4' rebalance power 10;   
    alter diskgroup fra drop disk '/dev/asm-disk4' rebalance power 10   
    *   
    ERROR at line 1:   
    ORA-15032: not all alterations performed   
    ORA-15054: disk "/DEV/ASM-DISK4" does not exist in diskgroup "FRA"   
      
    SQL> alter diskgroup fra drop disk 'FRA_0000' rebalance power 10;   
    Diskgroup altered.  

三：創(chuàng)建normal redundancy磁盤組

    SQL> conn /as sysasm   
    Connected.   
    SQL> create diskgroup fra normal redundancy    
         failgroup fg1 disk '/dev/asm-disk4','/dev/asm-disk5'   
         failgroup fg2 disk '/dev/asm-disk6','/dev/asm-disk7'   
         attribute 'compatible.rdbms'='11.2','compatible.asm'='11.2';   
    Diskgroup created.   
      
    SQL> select name, total_mb,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup;   
      
    NAME         TOTAL_MB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB   
    ---------- ---------- ---------- ----------------------- --------------   
    DATA            61440      54873                       0          18291   
    FRA             81920      81592                   20480          30556  

四：failgroup測試；FAILGROUP是用于將磁盤分組，以保證丟失任何一組FAILGROUP磁盤，數(shù)據(jù)還是完整的,多用于多陣列，通過ASM來完成冗余的環(huán)境！
1：查看FRA磁盤組中failgroup信息及磁盤狀態(tài)

    SQL> select name,path,failgroup,mount_status from v$asm_disk where group_number=2;   
      
    NAME                 PATH                 FAILGROUP  MOUNT_STATUS   
    -------------------- -------------------- ---------- ---------------------   
    FRA_0003             /dev/asm-disk7       FG2        CACHED   
    FRA_0002             /dev/asm-disk6       FG2        CACHED   
    FRA_0000             /dev/asm-disk4       FG1        CACHED   
    FRA_0001             /dev/asm-disk5       FG1        CACHED  

2：在rdbms實例中創(chuàng)建表空間，建表并插入數(shù)據(jù)，收集表統(tǒng)計信息

    SQL> create tablespace test01 datafile '+FRA';   
    Tablespace created.   
      
    ASMCMD> pwd   
    +fra/db/datafile   
    ASMCMD> ls   
    TEST01.256.800622493   
      
    SQL> create table t1 tablespace test01 as select * from dba_objects;   
    Table created.   
      
    SQL> exec dbms_stats.gather_table_stats('SYS','T1');   
    PL/SQL procedure successfully completed.   
      
    SQL> select count(*) from t1;   
      
      COUNT(*)   
    ----------   
         74501  

3：刪除udev相關(guān)規(guī)則，重啟數(shù)據(jù)庫實例和ASM實例，驗證數(shù)據(jù)是否存在

    SQL> conn /as sysasm   
    Connected.   
    SQL> alter diskgroup fra mount;   
    alter diskgroup fra mount   
    *   
    ERROR at line 1:   
    ORA-15032: not all alterations performed   
    ORA-15040: diskgroup is incomplete   
    ORA-15042: ASM disk "1" is missing from group number "2"   
    ORA-15042: ASM disk "0" is missing from group number "2"   
      
    SQL> alter diskgroup fra mount force;   
    Diskgroup altered.   
      
    SQL> select name,path,failgroup,mount_status from v$asm_disk;   
      
    NAME       PATH                 FAILGROUP            MOUNT_STATUS   
    ---------- -------------------- -------------------- ---------------------   
    FRA_0000                        FG1                  MISSING   
    FRA_0001                        FG1                  MISSING   
    FRA_0002   /dev/asm-disk6       FG2                  CACHED   
    FRA_0003   /dev/asm-disk7       FG2                  CACHED   
    DATA_0000  /dev/asm-disk1       DATA_0000            CACHED   
    DATA_0002  /dev/asm-disk2       DATA_0002            CACHED   
    DATA_0001  /dev/asm-disk3       DATA_0001            CACHED   
    7 rows selected.   
      
    SQL> conn /as sysdba   
    Connected.   
    SQL> select count(*) from t1;   
      
      COUNT(*)   
    ----------   
         74501  

五：刪除ASM磁盤組，默認磁盤故障條件下，經(jīng)過12960秒即3.6個小時后自動刪除；刪除磁盤組之前需要保證無數(shù)據(jù)存放在磁盤組上且無到該磁盤組的active連接

    [grid@localhost ~]$ tail -f /u01/app/grid/diag/asm/+asm/+ASM/trace/alert_+ASM.log    
    ORA-15062: ASM disk is globally closed   
    Thu Nov 29 12:00:53 2012   
    WARNING: Disk 0 (FRA_0000) in group 2 will be dropped in: (12960) secs on ASM inst 1   
    WARNING: Disk 1 (FRA_0001) in group 2 will be dropped in: (12960) secs on ASM inst 1   
    Thu Nov 29 12:00:58 2012   
      
    asm實例：   
    SQL> select path,name,repair_timer from v$asm_disk where group_number=2;   
      
    PATH                 NAME       REPAIR_TIMER   
    -------------------- ---------- ------------   
                         FRA_0000          12960   
                         FRA_0001          12960   
    /dev/asm-disk6       FRA_0002              0   
    /dev/asm-disk7       FRA_0003              0   
      
    SQL> alter diskgroup fra online disk 'FRA_0000';   
    Diskgroup altered.   
      
    SQL> alter diskgroup fra online disk 'FRA_0001';   
    Diskgroup altered.   
      
    SQL> select name,path,failgroup,mount_status from v$asm_disk;   
      
    NAME       PATH                 FAILGROUP            MOUNT_STATUS   
    ---------- -------------------- -------------------- ---------------------   
    FRA_0002   /dev/asm-disk6       FG2                  CACHED   
    FRA_0003   /dev/asm-disk7       FG2                  CACHED   
    DATA_0000  /dev/asm-disk1       DATA_0000            CACHED   
    DATA_0002  /dev/asm-disk2       DATA_0002            CACHED   
    DATA_0001  /dev/asm-disk3       DATA_0001            CACHED   
    FRA_0001   /dev/asm-disk5       FG1                  CACHED   
    FRA_0000   /dev/asm-disk4       FG1                  CACHED   
      
    SQL> drop diskgroup fra;   
    drop diskgroup fra   
    *   
    ERROR at line 1:   
    ORA-15039: diskgroup not dropped   
    ORA-15053: diskgroup "FRA" contains existing files   
      
    rdbms實例：   
    SQL> drop tablespace test01 including contents;   
    Tablespace dropped.   
      
    SQL> shutdown immediate   
    Database closed.   
    Database dismounted.   
    ORACLE instance shut down.   
      
    asm實例：   
    SQL> drop diskgroup fra including contents;   
    Diskgroup dropped.   
      
    rdbms實例：   
    SQL> startup   
    ORACLE instance started.   
      
    Total System Global Area  313860096 bytes   
    Fixed Size                  1344652 bytes   
    Variable Size             192940916 bytes   
    Database Buffers          113246208 bytes   
    Redo Buffers                6328320 bytes   
    Database mounted.   
    Database opened. 

到此，相信大家對“Oracle 11.2.0.3管理ASM的方法是什么”有了更深的了解，不妨來實際操作一番吧！這里是億速云網(wǎng)站，更多相關(guān)內(nèi)容可以進入相關(guān)頻道進行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！