Check for fuzzy files and recovery point

Staging push requires no files are "fuzzy". To determine this the following query can be used:

select hxfil file#,  

       substr(hxfnm, 1, 50) name, 

       fhscn checkpoint_change#, 

       fhafs absolute_fuzzy_scn, 

       max(fhafs) over () min_pit_scn 

from x$kcvfh where fhafs!=0 ; 

Datafiles must be recovered to at least min_pit_scn