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:
Post a Comment