사용중인 모든 dbf파일, log파일 확인

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 11.2.0.4

쿼리 : 사용중인 모든 dbf파일, log파일 확인

select name from v$datafile
union
select member from v$logfile
union
select name from v$controlfile
where (name like 'log_archive_dest%'
and name not like 'log_archive_dest_state%')
or name in('log_archive_dest','log_archive_dyplex_dest');

결과값 : 

NAME
------------------------------------------
/oradata/ORCL/drsys01.dbf
/oradata/ORCL/indx01.dbf
/oradata/ORCL/pymts01.dbf
/oradata/ORCL/redo01.log
/oradata/ORCL/redo02.log
/oradata/ORCL/redo03.log
/oradata/ORCL/system01.dbf
/oradata/ORCL/tools01.dbf
/oradata/ORCL/undotbs01.dbf
/oradata/ORCL/users01.dbf
/oradata/ORCL/xdb01.dbf
 
11 rows selected.

참조 :