asm_instance_id

NUMBER

Primary key from the aps_v_asm_instance view

compatible_version

STRING

Compatibility setting of the database or ASM instance for the selected disk group connection

db_instance_name

STRING

Identifier for the database instance client

db_name

STRING

Unique database name of the database client instance

last_updated

DATE

Date and time last updated

status

STRING

State of the disk group relative to the instance with the following possible values:

CONNECTED - Disk group is in use by the database instance

BROKEN - Database instance lost connectivity to the ASM instance that mounted the disk group

UNKNOWN - Automatic Storage Management instance has never attempted to mount the disk group

DISMOUNTED - Disk group was cleanly dismounted by the ASM instance following a successful mount

MOUNTED - Instance is successfully serving the disk group to its database clients

QUIESCING - CRSCTL utility attempted to dismount a disk group that contains the Oracle Cluster Registry (OCR). The disk group

cannot be dismounted until Cluster Ready Services (CRS) exits, because the disk group contains the OCR.

version

STRING

Software version number of the database or ASM instance for the selected disk group connection