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';
暂无评论