oracle10g v$asm_disk之header_status的意义

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.


  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

lordcoohoo

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值