Drop offline tablespace
Currently Rman backups are failing with "RMAN-00571:could not read file header for datafile 7 error reason 4", and datafile 7 is the one offline:
The query:
SELECT FILE#, STATUS, ERROR, RECOVER, TABLESPACE_NAME, NAME
FROM V$DATAFILE_HEADER
WHERE RECOVER = 'YES'
OR (RECOVER IS NULL AND ERROR IS NOT NULL);
Returns:
"FILE#","STATUS","ERROR", "RECOVER","TABLESPACE_NAME","NAME"