查找控制文件、数据文件、日志文件

select file#, status, enabled, name from v$datafile;

select * from v$controlfile;

select * from v$logfile;