oracle V$ASM_DISK 视图含义

V$ASM_DISKIn an Automatic Storage Management instance, [font=NSimsun]V$ASM_DISK displays one row for every disk discovered by the Automatic Storage Management instance, including disks which are not part of any disk group. In a database instance, [font=NSimsun]V$ASM_DISK only displays rows for disks in disk groups in use by the database instance.
[table=98%]
ColumnDatatypeDescription
[font=NSimsun]GROUP_NUMBER[font=NSimsun]NUMBERNumber of the disk group containing the disk (foreign key to the [font=NSimsun]V$ASM_DISKGROUP view)
[font=NSimsun]DISK_NUMBER[font=NSimsun]NUMBERNumber assigned to the disk within its disk group
[font=NSimsun]COMPOUND_INDEX[font=NSimsun]NUMBERA 32-bit number consisting of a disk group number in the high-order 8 bits and a disk number in the low-order 24 bits (for efficient access to the view)
[font=NSimsun]INCARNATION[font=NSimsun]NUMBERIncarnation number for the disk
[font=NSimsun]MOUNT_STATUS[font=NSimsun]VARCHAR2(7)Per-instance status of the disk relative to group mounts: [list]
[*][font=NSimsun]MISSING - Automatic Storage Management metadata indicates that the disk is known to be part of the Automatic Storage Management disk group, but no disk in the storage system was found with the indicated name

[*][font=NSimsun]CLOSED - Disk is present in the storage system but is not being accessed by Automatic Storage Management

[*][font=NSimsun]OPENED - Disk is present in the storage system and is being accessed by Automatic Storage Management. This is the normal state for disks in a database instance which are part of a Disk Group being actively used by the instance.

[*][font=NSimsun]CACHED - Disk is present in the storage system, and is part of a disk group being accessed by the Automatic Storage Management instance. This is the normal state for disks in an Automatic Storage Management instance which are part of a mounted disk group.

[*][font=NSimsun]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

[*][font=NSimsun]CLOSING - ASM is in the process of closing this disk

[font=NSimsun]HEADER_STATUS[font=NSimsun]VARCHAR2(12)Per-instance status of the disk as seen by discovery: [list]
[*][font=NSimsun]UNKNOWN - Automatic Storage Management disk header has not been read

[*][font=NSimsun]CANDIDATE - Disk is not part of a disk group and may be added to a disk group with the [font=NSimsun]ALTER DISKGROUP statement

[*][font=NSimsun]INCOMPATIBLE - Version number in the disk header is not compatible with the Automatic Storage Management software version.

[*][font=NSimsun]PROVISIONED - Disk is not part of a disk group and may be added to a disk group with the [font=NSimsun]ALTER DISKGROUP statement. The [font=NSimsun]PROVISIONED header status is different from the [font=NSimsun]CANDIDATE header status in that [font=NSimsun]PROVISIONED implies that an additional platform-specific action has been taken by an administrator to make the disk available for Automatic Storage Management.

[*][font=NSimsun]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 [font=NSimsun]ALTER DISKGROUP statement will reject such an addition unless overridden with the [font=NSimsun]FORCE option

[*][font=NSimsun]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 [font=NSimsun]ALTER DISKGROUP statement.

[*][font=NSimsun]CONFLICT - Automatic Storage Management disk was not mounted due to a conflict

[*][font=NSimsun]FOREIGN - Disk contains data created by an Oracle product other than ASM. This includes datafiles, logfiles, and OCR disks.

[font=NSimsun]MODE_STATUS[font=NSimsun]VARCHAR2(7)Global status about which kinds of I/O requests are allowed to the disk: [list]
[*][font=NSimsun]UNKNOWN - Automatic Storage Management disk mode is not known (typically the disk is not mounted)

[*][font=NSimsun]ONLINE - Disk is online and operating normally. Reads and writes are attempted.

[*][font=NSimsun]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.

[font=NSimsun]STATE[font=NSimsun]VARCHAR2(8)Global state of the disk with respect to the disk group: [list]
[*][font=NSimsun]UNKNOWN - Automatic Storage Management disk state is not known (typically the disk is not mounted)

[*][font=NSimsun]NORMAL - Disk is online and operating normally

[*][font=NSimsun]ADDING - Disk is being added to a disk group, and is pending validation by all instances that have the disk group mounted

[*][font=NSimsun]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.

[*][font=NSimsun]HUNG - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped

[*][font=NSimsun]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.

[*][font=NSimsun]DROPPED - Disk has been fully expelled from the disk group

[font=NSimsun]REDUNDANCY[font=NSimsun]VARCHAR2(7)External redundancy of the disk: [list]
[*][font=NSimsun]UNKNOWN

[*][font=NSimsun]UNPROT

[*][font=NSimsun]MIRROR

[*][font=NSimsun]PARITY

[font=NSimsun]LIBRARY[font=NSimsun]VARCHAR2(64)Name of the library that discovered the disk
[font=NSimsun]TOTAL_MB[font=NSimsun]NUMBERTotal capacity of the disk (in megabytes)
[font=NSimsun]FREE_MB[font=NSimsun]NUMBERUnused capacity of the disk (in megabytes)
[font=NSimsun]NAME[font=NSimsun]VARCHAR2(30)Name of the disk
[font=NSimsun]FAILGROUP[font=NSimsun]VARCHAR2(30)Name of the failure group containing the disk
[font=NSimsun]LABEL[font=NSimsun]VARCHAR2(31)Disk label portion of the name returned by discovery
[font=NSimsun]PATH[font=NSimsun]VARCHAR2(256)Operating system pathname portion of the name returned by discovery
[font=NSimsun]UDID[font=NSimsun]VARCHAR2(64)Universal Device ID portion of the name returned by discovery
[font=NSimsun]PRODUCT[font=NSimsun]VARCHAR2(32)The 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.
[font=NSimsun]CREATE_DATE[font=NSimsun]DATEDate and time when the disk was added to the disk group
[font=NSimsun]MOUNT_DATE[font=NSimsun]DATEDate and time when the disk was mounted by the first instance
[font=NSimsun]REPAIR_TIMER[font=NSimsun]NUMBERSeconds remaining until the disk is automatically dropped ([font=NSimsun]0 if not failed)
[font=NSimsun]READS[font=NSimsun]NUMBERTotal number of I/O read requests for the disk
[font=NSimsun]WRITES[font=NSimsun]NUMBERTotal number of I/O write requests for the disk
[font=NSimsun]READ_ERRS[font=NSimsun]NUMBERTotal number of failed I/O read requests for the disk
[font=NSimsun]WRITE_ERRS[font=NSimsun]NUMBERTotal number of failed I/O write requests for the disk
[font=NSimsun]READ_TIME[font=NSimsun]NUMBERTotal I/O time (in hundredths of a second) for read requests for the disk if the [font=NSimsun]TIMED_STATISTICS initialization parameter is set to [font=NSimsun]true ([font=NSimsun]0 if set to [font=NSimsun]false)
[font=NSimsun]WRITE_TIME[font=NSimsun]NUMBERTotal I/O time (in hundredths of a second) for write requests for the disk if the [font=NSimsun]TIMED_STATISTICS initialization parameter is set to [font=NSimsun]true ([font=NSimsun]0 if set to [font=NSimsun]false)
[font=NSimsun]BYTES_READ[font=NSimsun]NUMBERTotal number of bytes read from the disk
[font=NSimsun]BYTES_WRITTEN[font=NSimsun]NUMBERTotal number of bytes written to the disk