-- is any datafile in backup mode ?
select * from v$backup;

 

-- is any CF enqueue lock ?
set linesize 200
set module for a10

SELECT s.sid, s.serial#, p.spid "SPID (OS PID)", s.username AS "User", s.program, action, TO_CHAR(logon_time,'DD.MM.YYYY HH24:MI:SS') "Logon" 
FROM v$session s,  v$process p, v$enqueue_lock l
WHERE s.paddr=p.addr and l.sid = s.sid and l.type = 'CF' AND l.id1 = 0 and l.id2 = 2;