Skip to Main Content

Database Software

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!

ASM Label different in v$asm_disk.PATH and v$asm_disk.NAME

resistanceIsFruitfulJul 25 2014 — edited Jul 26 2014

Grid Infra Version:11.2.0.4

DB version: 11.2.0.4

Oracle Linux version : 6.4

We have a 2-node RAC cluster.

For a particual disk, usually whatever mentioned after ORCL: in v$asm_disk.PATH column and v$asm_disk.NAME are same.

Example:

PATH                      NAME

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

ORCL:DATA21              DATA21

But, in this particular cluster, I can see several disks whose label differs between $asm_disk.PATH column and v$asm_disk.NAME

Example:

PATH                      NAME                

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

ORCL:ARCHIVE1             CMS_ARCHIVE1        

SQL> select path, name, GROUP_NUMBER,TOTAL_MB/1024,FREE_MB/1024 from v$asm_disk order by 1,2 asc;

PATH                      NAME                 GROUP_NUMBER TOTAL_MB/1024 FREE_MB/1024

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

ORCL:ARCHIVE1             CMS_ARCHIVE1                    1           100   99.9882813

ORCL:ARCHIVE10            CMS_ARCHIVE10                   1           100   99.9882813

ORCL:ARCHIVE2             CMS_ARCHIVE2                    1           100   99.9892578

ORCL:ARCHIVE3             CMS_ARCHIVE3                    1           100   99.9892578

ORCL:ARCHIVE4             CMS_ARCHIVE4                    1           100   99.9863281

ORCL:ARCHIVE5             CMS_ARCHIVE5                    1           100   99.9892578

ORCL:ARCHIVE6             CMS_ARCHIVE6                    1           100   99.9882813

ORCL:ARCHIVE7             CMS_ARCHIVE7                    1           100   99.9902344

ORCL:ARCHIVE8             CMS_ARCHIVE8                    1           100   99.9902344

ORCL:ARCHIVE9             CMS_ARCHIVE9                    1           100   99.9902344

ORCL:DATA1                CMS_DATA1                       2    500.000977   59.1601563

ORCL:DATA10               CMS_DATA10                      2    500.000977   59.1513672

ORCL:DATA11               CMS_DATA11                      2    500.000977   59.1542969

ORCL:DATA12               CMS_DATA12                      2    500.000977   59.1591797

ORCL:DATA13               CMS_DATA13                      2    500.000977   59.1484375

ORCL:DATA14               CMS_DATA14                      2    500.000977   59.1523438

ORCL:DATA15               CMS_DATA15                      2    500.000977   59.1621094

ORCL:DATA16               CMS_DATA16                      2    500.000977     59.15625

ORCL:DATA17               CMS_DATA17                      2    500.000977   59.1455078

ORCL:DATA18               CMS_DATA18                      2    500.000977   59.1542969

ORCL:DATA19               CMS_DATA19                      2    500.000977   59.1601563

ORCL:DATA2                CMS_DATA2                       2    500.000977   59.1503906

ORCL:DATA20               CMS_DATA20                      2    500.000977   59.1552734

ORCL:DATA21               DATA21                          7           500    383.53125

ORCL:DATA22               DATA22                          7           500   383.507813

ORCL:DATA3                CMS_DATA3                       2    500.000977   59.1464844

ORCL:DATA4                CMS_DATA4                       2    500.000977   59.1435547

ORCL:DATA5                CMS_DATA5                       2    500.000977   59.1630859

ORCL:DATA6                CMS_DATA6                       2    500.000977   59.1533203

ORCL:DATA7                CMS_DATA7                       2    500.000977   59.1572266

ORCL:DATA8                CMS_DATA8                       2    500.000977   59.1513672

ORCL:DATA9                CMS_DATA9                       2    500.000977   59.1621094

This post has been answered by Dude! on Jul 26 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2014
Added on Jul 25 2014
4 comments
1,259 views