Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

V$ASM_DISKGROUP is showing a diskgroup in CONNECTED state but the database is not using that diskgro

edited Jul 1, 2019 6:00PM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 11 commentsAnswered

We have a database called RMSTST which is using two ASM diskgroups as far as we can see.

ASM_ARCHIVE

ASM_RMSTST

But there is another diskgroup called ASM_RAILTST which is also being shown as being in CONNECTED state when we run the below command in RMSTST.

SELECT * FROM V$ASM_DISKGROUP where state = 'CONNECTED';

16,ASM_RAILTST,CONNECTED,10.1.0.0.0,10.1.0.0.0   <===== WRONG ENTRY

18,ASM_ARCHIVE,CONNECTED,12.1.0.0.0,10.1.0.0.0

19,ASM_RMSTST,CONNECTED,10.1.0.0.0,10.1.0.0.0

We don't see any parameter, data file, log file using the ASM_RAILTST diskgroup.

We also don't see anything under ASM_RAILTST diskgroup in ASMCMD that is related to RMSTST.

ASMCMD> pwd

+ASM_RAILTST

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center