col "DATA_FILES NAME" form a65
col "CONTROL_FILE NAME" form a65
col "REDOLOG_FILE NAME" form a65
col mo form 999999 heading "Size Mb"
spool datafiles.txt
SET FEED OFF

select file_name "DATA_FILES NAME",bytes/(1024*1024) Mb
from dba_data_files;

select NAME "CONTROL_FILE NAME",status from v$controlfile;

select group#,member "REDOLOG_FILE NAME",status from v$logfile;

SET FEED ON
spool off