檢查asm磁碟組狀態的檢視v$asm_diskgroup

msdnchina發表於2011-06-24
ASM

select name, state from v$asm_diskgroup

此檢視在asm例項和db 例項中都能查詢到。在這兩個檢視中看到的state是不一樣的。

asm例項 中state 返回MOUNTED

db 例項 中state 返回 CONNECTED
對此檢視的解釋：

In an Automatic Storage Management instance, V$ASM_DISKGROUP displays one row for every disk group discovered by the Automatic Storage Management instance. In a database instance, V$ASM_DISKGROUP displays one row for every Automatic Storage Management disk group mounted by the local Automatic Storage Management instance.

State of the disk group relative to the instance:

  • CONNECTED - Disk group is in use by the database instance

  • BROKEN - Database instance lost connectivity to the Automatic Storage Management 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 Automatic Storage Management instance following a successful mount

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

[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/161195/viewspace-1051582/，如需轉載，請註明出處，否則將追究法律責任。

相關文章