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

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

这是报错是因为RAC中其它的实例已经mount了这个磁盘组,在其它实例执行dismount后,重新drop即可

[grid@server02 ~]$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 27 10:25:07 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> alter diskgroup data dismount;

Diskgroup altered.

[grid@server01 ~]$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 27 10:30:45 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> drop diskgroup data including contents;

Diskgroup dropped.

如果无法dismount磁盘组,可以使用force选项:

SQL> drop diskgroup data force including contents;

SQL> CREATE DISKGROUP data EXTERNAL  REDUNDANCY DISK
    '/dev/asm-diske' NAME data_0000,
    '/dev/asm-diskf' NAME data_0001
  ATTRIBUTE 'au_size'='4M';

SQL> CREATE DISKGROUP data EXTERNAL  REDUNDANCY DISK
    '/dev/asm-diske' NAME data_0000,
    '/dev/asm-diskf' NAME data_0001
 ATTRIBUTE 'au_size'='4M',
 'compatible.asm' = '19.0',
'compatible.rdbms' = '19.0';
 ---'compatible.advm' = '19.3';
暂无评论

发送评论 编辑评论


				
|´・ω・)ノ
ヾ(≧∇≦*)ゝ
(☆ω☆)
(╯‵□′)╯︵┴─┴
 ̄﹃ ̄
(/ω\)
∠( ᐛ 」∠)_
(๑•̀ㅁ•́ฅ)
→_→
୧(๑•̀⌄•́๑)૭
٩(ˊᗜˋ*)و
(ノ°ο°)ノ
(´இ皿இ`)
⌇●﹏●⌇
(ฅ´ω`ฅ)
(╯°A°)╯︵○○○
φ( ̄∇ ̄o)
ヾ(´・ ・`。)ノ"
( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃
(ó﹏ò。)
Σ(っ °Д °;)っ
( ,,´・ω・)ノ"(´っω・`。)
╮(╯▽╰)╭
o(*////▽////*)q
>﹏<
( ๑´•ω•) "(ㆆᴗㆆ)
😂
😀
😅
😊
🙂
🙃
😌
😍
😘
😜
😝
😏
😒
🙄
😳
😡
😔
😫
😱
😭
💩
👻
🙌
🖕
👍
👫
👬
👭
🌚
🌝
🙈
💊
😶
🙏
🍦
🍉
😣
Source: github.com/k4yt3x/flowerhd
颜文字
Emoji
小恐龙
花!
上一篇
下一篇