資料庫例項中查詢V$asm_disk磁碟頭資訊為unknown

SQL> select group_number, name, state, total_mb, free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MB    FREE_MB
------------ ------------------------------ ----------- ---------- ----------
           1 DGDATA01                       CONNECTED      1024000     981822
           3 DGRECOVER                      MOUNTED         409600     407832

SQL>

SQL> select group_number, disk_number, mount_status, header_status, name, path from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU NAME
------------ ----------- ------- ------------ ------------------------------
PATH
--------------------------------------------------------------------------------
           1           0 OPENED  UNKNOWN      DGDATA01_0000
/dev/rhdiskpower10

           1           1 OPENED  UNKNOWN      DGDATA01_0001
/dev/rhdiskpower11

           1           2 OPENED  UNKNOWN      DGDATA01_0002
/dev/rhdiskpower12

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU NAME
------------ ----------- ------- ------------ ------------------------------
PATH
--------------------------------------------------------------------------------
           1           3 OPENED  UNKNOWN      DGDATA01_0003
/dev/rhdiskpower8

           1           4 OPENED  UNKNOWN      DGDATA01_0004
/dev/rhdiskpower9
          
  

進入到asm例項中，查詢v$asm_diskgroup磁碟組中的狀態為mounted,查詢v$asm_disk中的header_status為member --這個正確

 

SQL> select group_number, name, state, total_mb, free_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MB    FREE_MB
------------ ------------------------------ ----------- ---------- ----------
           1 DGDATA01                       MOUNTED        1024000     981822
           3 DGRECOVER                      MOUNTED         409600     407832

SQL>

SQL> select group_number, disk_number, mount_status, header_status, name, path from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU NAME
------------ ----------- ------- ------------ ------------------------------
PATH
--------------------------------------------------------------------------------
           1           0 OPENED  MEMBER      DGDATA01_0000
/dev/rhdiskpower10

           1           1 OPENED  MEMBER      DGDATA01_0001
/dev/rhdiskpower11

           1           2 OPENED  MEMBER      DGDATA01_0002
/dev/rhdiskpower12

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU NAME
------------ ----------- ------- ------------ ------------------------------
PATH
--------------------------------------------------------------------------------
           1           3 OPENED  MEMBER      DGDATA01_0003
/dev/rhdiskpower8

           1           4 OPENED  MEMBER      DGDATA01_0004
/dev/rhdiskpower9