If you need to check to see if a tablespace is still in backup mode ( alter tablespace tablespace_name begin backup), do you check by looking at status in dba_tablespaces?
thanks
SM
Printable View
If you need to check to see if a tablespace is still in backup mode ( alter tablespace tablespace_name begin backup), do you check by looking at status in dba_tablespaces?
thanks
SM
select df.name, b.status
from v$backup b, v$datafile df
where df.file#=b.file#
will give you the datafile and whether it is being backed up or not (in backup mode). "NOT ACTIVE" means that the tablespace is not in backup mode, where "ACTIVE" means that it is.