Datafile corruption

[tovohery]

Hi,
When a run the query

select vd.name,to_char(vd.unrecoverable_time,'dd-MON-yyyy:hh24:mi:ss') corrupt_date
from v$datafile vd, v$backup vb
where vd.file#=vb.file#
and vd.unrecoverable_time is not null
order by 2 desc;

I found that my datafile was corrupt.
What is the impact of that in the database and what is the way to solve this problem?

Best regards.

[skhanal]

It does not mean the database is corrupt, it only means you allowed non logged operation in the database and if you want to do point in time restore you can't do that because the operation is not in archive log.

Try to avoid non logged operation, if you have any document them properly so that any such operation can be re-run when you recover your database.