The script will list your tablespace state / backup mode in Oracle
select a.file#,
b.name,
decode(a.status,
'ACTIVE',
'In backup mode',
'NOT ACTIVE',
'Not in backup mode') as "backup mode"
from v$backup a, v$datafile b
where a.file# = b.file#