List tablespaces in backup mode

Query to list Oracle tablespaces that are in backup mode:

SELECT d.tablespace_name, b.time
FROM dba_data_files d, v$backup b
WHERE d.file_id = b.FILE# AND b.STATUS = 'ACTIVE' ;

Leave a Reply

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