We can check our database’s tablespace or datafile status is in BACKUPMODE or Not with the following sql syntax ;

SELECT t.name, d.file# as, b.status FROM V$DATAFILE d, V$TABLESPACE t, V$BACKUP b WHERE d.TS#=t.TS# AND b.FILE#=d.FILE#;

Example ;

ACTIVE –> Tablespace / Datafile in BACKUPMODE state

INACTIVE –> Tablespace / Datafile NOT in backupmode state