asm_instance_id

NUMBER

Primary key from the aps_v_asm_instance view

disk_create_date

DATE

Date and time when the disk was added to the disk group

disk_group_id

NUMBER

Primary key from the aps_v_asm_diskgroup view

disk_id

NUMBER

System generated identifier for the Disk

disk_mount_date

DATE

Date and time when the disk was mounted by the first instance

disk_name

STRING

Name of the disk

disk_path

STRING

Operating system path name portion of the name returned by discovery

failgroup

STRING

Name of the failure group containing the disk

failgroup_type

STRING

Type of the failure group with the following possible values:

REGULAR

QUORUM

hash_value

NUMBER

A unique hash value for an ASM disk, computed using the ASM disk

name and the ASM disk group name.

header_status

STRING

Per-instance status of the disk as seen by discovery with the following possible values:

UNKNOWN - 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 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 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 - ASM disk was not mounted due to a conflict

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

label

STRING

Disk label portion of the name returned by discovery

last_updated

DATE

Date and time last updated

library

STRING

Name of the library that discovered the disk

mode_status

STRING

Global status about which kinds of I/O requests are allowed to the disk with the following possible values:

ONLINE - Disk is online and operating normally. Reads and writes are attempted when the disk is mounted. Reads are attempted as part of disk discovery.

OFFLINE - Disk is offline and access to data is not permitted. Reads and writes are not attempted. An offline disk remains logically part of its disk group.

mount_status

STRING

Per-instance status of the disk relative to group mounts with the following possible values:

MISSING - Automatic Storage Management metadata indicates that the disk is known to be part of the Automatic Storage Management (ASM) disk group but no disk in the storage system was found with the indicated name

CLOSED - Disk is present in the storage system but is not being accessed by ASM

OPENED - Disk is present in the storage system and is being accessed by ASM. This is the normal state for disks in a database instance which are part of a Disk Group being actively used by the instance.

CACHED - Disk is present in the storage system and is part of a disk group being accessed by the ASM instance. This is the normal state for disks in an ASM instance which are part of a mounted disk group.

IGNORED - Disk is present in the system but is ignored by ASM because of one of the following:

-- The disk is detected by the system library but is ignored because an ASM library discovered the same disk

-- ASM has determined that the membership claimed by the disk header is no longer valid

CLOSING - ASM is in the process of closing this disk

preferred_read

STRING

Status of the preferred read failure group with the following possible values:

U - Disk group has no preferred read failure group

Y - Disk is a preferred read disk

N - Disk is not a preferred read disk

For a disk group with one or more preferred read failure groups, if the

disk is in one of the preferred read failure groups, the value of this column

is Y; otherwise it is N.

product

STRING

Name of the manufacturer and the name of the product. All disks with the

same product id will have the same performance and reliability characteristics

redundancy

STRING

Hardware redundancy of the disk with the following possible values:

UNKNOWN

UNPROT

MIRROR

PARITY

repair_timer

NUMBER

Seconds remaining until the disk is automatically dropped (0 if not failed)

sector_size

NUMBER

Physical block size (in bytes)

state

STRING

Global state of the disk with respect to the disk group with the following possible values:

UNKNOWN - ASM disk state is not known (typically the disk is not mounted)

NORMAL - Disk is online and operating normally

ADDING - Disk is being added to a disk group, and is pending validation by all instances that have the disk group mounted

DROPPING - Disk has been manually taken offline and space allocation or data access for the disk halts. Rebalancing will commence to relocate data off the disks to other disks in the disk group. Upon completion of the rebalance, the disk is expelled from the group.

HUNG - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped

FORCING - Disk is being removed from the disk group without attempting to offload its data. The data will be recovered from redundant copies, where possible.

DROPPED - Disk has been fully expelled from the disk group

udib

STRING

Unique Device ID portion of the name returned by discovery

voting_file

STRING

Indicates whether the disk contains a voting file (Y) or not (N)