ORACLE 12C 三節點 RAC 無法找到候選磁盤V$ASM_DISK

一、描述

測試安裝三節點Oracle 12C RAC，筆記本配置雙核i5 16g記憶體，每台虛機配置設定4G 記憶體。

在叢集軟體安裝過程中，無法找到候選磁盤，如下圖所示：

<a href="https://s4.51cto.com/wyfs02/M01/9E/DA/wKioL1mX5TLxobFJAAKDNGrderk630.png-wh_500x0-wm_3-wmp_4-s_2861083968.png" target="_blank"></a>

<a href="https://s3.51cto.com/wyfs02/M01/00/2B/wKiom1mX5kaiOUtiAAIMCTMt2Ck362.png-wh_500x0-wm_3-wmp_4-s_4040970590.png" target="_blank"></a>

二、處理過程

觀察磁盤頭狀态，發現問題的原因。因為是測試環境，共享磁盤使用的是openfiler，之前11g rac 使用了原有磁盤，這裡需要dd一下，清理一下中繼資料，然後重新掃一下磁盤。指令如下：

[root@rac01 rules.d]# dd if=/dev/zero of=/dev/sde bs=4096 count=256 

256+0 records in

256+0 records out

1048576 bytes (1.0 MB) copied, 0.00297706 s, 352 MB/s

[root@rac01 rules.d]# dd if=/dev/zero of=/dev/sdf bs=4096 count=256 

1048576 bytes (1.0 MB) copied, 0.00189521 s, 553 MB/s

知識點連接配接：

<a href="http://docs.oracle.com/database/122/REFRN/V-ASM_DISK.htm#REFRN30170" target="_blank">http://docs.oracle.com/database/122/REFRN/V-ASM_DISK.htm#REFRN30170</a>

了解header_status 的含義

<code>V$ASM_DISK</code> displays one row for every disk discovered by the Oracle Automatic Storage Management (Oracle ASM) instance, including disks that are not part of any disk group.

HEADER_STATUS

VARCHAR2(12)

Per-instance status of the disk as seen by discovery:

UNKNOWN - Oracle ASM disk header has not been read

CANDIDATE - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement

INCOMPATIBLE - Version number in the disk header is not compatible with the Oracle ASM software version

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 PROVISIONED implies that an additional platform-specific action has been taken by an administrator to make the disk available for Oracle ASM.

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.

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.

CONFLICT - Oracle ASM disk was not mounted due to a conflict

FOREIGN - Disk contains data created by an Oracle product other than Oracle ASM. This includes data files, logfiles, and OCR disks.

本文轉自 roidba 51CTO部落格，原文連結：http://blog.51cto.com/roidba/1957615，如需轉載請自行聯系原作者