SELECT log_file_name FROM dba_log_files;
SELECT member FROM v$log;
SELECT member FROM v$logfile;
SELECT log_member FROM V$LOG_FILES;