Recovery Manager Restore and Recovery Techniques - Oracle 10g/11g Data and Database Management Utilities - page 130

to_char( H.CHECKPOINT_TIME, 'HH24:MI:SS') TIMESTAMP
from V$DATAFILE D, V$DATAFILE_HEADER H
where D.FILE# = H.FILE# ;
Recover File : The inconsistent datafiles are reported at the V$RECOVER_FILE
dynamic view. It is important to query this view since at startup time, after SMON
has determined that there are data files that required to be manually recovered, a
message will be displayed showing only the first inconsistent data file. The complete
list of inconsistent data files is shown with the following query:
col FILE# for 9999
col FILE_NAME for a45
col ERROR for a25
select D.FILE#,
D.NAME FILE_NAME,
R.ERROR
from V$RECOVER_FILE R, V$DATAFILE D
where R.FILE# = D.FILE#;