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.