allfiles.sql

set feedback off
set linesize 200
column name format a60
column member format a60
spool allfiles
select name, log_mode from v$database;
select name from v$datafile;
select member from v$logfile;
select name from v$controlfile;
spool off