List the tablespaces in backup mode

Small query to list Oracle tablespaces, that are in backup mode:

select d.tablespace_name, b.time
from dba_data_files d, v$backup b
d.file_id = b.FILE#
and b.STATUS = 'ACTIVE' ;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.