diskgroups add and drop
DESCRIPTION
Oracle ASMTRANSCRIPT
![Page 1: Diskgroups Add and drop](https://reader031.vdocuments.us/reader031/viewer/2022020202/577cc3db1a28aba711975c06/html5/thumbnails/1.jpg)
SQL> Drop diskgroup DEVDB including contents;
Diskgroup dropped.
SQL> create diskgroup PRODDB external redundancy DISK 'ORCL:VOL1', 'ORCL:VOL3', 'ORCL:VOL2';
Diskgroup created.
SQL> alter diskgroup 'PRODDB' add directory '+PRODDB/GPILPROD';
Diskgroup altered.
SQL> alter diskgroup 'PRODDB' add directory '+PRODDB/GPILPROD/CONTROLFILE';
Diskgroup altered.
SQL> alter diskgroup 'PRODDB' add directory '+PRODDB/GPILPROD/DATAFILE';
Diskgroup altered.
SQL> alter diskgroup 'PRODDB' add directory '+PRODDB/GPILPROD/ONLINELOG';
Diskgroup altered.
SQL> alter diskgroup 'PRODDB' add directory '+PRODDB/GPILPROD/TEMPFILE';
Diskgroup altered.