Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Under what circumstance mount_status of v$asm_disk would display 'opened'?

gao.fengNov 4 2017 — edited Nov 6 2017

Mount_status of v$asm_disk could be several values.Among of these,is there different between 'opened' and 'cached'?

In Database Reference,it says:

OPENED - Disk is present in the storage system and is being accessed by Oracle 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 Oracle ASM instance. This is the normal state for disks in an Oracle ASM instance which are part of a mounted disk group.

My enviroment is Grid Infrastructure on a standalone windwos server.And when i make a enquiry either through rdbms or asm instance,it always reports that the column,mount_status,  is cached.

SYS@+asm> select group_number,disk_number,mount_status,header_status,state,redundancy,

  2    path from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE    REDUNDA PATH

------------ ----------- ------- ------------ -------- ------- --------------------

           1           0 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA0

           1           1 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA1

           1           2 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA2

           1           3 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA3

SYS@orcl>select group_number,disk_number,mount_status,header_status,state,redundancy,

  2    path from v$asm_disk;

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU STATE    REDUNDA PATH

------------ ----------- ------- ------------ -------- ------- --------------------

           1           0 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA0

           1           1 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA1

           1           2 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA2

           1           3 CACHED  MEMBER       NORMAL   UNKNOWN \\.\ORCLDISKDATA3

I wonder under what circumstance it would display 'opened',and under what circumastance it would be 'cached'?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2017
Added on Nov 4 2017
0 comments
489 views