oracle10g v$asm_disk之header_status的意义
SQL> alter diskgroup dg01 drop disk VOL5;
SQL> alter diskgroup dg01 drop disk VOL6;
SQL> select group_number,mount_status,header_status,name,path from v$asm_disk;
GROUP_NUMBER MOUNT_STATUS HEADER_STATUS NAME PATH
----------------------- ---------------------- ------------------------ ----------- --------------------
0 CLOSED FOREIGN /dev/raw/raw5
0 CLOSED FOREIGN /dev/raw/raw4
0 CLOSED FOREIGN /dev/raw/raw3
0 CLOSED FOREIGN /dev/raw/raw2
0 CLOSED FOREIGN /dev/raw/raw1
0 CLOSED FORMER ORCL:VOL5
0 CLOSED FORMER ORCL:VOL6
1 CACHED MEMBER VOL1 ORCL:VOL1
1 CACHED MEMBER VOL2 ORCL:VOL2
1 CACHED MEMBER VOL3 ORCL:VOL3
1 CACHED MEMBER VOL4 ORCL:VOL4
11 rows selected.
附上列header_status的对应值解释
1) UNKNOWN 未知
- Automatic Storage Management disk header hasnot been read
如果你在数据库实例去查询v$asm_disk,都会是UNKNOWN状态,这不准确,所以请到ASM实例去查询。
2) CANDIDATE 候选者
- Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement
3) INCOMPATIBLE 不兼容
-Version number in the disk header is not compatible with the Automatic Storage Management software version.
4) PROVISIONED 供应,预备
- Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement.
The PROVISIONED header status is different from the CANDIDATE header status in that PROVISIONE
Dimplies that an additional platform-specific action has been taken by an administrator to make the disk
available for Automatic Storage Management.
5) MEMBER 成员
- Disk is a member of an existing disk group. No attempt should be made to add the disk to a different disk
group. The ALTER DISKGROUP statement will reject such an addition unless overridden with the FORCE option
6) FORMER 前任的
- Disk was once part of a disk group but has been dropped cleanly from the group. It may be added to a
new disk group with the ALTER DISKGROUP statement.
7) CONFLICT 冲突
- Automatic Storage Management disk was not mounted due to a conflict
8) FOREIGN 外来的
- Disk contains data created by an Oracle product other than ASM. This includes datafiles, logfiles, and OCR disks.
SQL> alter diskgroup dg01 drop disk VOL5;
SQL> alter diskgroup dg01 drop disk VOL6;
SQL> select group_number,mount_status,header_status,name,path from v$asm_disk;
GROUP_NUMBER MOUNT_STATUS HEADER_STATUS NAME PATH
----------------------- ---------------------- ------------------------ ----------- --------------------
0 CLOSED FOREIGN /dev/raw/raw5
0 CLOSED FOREIGN /dev/raw/raw4
0 CLOSED FOREIGN /dev/raw/raw3
0 CLOSED FOREIGN /dev/raw/raw2
0 CLOSED FOREIGN /dev/raw/raw1
0 CLOSED FORMER ORCL:VOL5
0 CLOSED FORMER ORCL:VOL6
1 CACHED MEMBER VOL1 ORCL:VOL1
1 CACHED MEMBER VOL2 ORCL:VOL2
1 CACHED MEMBER VOL3 ORCL:VOL3
1 CACHED MEMBER VOL4 ORCL:VOL4
11 rows selected.
附上列header_status的对应值解释
1) UNKNOWN 未知
- Automatic Storage Management disk header hasnot been read
如果你在数据库实例去查询v$asm_disk,都会是UNKNOWN状态,这不准确,所以请到ASM实例去查询。
2) CANDIDATE 候选者
- Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement
3) INCOMPATIBLE 不兼容
-Version number in the disk header is not compatible with the Automatic Storage Management software version.
4) PROVISIONED 供应,预备
- Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement.
The PROVISIONED header status is different from the CANDIDATE header status in that PROVISIONE
Dimplies that an additional platform-specific action has been taken by an administrator to make the disk
available for Automatic Storage Management.
5) MEMBER 成员
- Disk is a member of an existing disk group. No attempt should be made to add the disk to a different disk
group. The ALTER DISKGROUP statement will reject such an addition unless overridden with the FORCE option
6) FORMER 前任的
- Disk was once part of a disk group but has been dropped cleanly from the group. It may be added to a
new disk group with the ALTER DISKGROUP statement.
7) CONFLICT 冲突
- Automatic Storage Management disk was not mounted due to a conflict
8) FOREIGN 外来的
- Disk contains data created by an Oracle product other than ASM. This includes datafiles, logfiles, and OCR disks.