PROBLEM:
While mounting a diskgroup in restrict mode, got below error:
SQL> alter diskgroup NEWTST mount restricted;
alter diskgroup NEWTST mount restricted
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15235: diskgroup NEWTST mount mode conflicts with existing mount
Solution:
This is because, the diskgroup is dismounted in local node, but it is in mount stage is remote nodes.
SQL> select inst_id,name,state from gv$asm_diskgroup where name='NEWTST'; INST_ID NAME STATE ---------- ------------------------------ ----------- 1 NEWTST DISMOUNTED 2 NEWTST MOUNTED
So to mount an asm diskgroup in restrict mode, Make sure the diskgroup is dismounted on all remote nodes.
NODE 2 :
alter diskgroup NEWTST dismount;
Now connect to NODE 1 and run the restrict command.
SQL> alter diskgroup NEWTST mount restricted; Diskgroup altered.