Alias Filenames

ALTER DISKGROUP dskgrp01 DELETE ALIAS ‘+dskgrp01/SALESDB/salesdata_1.dbf’;

To drop files and associated alias names from a disk group, use the DROP FILE clause of the ALTER DISKGROUP command. In the example given above, the alias +dskgrp01/SALESDB/salesdata_1.dbf was dropped, but the file still remains on the system.

To remove the file along with its alias name, issue the following command:

ALTER DISKGROUP dskgrp01 DROP FILE  ‘+dskgrp01/SALESDB/salesdata_1.dbf’;

The system generated alias in the DROP FILE command can also be used.

ALTER DISKGROUP dskgrp01 DROP FILE  ‘‘+dgroup1/qadata/testdb2/sales.325.3’;

The next section will review the process of dropping an ASM disk group.

Dropping a Disk Group

An ASM disk group can be dropped with the DROP DISKGROUP command and, optionally, its files using the INCLUDING CONTENTS clause. The default option for DROP DISKGROUP is EXCLUDING CONTENTS, which prevents dropping a disk group with contents.