SELECT NAME FROM v$datafile
union
select member from v$logfile
union
select name from v$controlfile
union
select value from v$parameter
where (name like 'log_archive_dest%'
and name not like 'log_archive_dest_state%')
or name in ('log_archive_dest', 'log_archive_duplex_dest')
/