myguangzhou
作者myguangzhou·2012-02-08 14:24
技术经理·Uniwise

如何删除asm Diskgroup

字数 2049阅读 7265评论 0赞 0
[oracle@racdb1 ~]$ export ORACLE_SID=+ASM1
[oracle@racdb1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Feb 8 14:08:05 2012
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
 
SQL> select name,state from v$asm_diskgroup;
NAME                           STATE
------------------------------ -----------
DATA                           MOUNTED
FRA                            DISMOUNTED
ARCH                           MOUNTED
SQL> drop diskgroup FRA;
drop diskgroup FRA
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "FRA" does not exist or is not mounted

SQL> alter diskgroup FRA mount;
Diskgroup altered.
SQL> drop diskgroup FRA;
Diskgroup dropped.
SQL> select name,state from v$asm_diskgroup;
NAME                           STATE
------------------------------ -----------
DATA                           MOUNTED
ARCH                           MOUNTED
 

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广