v$ or rc views to report on RMAN restore database preview
V$BACKUP_DATAFILE
  
  V$BACKUP_DATAFILE displays information about control files and datafiles in backup sets from the control file.


Media recovery start SCN is 7962109213
Recovery must be done beyond SCN 7962156379 to clear datafile fuzziness 
Finished restore at 28-JUN-2017 09:27:17


And what I am interested in is ABSOLUTE_FUZZY_CHANGE# and CHECKPOINT_CHANGE#  column of that view.


  CHECKPOINT_CHANGE#: All changes up to the checkpoint change number are included in this backup
  
  ABSOLUTE_FUZZY_CHANGE#:  Highest change number in this backup


I used the following query to get the same result as given by RMAN restore preview command.

SQL&gt;   select max(absolute_fuzzy_change#) fuzz#, max(checkpoint_change#) chkpnt# from
                        (select file#, completion_time, checkpoint_change#, absolute_fuzzy_change# from v$backup_datafile
                        where  trunc(completion_time) = to_date('JUN-28-2017','MON-DD-YYYY')
                        and file# &lt;&gt; 0
                        order by completion_time desc
                        ); 

     FUZZ#    CHKPNT#
---------- ----------
7962156379 7962109213