Friday, June 20, 2014

Unmounting ASM disk by querying V$ASM_FILE on 11gR2

The title of My Oracle Support note 1145365.1 "Alert: Querying V$ASM_FILE Gives ORA-15196 After ASM Was Upgraded From 10gR2 to 11gR2 with an AU size > 1M" does not quite tell you the full story because it neglects to tell you what the ORA-15196 message means or what it results in!  The error is for "invalid ASM block header" and it results in the disk going offline if it has less than a certain number of files in the disk group.

I think it would be good to know if a disk will go offline all of a sudden if the GV$ASM_FILE or V$ASM_FILE objects are queried from, so take this as an opportunity to be proactive and run the query in this note to investigate your ASM disk groups before you find out the wrong way that this is an issue!

No comments:

Post a Comment