SQL> show parameter diskgroup
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string TEST, TEST1Total System Global Area 130023424 bytes
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string C:\ORACLE\PRODUCT\10.2.0\DB_1\
DATABASE\SPFILE+ASM.ORA
尝试修改asm_diskgroup,成功
alter system set asm_diskgroup='TEST' scope=both;
但是再重开ASM instance时老是出现以下错误
Fixed Size 2075816 bytesVariable Size 102781784 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "TEST1"
原因:
因为直接在后台删除了diskgroup test1里面的所有分区,此时在v$asm_diskgroup里就不再显示TEST1
修改asm_diskgroup还是无效,每次开启ASM instance时都会去加载TEST1
如果是正常进行dismount动作就不会出现这种情况
解决方法:
1 create pfile from spfile;
2 在生成的pfile里直接修改adm_diskgroup
3 create spfile from pfile