select d.file# f#, d.name, d.status, h.status
from v$datafile d, v$datafile_header h
where d.file# = h.file#
and (d.status not in ('SYSTEM','ONLINE') or h.status != 'ONLINE' );


If there are such files, the recovery is necessary:

1. restore the file from the backup
2. recover datafile ‘&the_file_name’ ;
3. alter database datafile ‘&the_file_name’ online;

Another possibility (if there are a lot of files):

1. restore the files from the backup
2. recover tablespace ‘&tbs_name’ ;
3. alter tablespace ‘&tbs_name’ online;