Saturday, February 23, 2008

Drop ASM file

Dropping a asm file.you need to specify the fullpath
Run the following to see the asm_files
Connect to the ASM instance.



col full_path for a60
col dir for a3
col sys for a3

SELECT CONCAT('+'||gname,
SYS_CONNECT_BY_PATH(aname,'/')) full_path, dir, sys
FROM (SELECT g.name gname, a.parent_index pindex,
a.name aname, a.reference_index rindex,
a.ALIAS_DIRECTORY dir, a.SYSTEM_CREATED sys
FROM v$asm_alias a, v$asm_diskgroup g
WHERE a.group_number = g.group_number)
START WITH (MOD(pindex, POWER(2, 24))) = 0
CONNECT BY PRIOR rindex = pindex
ORDER BY dir desc, full_path asc;



Then use the full path in the alter diskgroup drop file command



SQL> alter diskgroup data01 drop file
'+DATA01/ORCL/DATAFILE/USERS.259.1'



*****************************
keywords asm file drop remove
*****************************

No comments: