SOLVED

ORA-15073: Diskgroup Mounted By Another Instance

Asked by OracleDba••11 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
ORA-15073: Diskgroup Mounted By Another Instance

While dropping a diskgroup, error may come like ORA-15073: diskgroup mounted by another instance.

Problem :

SQL> drop diskgroup DATA including contents;

drop diskgroup DATA including contents

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15073: diskgroup DATA is mounted by another ASM instance
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
In RAC , you have to dismount the diskgroup on all the remote nodes.( except the local node)

Suppose for 2 node rac, i have logged to node 2 and dismounted the diskgroup and ran the drop command on node 1.

LOGIN TO NODE2 ( WITH SYSASM)

SQL> alter diskgroup DATA dismount;

Diskgroup altered.

LOGIN TO NODE 1 ( WITH SYSASM):

SQL> drop diskgroup DATA including contents;

Diskgroup dropped.

NOTE: If you try to drop the diskgroup on the same node, where you have dismounted, then below error will come.

SQL> drop diskgroup DATA including contents;

drop diskgroup DATA including contents

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15001: diskgroup “DATA” does not exist or is not mounted

Hope it Helps!
OracleDba•

Post Your Solution