Oracle Expert » How to spot duplicate datafiles
select * from (
select tablespace_name, fullpath, filename, count(filename) over (partition by filename) freq
from ( select tablespace_name, file_name fullpath, substr(file_name, instr(file_name,'/',-1)+1) filename from dba_data_files )
)
where freq > 1;
