检查asm磁盘组状态的视图v$asm_diskgroup

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.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1021.htm#REFRN30171

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/161195/viewspace-1051582/