"alter system set ...='..' scope=spfile;
You go to start up your database, and it won't start.. You find the change you made isn't compatible.. Your SGA won't work for you box, the parameter was invalid.. Who knows what the problem is, but what do you do ? With "cooked" file systems, it was easy.. Take your spfile, and make an init file out of it... With ASM, it's even more complicated.. What's an easy fix ??? Do this
(this is for a database called orcl).
Create an init file for orcl initorcl.ora containing.
...='...' --- The correct value for the parameter
spfile='+DISKGROUP/orcl/spfile/initorcl.ora'
This will override that one parameter in the spfile, but allow the rest of the parameters to be used. Once you have the database started, then do the alter system, scope=spfile to correct it, and you are set. Easy as Pie
