This content has been marked as final. Show 4 replies
If you use SQLPLUS to drop Diskgroup you must to use "srvctl remove diskgroup -g" to remove diskgroup from OCR.
If you use ASMCA one step remove both.
No, there is no one command to do it.... but is easy with 4 command.
oracle@node1 > sqlplus / as sysasm SQL> sqlplus / as sysasm SQL> ! srvctl status diskgroup -g DATA Disk Group DATA is running on node1,node2,node3 SQL> ! srvctl stop diskgroup -g DATA -n node2,node3 SQL> DROP DISKGROUP DATA; SQL > ! srvctl remove diskgroup -g DATA
Good Query and Good Finding.
On release 188.8.131.52, after drop a diskgroups ASM is not releasing file descriptors on the raw devices.
Document 4693355.8 states that this problem (Bug:4693355 & Bug:7225720) is fixed on release 184.108.40.206.0, but the problem persists on release 220.127.116.11.0. Even if DROP DISKGROUP or DISMOUNT DISK GROUP scenarios.
Example : $ asmcmd
ASMCMD> dropdg -r DATADG
Oracle Recommends :
A) DROP DISKGROUP SCENARIO:
B) DISMOUNT DISKGROUP SCENARIO:
*More Details : please look "ASM 18.104.22.168 Is Not Releasing File Descriptors After Drop or Dismount Diskgroup. [ID 1306574.1]"*
961469 wrote:Yes, to drop a diskgroup it must be mounted only on node which you will issue "drop" command. ( i.e you can't drop a diskgroup dismounted)
thanks Levi, clear as always. Is there any reason why you left node 1 out of the node list in the stop diskgroup command above?