REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_dbf_in_backup.sql
REM
REM <SQLDIR_GRP>DBF BACKUP</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports Datafiles In Back Up Mode
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_dbf_in_backup.sql
REM 
REM Example:
REM	s_dbf_in_backup.sql
REM
REM
REM History:
REM	09-09-1999	VMOGILEV	Created
REM
REM

set lines 132
set feedback on

col file_name       format a50 heading "Files Being Backed Up"
col tablespace_name format a30 heading "Tablespace Name"

select f.file_name, f.tablespace_name, b.status
from dba_data_files     f
,    v$backup           b
where b.file# = f.file_id
and   b.status = 'ACTIVE'
/